mariadb, mysql DB별 사이즈 조회

- DB별 table 개수, data/index 사이즈

SELECT
  count(*) TABLE_count,
  table_schema,
  concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA,
  concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx,
  concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size
FROM     information_schema.TABLES
GROUP BY table_schema
ORDER BY sum(data_length+index_length) DESC LIMIT 10;

 

- DB별 사이즈

SELECT table_schema , ROUND( SUM(data_length + index_length) / 1024 / 1024 , 2) "Mb" FROM information_schema.tables GROUP BY table_schema;