Delayed Insert Connection Thread States

This article documents thread states that are related to the connection thread that processes INSERT DELAYED statements.

These correspond to the STATE values listed by the SHOW PROCESSLIST statement or in the Information Schema PROCESSLIST Table as well as the PROCESSLIST_STATE value listed in the Performance Schema threads Table.

allocating local tablePreparing to allocate rows to the delayed-insert handler thread. Follows from the got handler lock state.
Creating delayed handlerCreating a handler for the delayed-inserts.
got handler lockLock to access the delayed-insert handler thread has been received. Follows from the waiting for handler lock state and before the allocating local table state.
got old tableThe initialization phase is over. Follows from the waiting for handler open state.
storing row into queueAdding new row to the list of rows to be inserted by the delayed-insert handler thread.
waiting for delay_listInitializing (trying to find the delayed-insert handler thread).
waiting for handler insertWaiting for new inserts, as all inserts have been processed.
waiting for handler lockWaiting for delayed insert-handler lock to access the delayed-insert handler thread.
waiting for handler openWaiting for the delayed-insert handler thread to initialize. Follows from the Creating delayed handler state and before the got old table state.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.