Dividing a large table into smaller, physically separate pieces based on a partition key. MySQL partition pruning can dramatically speed up queries that filter on the partition key by scanning only relevant partitions.
