O'Reilly logo

Mastering MariaDB by Federico Razzoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required