Advertisement
radeksmg

MariaDB

May 9th, 2020 (edited)
1,880
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.84 KB | None | 0 0
  1. SELECT table_schema "DB Name",
  2.         ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
  3. FROM information_schema.tables
  4. GROUP BY table_schema;
  5.  
  6. SELECT table_schema as `DB`, table_name AS `Table`,
  7.   ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)`
  8.   FROM information_schema.TABLES
  9.   ORDER BY (data_length + index_length) DESC;
  10.  
  11. ALTER TABLE tablename ENGINE=InnoDB
  12.  
  13.  
  14.  
  15. # Galera wsrep cluster status
  16.  
  17.  
  18. show global status where Variable_name IN(
  19.     'wsrep_cluster_size',
  20.     'wsrep_cluster_status',
  21.     'wsrep_incoming_addresses',
  22.     'wsrep_local_state_comment',
  23.     'wsrep_ready',
  24.     'wsrep_connected');
  25.  
  26.  
  27. 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