Partitioning
Partitions and its use in MySQL
Reasons for using partitioning
Types of partitioning
Creating partitioned tables
Subpartitioning
Obtaining partition metadata
Modifying partitions to improve performance
Storage engine support of partitioning