执行如下sql:
SELECT TABLE_NAME, CONCAT(TRUNCATE(data_length/1024/1024,2),' MB') AS data_size,table_rows
FROM information_schema.tables WHERE TABLE_SCHEMA = '数据库名' ORDER BY TABLE_ROWS desc
统计各表的记录数和各表所占用的内存量:
执行如下sql:
SELECT TABLE_NAME, CONCAT(TRUNCATE(data_length/1024/1024,2),' MB') AS data_size,table_rows
FROM information_schema.tables WHERE TABLE_SCHEMA = '数据库名' ORDER BY TABLE_ROWS desc
统计各表的记录数和各表所占用的内存量: