Comment 1 for bug 1649308

Revision history for this message
Damien Ciabrini (dciabrin) wrote :

Note that "SHOW status ..." is incorrect because it only returns the information related to the _current state_ of the cluster, like "is the local node in sync, how may nodes are connected to the cluster"...

The documentation show how to get information about the _available_ galera configuration flags. In that regard, the "SHOW VARIABLES " command is what we want.

the output seem to be "ugly" because of the value of variable "wsrep_provider_options", which is usually way bigger than the terminal's width. If you want to have a "cleaner" output, you should configure your pager accordingly, e.g.:

mysql -te "show variables like 'wsrep_%';" | less -S