How to check partition details of MySQL table

Here, We can check the partition details of the MySQL table, like how many partitions are there in a table and storage size of each partition? Know more about MYSQL Partitioning : What is and HOW To ? RANGE Partitioning in MySQL

We can check this from the below query needs to run on any MySQL client.

SELECT * FROM information_schema.partitions WHERE TABLE_SCHEMA=’your_database_name’ AND TABLE_NAME = ‘your_table_name‘ AND PARTITION_NAME IS NOT NULL

Please replace your_database_name with the exact database name and your_table_name with to exact table name.

How to check partition table in detail in MySQL

Leave a Reply