How to view information of partitions in a table?

Question

How can I view partition details of a table, like how many partitions are there in a table and storage size of each partition?

found the answer: SELECT * FROM information_schema.partitions WHERE table_name ='table_name' — Ben, Aug 26 '14 at 14:34

score 61 · Answer 1 · answered May 09 '17 at 21:53

I recommend using Table Inspector in MySQL Workbench, it gives you lot of useful information including most data related to table partitions.

The data it displays is from the query:

SELECT * FROM information_schema.partitions WHERE TABLE_SCHEMA='your_database' AND TABLE_NAME = 'your_table' AND PARTITION_NAME IS NOT NULL

score 7 · Accepted Answer · answered Aug 26 '14 at 14:33

7

You can check the INFORMATION_SCHEMA to get this kind of information, try this page: Visit http://dev.mysql.com/doc/refman/5.1/en/partitioning-info.html

answered Aug 26 '14 at 14:33

vinibarr

2 Answers2