想查询库中表占用情况,可以执行下面sql:
select table_name, (data_length + index_length)/ (1024*1024) AS SIZE_MB from information_schema.TABLES where table_schema = '库名' order by SIZE_MB DESC
想查询库中表占用情况,可以执行下面sql:
select table_name, (data_length + index_length)/ (1024*1024) AS SIZE_MB from information_schema.TABLES where table_schema = '库名' order by SIZE_MB DESC