Advanced MySQL 8

Horizontally partitioning your data

Horizontal partitioning is used to divide your table records into multiple partitions.

All columns defined in a table are in each defined partition. The whole partition can be organized individually or as a set. For example, a table that contains a transaction as a subscription to your website for the entire year will be partitioned horizontally into twelve separate partitions, and each partition will contain one month's data.