![](https://csdnimg.cn/release/download_crawler_static/10483065/bg14.jpg)
MySQL 8.0 Reference Manual
Pre-General
Availability
Draft xx
Pre-General
Availability
Draft
21.9.7 Group Replication Performance .......................................................................... 3131
22 InnoDB Cluster ........................................................................................................................ 3135
22.1 Introducing InnoDB Cluster ............................................................................................ 3135
22.2 Creating an InnoDB Cluster ........................................................................................... 3137
22.2.1 Deployment Scenarios ........................................................................................ 3137
22.2.2 InnoDB Cluster Requirements ............................................................................. 3138
22.2.3 Methods of Installing .......................................................................................... 3138
22.2.4 Sandbox Deployment of InnoDB Cluster .............................................................. 3139
22.2.5 Production Deployment of InnoDB Cluster ........................................................... 3142
22.2.6 Adopting a Group Replication Deployment ........................................................... 3150
22.3 Using MySQL Router with InnoDB Cluster ..................................................................... 3151
22.4 Working with InnoDB Cluster ......................................................................................... 3154
22.5 Known Limitations ......................................................................................................... 3165
23 Partitioning .............................................................................................................................. 3167
23.1 Overview of Partitioning in MySQL ................................................................................. 3168
23.2 Partitioning Types ......................................................................................................... 3171
23.2.1 RANGE Partitioning ............................................................................................ 3173
23.2.2 LIST Partitioning ................................................................................................. 3177
23.2.3 COLUMNS Partitioning ....................................................................................... 3179
23.2.4 HASH Partitioning .............................................................................................. 3187
23.2.5 KEY Partitioning ................................................................................................. 3191
23.2.6 Subpartitioning ................................................................................................... 3192
23.2.7 How MySQL Partitioning Handles NULL .............................................................. 3194
23.3 Partition Management ................................................................................................... 3198
23.3.1 Management of RANGE and LIST Partitions ........................................................ 3199
23.3.2 Management of HASH and KEY Partitions .......................................................... 3206
23.3.3 Exchanging Partitions and Subpartitions with Tables ............................................ 3207
23.3.4 Maintenance of Partitions ................................................................................... 3215
23.3.5 Obtaining Information About Partitions ................................................................. 3216
23.4 Partition Pruning ........................................................................................................... 3218
23.5 Partition Selection ......................................................................................................... 3221
23.6 Restrictions and Limitations on Partitioning ..................................................................... 3227
23.6.1 Partitioning Keys, Primary Keys, and Unique Keys ............................................... 3232
23.6.2 Partitioning Limitations Relating to Storage Engines ............................................. 3236
23.6.3 Partitioning Limitations Relating to Functions ....................................................... 3237
24 Stored Programs and Views ..................................................................................................... 3239
24.1 Defining Stored Programs ............................................................................................. 3240
24.2 Using Stored Routines (Procedures and Functions) ........................................................ 3241
24.2.1 Stored Routine Syntax ........................................................................................ 3242
24.2.2 Stored Routines and MySQL Privileges ............................................................... 3242
24.2.3 Stored Routine Metadata .................................................................................... 3243
24.2.4 Stored Procedures, Functions, Triggers, and LAST_INSERT_ID() ......................... 3243
24.3 Using Triggers .............................................................................................................. 3243
24.3.1 Trigger Syntax and Examples ............................................................................. 3244
24.3.2 Trigger Metadata ................................................................................................ 3248
24.4 Using the Event Scheduler ............................................................................................ 3248
24.4.1 Event Scheduler Overview .................................................................................. 3249
24.4.2 Event Scheduler Configuration ............................................................................ 3250
24.4.3 Event Syntax ...................................................................................................... 3252
24.4.4 Event Metadata .................................................................................................. 3252
24.4.5 Event Scheduler Status ...................................................................................... 3253
24.4.6 The Event Scheduler and MySQL Privileges ........................................................ 3253
24.5 Using Views .................................................................................................................. 3256
24.5.1 View Syntax ....................................................................................................... 3257