mysql 資料庫，表格儲存體 大小

標籤：

use information_schema;

-- 查詢一個資料庫儲存大小

select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘database nane‘; 85MB

-- 查詢一個表格儲存體大小

select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘database nane‘ and table_name=‘saleorder‘; 0.23MB/505

select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘database nane‘ and table_name=‘productset‘; 0.08MB/134

select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘database nane‘ and table_name=‘product‘; 0.19MB/487

select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘database nane‘ and table_name=‘productattribute‘; 0.11MB/711

select concat(round(sum(data_length/1024/1024),2),‘MB‘) as data from tables where table_schema=‘database nane‘ and table_name=‘userpictures‘; 0.02MB/30

mysql 資料庫，表格儲存體 大小