查询mysql数据库每张表大小
SELECT table_name,table_rows,data_length+index_length,
CONCAT(ROUND((data_length+index_length)/1024/1024,2),'MB')
DATA FROM information_schema.tables WHERE table_schema='compute_model'
AND table_name='employees';
SELECT table_name,table_rows,data_length+index_length,
CONCAT(ROUND((data_length+index_length)/1024/1024,2),'MB')
DATA FROM information_schema.tables WHERE table_schema='compute_model'
AND table_name='employees';