站長資訊網
mysql查詢數據庫容量的方法：1、打開DOS窗口，然后進入mysql的bin目錄下；2、執行“SELECT table_schema AS 'shujuku',table_name AS 'biaoming',table_rows AS 'jilushu',TRUNCATE (data_length / 1024 / 1024, 2) …”語句即可查看所有數據庫各表容量。
本教程操作環境：Windows10系統、MySQL5.7版、Dell G3電腦。
mysql怎么查詢數據庫容量？
MySql查看數據庫及表容量大小并排序
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_schema. TABLES GROUP BY table_schema ORDER BY sum(data_length) DESC, sum(index_length) DESC;
登錄后復制
查看所有數據庫各表容量
SELECT table_schema AS '數據庫', table_name AS '表名', table_rows AS '記錄數', TRUNCATE (data_length / 1024 / 1024, 2) AS '數據容量(MB)', TRUNCATE (index_length / 1024 / 1024, 2) AS '索引容量(MB)' FROM information_schema. TABLES ORDER BY data_length DESC, index_length DESC;
登錄后復制
查看指定數據庫容量
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_schema.tables where table_schema = 'your_table_name';
登錄后復制
查看指定數據庫各表容量
SELECT table_schema AS '數據庫', table_name AS '表名', table_rows AS '記錄數', TRUNCATE ( data_length / 1024 / 1024, 2 ) AS '數據容量(MB)', TRUNCATE ( index_length / 1024 / 1024, 2 ) AS '索引容量(MB)' FROM information_schema.TABLES WHERE table_schema = '指定的庫名' ORDER BY data_length DESC, index_length DESC;
登錄后復制
推薦學習：《MySQL視頻教程》
