查看Mysql数据库各张表的信息

SELECT table_name, data_length + index_length AS len, table_rows,

    CONCAT(ROUND((data_length + index_length)/1024/1024,2),'MB') AS datas

FROM information_schema.tables

WHERE table_schema = '数据库名'

ORDER BY len DESC;