Working with MySQL Partitions - Part 1 - Check if it is Enabled.

Working with MySQL Partitions - Part 1 - Check if it is Enabled.

Steps

Ascertain MySQL is 5.1.16 or above for proper working of partitioning.
Commands:

Show variables
Show plugins


e.g. :

SHOW VARIABLES LIKE '%partition%';

result:

+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| have_partitioning | YES |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> SHOW PLUGINS;
+------------+----------+----------------+---------+---------+
| Name | Status | Type | Library | License |
+------------+----------+----------------+---------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ndbcluster | DISABLED | STORAGE ENGINE | NULL | GPL |
+------------+----------+----------------+---------+---------+
11 rows in set (0.00 sec)

At this point if you have partition enabled if the above result indicates the availability of the service.

if you are doing a custom build please compile you need to compile the server using the --with-partition option.

Once you have done this you be start the server and check again if the service is enabled.

End of Step on.

Creation of partitions is a relatively easy process.