Skip to main content

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.

More lessons in Partitioning