| 用途 | 库表清单与元数据盘点 |
|---|---|
| 命令 | SHOW DATABASES / USE / SHOW TABLES / SHOW TABLE STATUS |
| 元数据源 | information_schema.tables |
快速查看
快速查看
SHOW DATABASES;
USE appdb;
SHOW TABLES;
SHOW TABLE STATUS LIKE 'orders'\G按容量排序的表清单
按容量排序的表清单
SELECT table_name, engine, table_rows,
ROUND((data_length+index_length)/1024/1024,2) AS mb
FROM information_schema.tables
WHERE table_schema='appdb'
ORDER BY data_length+index_length DESC
LIMIT 20;SHOW DATABASES 只显示当前账号有权限的库；看不到某库不代表库不存在。