More than 1 year has passed since last update.

mysqlで、partitionごとの行数とディスク使用量（推定）の確認方法

MySQL

Posted at 2022-07-13

select 
TABLE_SCHEMA, 
TABLE_NAME, 
PARTITION_NAME, 
TABLE_ROWS, (DATA_LENGTH + INDEX_LENGTH)/1024/1024/1024 as gb  
from information_schema.partitions 
where TABLE_SCHEMA = database() and TABLE_ROWS > 0 
order by DATA_LENGTH + INDEX_LENGTH desc;

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up