serelk
1/11/2017 - 11:35 AM

Mysql commands

show engine innodb status;
show open tables  where In_use  > 0 ;
show full processlist ; 


Percona
  SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';

- wsrep_cluster_status shows the primary status of the cluster component that the node is in,
  which you can use in determining whether your cluster is experiencing a partition.

  SHOW GLOBAL STATUS LIKE 'wsrep_cluster_status';