查询表记录数及占用空间
SELECT TABLE_NAME,TABLE_ROWS,DATA_LENGTH,INDEX_LENGTH,TABLE_SCHEMA
FROM information_schema.TABLESWHERE TABLE_SCHEMA='xxxx'
order by TABLE_ROWS desc
查询表记录数及占用空间
SELECT TABLE_NAME,TABLE_ROWS,DATA_LENGTH,INDEX_LENGTH,TABLE_SCHEMA
FROM information_schema.TABLES