How to find if MySQL supports partitioning or not

Tutorials > Database Management Systems > MySQL > Tips And Tricks > How to find if MySQL supports partitioning or not

Discuss this tutorial here | Search www.geeksww.com for more tutorials here

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.

Discuss this tutorial here | Search www.geeksww.com for more tutorials here

Support Geeks Worldwide:

Link to us:

You can support us by putting a link to our website on your blog or website (code is below).

<a href="http://www.geeksww.com/">
Geeks Worldwide - Tutorials about Software Installation,
Configuration, Administration, Monitoring, Tools, Tips &
Tricks
</a>

OR a simple one.

<a href="http://www.geeksww.com/">
Geeks Worldwide - IT related Tutorials
</a>

Feedbacks:

We appreciate feedbacks and suggestions about our tutorials and Geeks Worldwide from readers. Please contact us using the form here and let us know what you think about the tutorial and the website in general.

Bookmark Us:

We are working on new features for the website, please keep visiting or bookmark us using your favourite bookmarking service.

Subscribe to RSS:

You can subscribe to our RSS feed here.