(資料圖)
本教程操作環(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. TABLESGROUP BY table_schemaORDER BY sum(data_length) DESC, sum(index_length) DESC;
查看所有數(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. TABLESORDER BY data_length DESC, index_length DESC;
查看指定數(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";
查看指定數(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;
推薦學習：《MySQL視頻教程》
以上就是mysql怎么查詢數(shù)據(jù)庫容量的詳細內(nèi)容，更多請關注php中文網(wǎng)其它相關文章！
關鍵詞：
營業(yè)執(zhí)照公示信息