SHOW TABLE STATUS LIKE 'table_name';
關鍵回傳欄位:
Rows:估算行數(InnoDB 為近似值)Data_length:資料大小(Bytes)Index_length:索引大小(Bytes)Data_free:碎片空間Update_time:最後修改時間(MyISAM 準確,InnoDB 5.7+ 支援)Engine、Collation、Auto_increment 等SELECT
TABLE_NAME,
ENGINE,
TABLE_ROWS,
DATA_LENGTH,
INDEX_LENGTH,
(DATA_LENGTH + INDEX_LENGTH) AS total_size_bytes,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS total_size_mb,
UPDATE_TIME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'your_db' AND TABLE_NAME = 'your_table';
TABLE_ROWS 同為估算值,精確行數仍需 SELECT COUNT(*)。SELECT
TABLE_NAME,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS size_mb,
TABLE_ROWS,
UPDATE_TIME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'your_db'
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;
UPDATE_TIME 在 5.7.29 / 8.0.16 前可能為 NULL,需啟用 innodb_file_per_table 且執行過 ANALYZE TABLE。TABLES 顯示為多行,需按 PARTITION_NAME 聚合。SHOW TABLE STATUS 可能較慢,因需掃描索引統計資訊。單表快速看用 SHOW TABLE STATUS;批量巡檢、腳本化、自訂欄位用 information_schema.TABLES。兩者互補,掌握即可輕鬆掌握表空間與修改時間。