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.
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.
PARTITIONS table ...