差分

mysql> SELECT TABLE_SCHEMA, TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, TABLE_ROWS FROM INFORMATION_SCHEMAINFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME='jra_data';+--------------+------------+----------------+----------------------------+------------+| TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | PARTITION_ORDINAL_POSITION | TABLE_ROWS |+--------------+------------+----------------+----------------------------+------------+| jra | jra_data | p0 | 1 | 8 || jra | jra_data | p1 | 2 | 533260 || jra | jra_data | p2 | 3 | 69894 || jra | jra_data | p5 | 4 | 459127 || jra | jra_data | p7 | 5 | 1052898 || jra | jra_data | p9 | 6 | 5694 || jra | jra_data | pA | 7 | 707408 || jra | jra_data | pB | 8 | 10085 |+--------------+------------+----------------+----------------------------+------------+8 rows in set (0.06 sec)