Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 223.8Kb
HTML Download (Zip) - 231.3Kb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Configuration Metrics  /  Insert Delayed Configuration Metrics

7.16 Insert Delayed Configuration Metrics

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

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