Partitioning

• 26 Partitioning
• 26.1 Overview of Partitioning in MySQL
• 26.2 Partitioning Types
  • 26.2.1 RANGE Partitioning
  • 26.2.2 LIST Partitioning
  • 26.2.3 COLUMNS Partitioning
  • 26.2.4 HASH Partitioning
  • 26.2.5 KEY Partitioning
  • 26.2.6 Subpartitioning
  • 26.2.7 How MySQL Partitioning Handles NULL
• 26.3 Partition Management
• 26.4 Partition Pruning
• 26.5 Partition Selection
• 26.6 Restrictions and Limitations on Partitioning

How to automatically maintain a MySQL Table’s Partitions? | by Sanyam Aggarwal | Medium

GitHub - i-sanyam/MySQLPartitionKeeper: Automatically creates new monthly partition and removes oldest partition

26.6.2 Partitioning Limitations Relating to Storage Engines

• InnoDB foreign keys and MySQL partitioning are not compatible. Partitioned InnoDB tables cannot have foreign key references, nor can they have columns referenced by foreign keys. InnoDB tables which have or which are referenced by foreign keys cannot be partitioned.