CODEWITHSUNDEEP
mysqlpartitioning
Manish Sapkal
Manish Sapkal

Reputation: 6231

How do know that mysql table is partitioned?

How do know that mysql table is partitioned? Is there any command which shows me how many partition my table?

thanks

Upvotes: 1

Views: 46

Answers (1)

Jhanvi
Jhanvi

Reputation: 5149

Try this on your mysql:

 SHOW VARIABLES LIKE '%partition%';

It will give you the value YES or NO. But to find the partitions for a particular table use this:

EXPLAIN PARTITIONS SELECT * FROM table;

Upvotes: 2

Related Questions