content_image/760006.jpg content_image/760002.jpg content_image/760003.jpg content_image/760007.jpg
Both this parameter and StartFailRetryDelay  are ignored unless StopOnError  is equal to 0. 

NDB index statistics parameters. The parameters in the following list relate to NDB index statistics generation. 

• IndexStatAutoCreate 

<img src='content_image/760006.jpg'>

Enable (set equal to 1) or disable (set equal to 0) automatic statistics collection when indexes are created. Disabled by default. 

• IndexStatAutoUpdate 

<img src='content_image/760002.jpg'>

Enable (set equal to 1) or disable (set equal to 0) monitoring of indexes for changes and trigger automatic statistics updates these are detected. The amount and degree of change needed to trigger the updates are determined by the settings for the IndexStatTriggerPct  and IndexStatTriggerScale  options. 

• IndexStatSaveSize 

<img src='content_image/760003.jpg'>

Maximum space in bytes allowed for the saved statistics of any given index in the NDB  system tables and in the mysqld  memory cache. 

At least one sample is always produced, regardless of any size limit. This size is scaled by IndexStatSaveScale . 

The size specified by IndexStatSaveSize  is scaled by the value of IndexStatTriggerPct  for a large index, times 0.01. This is further multiplied by the logarithm to the base 2 of the index size. Setting IndexStatTriggerPct  equal to 0 disables the scaling effect. 

• IndexStatSaveScale 

<img src='content_image/760007.jpg'>

