# Partitioning Tables

{% columns %}
{% column %}
{% content-ref url="partitioning-tables/partitioning-overview" %}
[partitioning-overview](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitioning-overview)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete Partitioning Overview guide for MariaDB. Complete reference documentation for implementation, configuration, and usage for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="partitioning-tables/partition-pruning-and-selection" %}
[partition-pruning-and-selection](https://mariadb.com/docs/server/server-usage/partitioning-tables/partition-pruning-and-selection)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand how the optimizer automatically prunes irrelevant partitions and how to explicitly select partitions in your queries for efficiency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="partitioning-tables/partition-maintenance" %}
[partition-maintenance](https://mariadb.com/docs/server/server-usage/partitioning-tables/partition-maintenance)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Discover administrative tasks for managing partitions, such as adding, dropping, reorganizing, and coalescing them to keep your data optimized.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="partitioning-tables/partitioning-types/partitioning-types-overview" %}
[partitioning-types-overview](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitioning-types/partitioning-types-overview)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
An introduction to the various partitioning strategies available in MariaDB, helping you choose the right method for your data distribution needs. For a complete list of partitioning types, [see this page](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitioning-types).
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="partitioning-tables/partitioning-limitations" %}
[partitioning-limitations](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitioning-limitations)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This page outlines constraints when using partitioning, such as the maximum number of partitions and restrictions on foreign keys and query cache usage.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="partitioning-tables/partitions-files" %}
[partitions-files](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitions-files)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how MariaDB stores partitioned tables on the filesystem, typically creating separate .ibd files for each partition when using InnoDB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="partitioning-tables/partitions-metadata" %}
[partitions-metadata](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitions-metadata)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand how to retrieve metadata about partitions using the `INFORMATION_SCHEMA.PARTITIONS` table to monitor row counts and storage usage.
{% endcolumn %}
{% endcolumns %}