博客 / 列表

玄機 - 查看mysql數據庫各個庫資源使用情況

select table_schema as '數據庫', sum(table_rows) as '記錄數', sum(truncate(data_length/1024/1024, 2)) as '數據容量(MB)', sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)' from information_sc

MySQL , 資源