SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema; 

SELECT table_schema as `DB`, table_name AS `Table`, 
  ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` 
  FROM information_schema.TABLES 
  ORDER BY (data_length + index_length) DESC;

ALTER TABLE tablename ENGINE=InnoDB



# Galera wsrep cluster status


show global status where Variable_name IN(
	'wsrep_cluster_size',
	'wsrep_cluster_status',
	'wsrep_incoming_addresses',
	'wsrep_local_state_comment',
	'wsrep_ready',
	'wsrep_connected');


mysql --execute="show global status where Variable_name IN('wsrep_cluster_size', 'wsrep_cluster_status', 'wsrep_incoming_addresses', 'wsrep_local_state_comment', 'wsrep_ready', 'wsrep_connected');"