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 do not guarantee a response.

IMPORTANT: You must thoroughy test any instructions on a production-like test environment first before trying anything on production systems. And, make sure it is tested for security, privacy, and safety. See our terms here.