查询mysql数据库中各个表所占空间大小以及索引大小
use information_schame;
select TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024/1024,INDEX_LENGTH/1024/1024/1024 FROM tables where TABLE_SCHEMA = 'robotframework';
use information_schame;
select TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024/1024,INDEX_LENGTH/1024/1024/1024 FROM tables where TABLE_SCHEMA = 'robotframework';