Lists the Insert Delayed configuration metrics and provides a brief description of each.
Table 5.12 Insert Delayed Configuration Metrics
| Name | Description |
|---|---|
| Insert Limit (Total) | After inserting delayed_insert_limit delayed rows, the INSERT DELAYED handler thread checks whether there are any SELECT statements pending. |
| Insert Timeout (Total) | How many seconds an INSERT DELAYED handler thread should wait for INSERT statements before terminating. |
| Max Delayed Threads (Total) | Do not start more than this number of threads to handle INSERT DELAYED statements. |
| Queue Size (Total) | This is a per-table limit on the number of rows to queue when handling INSERT DELAYED statements. |