MySQL 8 Administrator???s Guide

Restrictions and limitations in partitioning

Stored procedures or functions, user defined functions or plugins, and user variables or declared variables are restricted in partitioning expressions. There are also several restrictions and limitations applicable to partitioning given in the detailed section.

See the following list for some of the advantages of partitioning:

• Partitioning facilitates storing more data in one table than can be held on a file system partition or single disk.
• Data that has become useless can be removed easily by dropping a partition or partitions that only contain the useless data. In some cases where specific data is required to be added separately, this can be done easily with partitioning in single or multiple ...