Chapter 10. Table Partitioning
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
Support for partitioning
All versions of MariaDB support version partitioning. However, there are two cases where partitioning is not available for a MariaDB ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
