查看数据库前10张大表select TABLE_NAME,round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2) as data_size_MB,TABLE_ROWS from information_schema.TABLES where TABLE_SCHEMA='数据库名' order by data_size_MB desc limit 10;-- 表分析,当表空间所占用实际大小与统计信息由较大差异时,考虑可能为频繁对大表执行DML操作(增、删、改)导致存储