MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide

8.14.4 Delayed-Insert Thread States

These thread states are associated with processing for DELAYED inserts (see Section 13.2.5.3, “INSERT DELAYED Statement”). Some states are associated with connection threads that process INSERT DELAYED statements from clients. Other states are associated with delayed-insert handler threads that insert the rows. There is a delayed-insert handler thread for each table for which INSERT DELAYED statements are issued.

States associated with a connection thread that processes an INSERT DELAYED statement from the client:

States associated with a delayed-insert handler thread that inserts the rows: