How to find if MySQL supports partitioning or not?

You can execute the MYQSL query below to find out if your server supports partitioning or not.

SHOW VARIABLES LIKE '%partition%';

If MySQL returns with YES for have_partitioning (called have_partition_engine prior to version 5.1.6) variable that means you have partitioning support available on your database server.

Did this tutorial help a little? How about buy me a cup of coffee?

Buy me a coffee at

Please feel free to use the comments form below if you have any questions or need more explanation on anything. I recommend thoroughy testing on a production-like test system first before moving to production.