人妻精品在线观看一区二区三区,蜜臀av精品一区二区三区网站,中文一区二区三区亚洲欧美,熟女人妇精品一区二区,人妻av在线观看视频,欧美日韩国产三级精品网站,黄色免费网站直接进入,超碰公开福利正在播放,国产毛片乡下农村妇女毛片

mysql怎么查詢數(shù)據(jù)庫容量

來源：php中文網(wǎng) | 2023-03-25 18:05:17 |


(資料圖)

本教程操作環(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;

推薦學(xué)習(xí)：《MySQL視頻教程》

以上就是mysql怎么查詢數(shù)據(jù)庫容量的詳細(xì)內(nèi)容，更多請關(guān)注php中文網(wǎng)其它相關(guān)文章！

關(guān)鍵詞：