X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2023 MariaDB. All rights reserved.

  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Services
  • Pricing
  • Resources
  • About Us
  • Download
Knowledge Base » MariaDB Server Documentation » MariaDB Administration » Partitioning Tables
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
Ask a question here View 2 questions

Partitioning Tables

A huge table can be split into smaller subsets. Both data and indexes are partitioned.

  • Partitioning Overview

    A table partitioning overview
  • Partitioning Types

    A partitioning type determines how a table rows are distributed across partitions.
  • Partition Pruning and Selection

    Partition pruning is when the optimizer knows which partitions are relevant for the query.
  • Partition Maintenance

    For time series (includes list of PARTITION uses)
  • 1

    Partitioning Limitations

    Limitations applying to partitioning in MariaDB.
  • Partitions Files

    A partitioned table is stored in multiple files
  • Partitions Metadata

    How to obtain information about partitions definition
There are 2 related questions.
  • ← Server Monitoring & Logs
  • ↑ MariaDB Administration ↑
  • MariaDB Audit Plugin →
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
  • ↑ MariaDB Administration ↑
  • Getting, Installing, and Upgrading MariaDB
  • User & Server Security
  • Backing Up and Restoring Databases
  • Server Monitoring & Logs
  • Partitioning Tables
  • MariaDB Audit Plugin
  • Variables and Modes
  • Copying Tables Between Different MariaDB Databases and MariaDB Servers
Products
  • MariaDB Platform
  • MariaDB SkySQL
  • Pricing
  • Download MariaDB
Services
  • Remote DBA
  • SkyDBA
  • Enterprise Architect
  • Technical Support
  • Migration Practice
  • Consulting
  • Training
Resources
  • Documentation
  • Developers
  • Blog
  • Support
  • OpenWorks
  • Customer Stories
  • Events
  • MariaDB Roadshow
About
  • Contact
  • Leadership
  • Partners
  • Newsroom
  • Investors
  • Careers
  • Trust Center
  • Vulnerability Reporting
Contact

Subscribe to our newsletter!

  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2023 MariaDB. All rights reserved.