使用SQL命令查看MYSQL資料庫大小

標籤：l命令   --   orm   schema   weight   inf   IV   form   結果   

mysql>   mysql> use information_schema ;  /*切換到information_schema資料下*/     Database changed  mysql>   mysql> select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables;  /*查詢所有資料大小*/     +----------+  | data     |  +----------+  | 123.68MB |  +----------+  1 row in set (0.36 sec)    mysql> select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘hrkip‘;  /*查詢資料庫名稱為“hrkip”的資料大小*/   +--------+  | data   |  +--------+  | 8.65MB |  +--------+  1 row in set (0.00 sec)    mysql> select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘hrkip‘ and table_name=‘jx_lsjl‘ ;  /*查詢資料庫名稱為“hrkip”，表名為“ jx_lsjl”的資料大小*/   +--------+  | data   |  +--------+  | 6.77MB |  +--------+  1 row in set (0.00 sec)    

 

備忘 ：

data_length ：儲存資料大小

data_length/1024/1024：將位元組轉換為MB

round(sum(data_length/1024/1024),2)：取兩位小數

concat(round(sum(data_length/1024/1024),2),‘MB‘) ：給計算結果追加單位 “MB”

使用SQL命令查看MYSQL資料庫大小