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;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29067253/viewspace-2134534/
,如需转载,请注明出处,否则将追究法律责任。