Why Partition?
Learn Why Partition? (Partitioning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Partitioning splits one logical table into several physical pieces (partitions) by a rule on a column. Applications still query one table name; MySQL decides which pieces hold the rows. In MySQL each partition is its own InnoDB tablespace file.