Administering partitioned tables
Partitions support the same maintenance operations that are supported for regular tables, such as repairing and defragmenting, plus other specific operations. MariaDB provides a set of SQL extensions that allow us to perform all necessary maintenance tasks. It also provides some system tables that store metadata about the partitions. This section covers these topics.
Obtaining information about partitions
MariaDB provides several ways to obtain information about partitions.
The output of SHOW TABLE STATUS and the Create_options column contains the partitioned string for partitioned tables.
The easiest way to get human-readable information about partitions' definitions is running SHOW CREATE TABLE.
The PARTITIONS table ...
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.
