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');"
Comments
0 B
|👍
/👎
0 B
|👍
/👎