Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb


7.17 Insert Delayed Configuration Metrics

Lists the Insert Delayed configuration metrics and provides a brief description of each.

Table 7.17 Insert Delayed Configuration Metrics

NameDescription
Insert LimitAfter inserting delayed_insert_limit delayed rows, the INSERT DELAYED handler thread checks whether there are any SELECT statements pending.
Insert TimeoutHow many seconds an INSERT DELAYED handler thread waits for INSERT statements before terminating.
Max Delayed ThreadsDo not start more than this number of threads to handle INSERT DELAYED statements.
Queue SizeThis is a per-table limit on the number of rows to queue when handling INSERT DELAYED statements.