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 in the INFORMATION_SCHEMA database contains information about the partitions. Subpartitioned tables have a row for each subpartition; other tables have a row for each partition. Some columns are identical to the columns in the TABLES table. The most...
