MySQL查询整个库、指定库、指定表的存储使用大小

1：查询整个数据库，整个库的大小；单位转换为G:

 select concat(round(sum(DATA_LENGTH/1024/1024/1024),2),'G') as data  from information_schema.TABLES;

 

2：查询mysql数据库，某个库的大小:

select concat(round(sum(DATA_LENGTH/1024/1024/1024),2),'G') as data  from information_schema.TABLES where   table_schema = 'cxm_service_data_base';

 

3：查看库中某个表的大小:

select concat(round(sum(DATA_LENGTH/1024/1024/1024),2),'G') as data  from information_schema.TABLES where table_schema = 'cxm_service_data_base' and table_name = 'dk_sale_order_head';