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.

Please feel free to use the comments form below if you have any questions or need more explanation on anything.

Tags

mysql, database, partitioning, load-balancing,

Popular Searches

php, linux, mysql, ubuntu, mysql mysql, tools, install mysql, gearman, source code, java

more>>

Comments (write a comment):

0 comments so far. Be the first one to leave a comment on this article.

 

Comment
 

 
| Members | Support Us | Using this site means you accept its terms | Contact Us | Site Map |