# 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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/server-usage/partitioning-tables.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.