> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/partitioning-tables.md).

# Partitioning Tables

{% columns %}
{% column %}
{% content-ref url="/pages/X8LEsbtugVSgtExz89es" %}
[Partitioning Overview](/docs/server/server-usage/partitioning-tables/partitioning-overview.md)
{% 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="/pages/JSqlHKa5N6nlCj6vT54e" %}
[Partition Pruning and Selection](/docs/server/server-usage/partitioning-tables/partition-pruning-and-selection.md)
{% 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="/pages/8QvNljhc3q2xuk00lrSn" %}
[Partition Maintenance](/docs/server/server-usage/partitioning-tables/partition-maintenance.md)
{% 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="/pages/tmdcnt5rqJ5YJdHDIb5b" %}
[Partitioning Types Overview](/docs/server/server-usage/partitioning-tables/partitioning-types/partitioning-types-overview.md)
{% 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](/docs/server/server-usage/partitioning-tables/partitioning-types.md).
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/CBZt8ngJkxYWrSBPO1Ll" %}
[Partitioning Limitations](/docs/server/server-usage/partitioning-tables/partitioning-limitations.md)
{% 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="/pages/PfNHWqLpr7qk1LQ6GFDj" %}
[Partitions Files](/docs/server/server-usage/partitioning-tables/partitions-files.md)
{% 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="/pages/R6bmqDUDqCcKFX2clblB" %}
[Partitions Metadata](/docs/server/server-usage/partitioning-tables/partitions-metadata.md)
{% 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 %}