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