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?
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.
tags cloud
popular searches
free download for mysql database server 5.1.5, bison, gearman, php, linux, install cairo, java, install mysql, laptop, mysql, mysql initialization, mysql mysql, ubuntu, source code, tools
Similar Tutorials:
- opensource-db-tools - A set of open source tools for MySQL
- Download all Aspersa MySQL tools/scripts through a single command
- Install MySQL Server 5.0 and 5.1 from source code
- Fast, parallel restore from SQL dumps (mysqldump) for MySQL
- Seeing indexes in a MySQL table
Tutorials in 'Database Management Systems > MySQL' (more):
- How to delete rows in table when PK is referenced in another table
- Unique primary keys(PKs) for MySQL using Redis
- How to rename MySQL DB by moving tables
- How to set innodb_flush_log_at_timeout in MySQL 5.6?
- Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
Comments (write a comment):
0 comments so far. Be the first one to leave a comment on this article.