Partitoning Tables

Check if partitioning is available

mysql> show plugins;

+----------------------------+----------+--------------------+---------+---------+

| Name | Status | Type | Library | License |

+----------------------------+----------+--------------------+---------+---------+

| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |

Or use the information_schema.plugins table

mysql> SELECT

 -> PLUGIN_NAME as Name,

 -> PLUGIN_VERSION as Version,

 -> PLUGIN_STATUS as Status

 -> FROM INFORMATION_SCHEMA.PLUGINS

 -> WHERE PLUGIN_TYPE='STORAGE ENGINE';

+--------------------+---------+----------+

| Name | Version | Status |

+--------------------+---------+----------+

| binlog | 1.0 | ACTIVE |

| PERFORMANCE_SCHEMA | 0.1 | ACTIVE |

| MRG_MYISAM | 1.0 | ACTIVE |

| MEMORY | 1.0 | ACTIVE |

| InnoDB | 5.7 | ACTIVE |

| MyISAM | 1.0 | ACTIVE |

| CSV | 1.0 | ACTIVE |

| FEDERATED | 1.0 | DISABLED |

| partition | 1.0 | ACTIVE |

| BLACKHOLE | 1.0 | ACTIVE |

| ARCHIVE | 3.0 | ACTIVE |

+--------------------+---------+----------+