MySql表数据统计及占用内存分析

explain select * from student where id >0;

SHOW VARIABLES LIKE 'datadir';

SELECT 
    table_schema AS 'Database', 
    table_name AS 'Table', 
    round(((data_length + index_length) / 1024 / 1024), 2) AS 'Size in MB' 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;