Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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');"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement