For information about partitioning support MySQL Community binaries provided by Sun Microsystems include MySQL was not built with partitioning support. (show in bold text in the example just given), then your version of Value YES listed in the output of an appropriateĭo not see the partition plugin listed with the | ndbcluster | DISABLED | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL | | partition | ACTIVE | STORAGE ENGINE | NULL | GPL | | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| Name | Status | Type | Library | License | You can also check the output of the SHOW Prior to MySQL 5.1.6, this variable was named Mysql> SHOW VARIABLES LIKE '%partition%' Whether your MySQL Server supports partitioning by means of a This chapter discusses MySQL's implementation of Partitioning Limitations Relating to Functions Partitioning Limitations Relating to Storage Engines 18.5.3. Partitioning Keys, Primary Keys, and Unique Keys 18.5.2. Restrictions and Limitations on Partitioning 18.5.1. Obtaining Information About Partitions 18.4.
How MySQL Partitioning Handles NULL 18.3.