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