NDB Cluster Configuration Files NDB Cluster System Variables Important 4173 The recommended maximum value for this variable is 1000, which means that the check is performed once per second. A larger value means that the check is performed and possibly invalidated due to The number of milliseconds that elapse between checks of NDB Cluster SQL nodes by the MySQL query cache. Setting this to 0 (the default and minimum value) means that the query cache checks for validation on every query. This variable does not affect inserts performed using  INSERT ... SELECT . This variable affects only the number of  AUTO_INCREMENT  IDs that are fetched between statements; within a given statement, at least 32 IDs are obtained at a time. Determines the probability of gaps in an autoincremented column. Set it to  1  to minimize this. Setting it to a high value for optimization makes inserts faster, but decreases the likelihood of consecutive autoincrement numbers being used in a batch of inserts. • ndb_cache_check_time • ndb_autoincrement_prefetch_sz This section provides detailed information about MySQL server system variables that are specific to NDB Cluster and the  NDB  storage engine. For system variables not specific to NDB Cluster, see Section 5.1.8, “Server System Variables” . For general information on using system variables, see Section 5.1.9, “Using System Variables” . Command-Line Format --ndb-autoincrement-prefetch-sz=# System Variable ndb_autoincrement_prefetch_sz Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value ( ≥  8.0.19-ndb-8.0.19) 512 Default Value ( ≤  8.0.18-ndb-8.0.18) 1 Minimum Value 1 Maximum Value 65536 Command-Line Format --ndb-cache-check-time=# Deprecated Yes System Variable ndb_cache_check_time Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 0