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. |