> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/buffers-caches-and-threads/thread-states/delayed-insert-handler-thread-states.md).

# Delayed Insert Handler Thread States

This article documents thread states that are related to the handler thread that inserts the results of [INSERT DELAYED](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert-delayed.md) statements.

These correspond to the `STATE` values listed by the [SHOW PROCESSLIST](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-processlist.md) statement or in the [Information Schema PROCESSLIST Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-processlist-table.md) as well as the `PROCESSLIST_STATE` value listed in the [Performance Schema threads Table](/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-threads-table.md).

| Value              | Description                                                                                       |
| ------------------ | ------------------------------------------------------------------------------------------------- |
| insert             | About to insert rows into the table.                                                              |
| reschedule         | Sleeping in order to let other threads function, after inserting a number of rows into the table. |
| upgrading lock     | Attempting to get lock on the table in order to insert rows.                                      |
| Waiting for INSERT | Waiting for the delayed-insert connection thread to add rows to the queue.                        |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}