MySQL 8.0 Reference Manual xxii 23.6.10 NDB Cluster Replication: Bidrectional and Circular Replication ............................ 4637 23.6.11 NDB Cluster Replication Conflict Resolution ...................................................... 4641 23.7 NDB Cluster Release Notes .......................................................................................... 4654 24 Partitioning .............................................................................................................................. 4655 24.1 Overview of Partitioning in MySQL ................................................................................. 4656 24.2 Partitioning Types ......................................................................................................... 4659 24.2.1 RANGE Partitioning ............................................................................................ 4661 24.2.2 LIST Partitioning ................................................................................................. 4665 24.2.3 COLUMNS Partitioning ....................................................................................... 4667 24.2.4 HASH Partitioning .............................................................................................. 4675 24.2.5 KEY Partitioning ................................................................................................. 4678 24.2.6 Subpartitioning ................................................................................................... 4680 24.2.7 How MySQL Partitioning Handles NULL .............................................................. 4681 24.3 Partition Management ................................................................................................... 4686 24.3.1 Management of RANGE and LIST Partitions ........................................................ 4687 24.3.2 Management of HASH and KEY Partitions .......................................................... 4693 24.3.3 Exchanging Partitions and Subpartitions with Tables ............................................ 4694 24.3.4 Maintenance of Partitions ................................................................................... 4701 24.3.5 Obtaining Information About Partitions ................................................................. 4703 24.4 Partition Pruning ........................................................................................................... 4705 24.5 Partition Selection ......................................................................................................... 4708 24.6 Restrictions and Limitations on Partitioning ..................................................................... 4714 24.6.1 Partitioning Keys, Primary Keys, and Unique Keys ............................................... 4720 24.6.2 Partitioning Limitations Relating to Storage Engines ............................................. 4724 24.6.3 Partitioning Limitations Relating to Functions ....................................................... 4725 25 Stored Objects ......................................................................................................................... 4727 25.1 Defining Stored Programs ............................................................................................. 4728 25.2 Using Stored Routines .................................................................................................. 4729 25.2.1 Stored Routine Syntax ........................................................................................ 4730 25.2.2 Stored Routines and MySQL Privileges ............................................................... 4730 25.2.3 Stored Routine Metadata .................................................................................... 4731 25.2.4 Stored Procedures, Functions, Triggers, and LAST_INSERT_ID() ......................... 4731 25.3 Using Triggers .............................................................................................................. 4732 25.3.1 Trigger Syntax and Examples ............................................................................. 4732 25.3.2 Trigger Metadata ................................................................................................ 4736 25.4 Using the Event Scheduler ............................................................................................ 4737 25.4.1 Event Scheduler Overview .................................................................................. 4737 25.4.2 Event Scheduler Configuration ............................................................................ 4738 25.4.3 Event Syntax ...................................................................................................... 4740 25.4.4 Event Metadata .................................................................................................. 4740 25.4.5 Event Scheduler Status ...................................................................................... 4741 25.4.6 The Event Scheduler and MySQL Privileges ........................................................ 4742 25.5 Using Views .................................................................................................................. 4744 25.5.1 View Syntax ....................................................................................................... 4745 25.5.2 View Processing Algorithms ................................................................................ 4745 25.5.3 Updatable and Insertable Views .......................................................................... 4747 25.5.4 The View WITH CHECK OPTION Clause ............................................................ 4749 25.5.5 View Metadata ................................................................................................... 4750 25.6 Stored Object Access Control ........................................................................................ 4750 25.7 Stored Program Binary Logging ..................................................................................... 4754 25.8 Restrictions on Stored Programs ................................................................................... 4761 25.9 Restrictions on Views .................................................................................................... 4764 26 INFORMATION_SCHEMA Tables ............................................................................................ 4767 26.1 Introduction ................................................................................................................... 4769