Checking whether your MySQL server supports partitioning?

Before implementing any user defined partitioning in MySQL we need to make sure whether your mysql server supports partitioning.

Finding out the same in your server will be simple.

Type SHOW VARIABLES LIKE '%partition%'; on the command prompt as shown below.

mysql> SHOW VARIABLES LIKE '%partition%';

If your server returns have_partitioning variable to YES then your server supports this feature.