Skip to main content

Sending data

Short Description

The thread is reading and processing rows for a SELECT statement, and sending data to the client.

Detailed Description

Prior to MySQL 8.0.17

The thread is reading and processing rows for a SELECT statement, and sending data to the client. Because operations occurring during this state tend to perform large amounts of disk access (reads), it is often the longest-running state over the lifetime of a given query.

MySQL 8.0.17 and later

This state is no longer indicated separately, but rather is included in the Executing state.

How to reduce this wait

  • Look at the SQL statements waiting on 'Sending data' and see if they can be optimised by using indexes or rewriting to make them more efficient.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.

DBmarlin Trial