MySQL 8 Administrator???s Guide

HASH partitioning

The primary intention behind introducing HASH partitioning is to ensure an even distribution of date among the number of partitions defined. So, with HASH partitioning you need to specify the column value or the expression evaluating the column value being hashed, and the number of partitions into which the partitioned table is to be divided.

For defining HASH partitioning in table you need to specify the PARTITION BY HASH (expr) clause in the table definition, where expr is the expression that will return the integer, and additionally you need to specify the number of partitions with PARTITIONS n, where n is a positive integer number that stands for the number of partitions.

The following definition creates a table with ...