When a table becomes too large, queries on that table become slow.
One possible solution is table partitioning. This technique involves splitting a table into several physical files or tablespaces. Each file contains a fraction of the table data and thus becomes faster to read. Both read and write access to individual partitions will be much faster.
In this chapter, we will discuss:
Partitioning types supported by MariaDB
Subpartitioning
How to split each partition into multiple files
Maintenance of partitioned tables
How the optimizer takes advantage of partitioning