R1-012 MySQL查看表大小

R1-012 MySQL查看表大小

路途中的人2012
2017-03-01 20:07:36
MySQL
原创

select table_name,table_size
from
(select table_name,(data_length+index_length)/1024/1024/1024 table_size
from
information_schema.tables ) t1
order by table_size
desc limit 10;