In this section, you will understand different types of partitioning and also the purpose of using specific partitioning. The following is a list of the partitioning types that are available in MySQL 8 :
- RANGE partitioning
- LIST partitioning
- COLUMNS partitioning
- HASH partitioning
- KEY partitioning
- Subpartitioning
In addition to the above list, we will also see NULLhandling in MySQL 8 Partitioning in detailed section.
A very common use case for database partitioning is segregating data by date. MySQL 8 does not support date partitioning, which some database systems provide explicitly, but it is easy to create partitioning schemes with date, time, or datetime columns, or that are based on date/time related expressions that evaluate values from these column types.
You can use the date, time, or datetime types as column values for partition columns without any...