What does it mean when MySQL is in the state “Sending data”?

by

This is quite a misleading status. It should be called “reading and filtering data”.

This means that MySQL has some data stored on the disk (or in memory) which is yet to be read and sent over. It may be the table itself, an index, a temporary table, a sorted output etc.

If you have a 1M records table (without an index) of which you need only one record, MySQL will still output the status as “sending data” while scanning the table, despite the fact it has not sent anything yet.

MySQL 8.0.17 and later: This state is no longer indicated separately, but rather is included in the Executing state.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  3. How do you set a default value for a MySQL Datetime column?
  4. Compare two MySQL databases [closed]
  5. MySQL – Trigger for updating same table after insert
  6. Storing image in database directly or as base64 data?
  7. Implementation of Levenshtein distance for mysql/fuzzy search?
  8. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  9. MySQL – Operand should contain 1 column(s)
  10. Restore table structure from frm and ibd files
  11. Can a number be used to name a MySQL table column?
  12. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  13. mysql pivot/crosstab query
  14. MySQL: Split comma separated list into multiple rows
  15. UNION query with codeigniter’s active record pattern
  16. How to start MySQL with –skip-grant-tables?
  17. When to use MongoDB or other document oriented database systems? [closed]
  18. Remove Primary Key in MySQL
  19. MySQL grant all privileges to database except one table
  20. Mysql select recursive get all child with multiple level
  21. MySQL Error: Incorrect usage of UPDATE and LIMIT
  22. Mysql insert into 2 tables
  23. How do you stop MySQL on a Mac OS install?
  24. Replace null with 0 in MySQL
  25. What’s mysql’s “BETWEEN” performance over..?
  26. MySQL: set field default value to other column
  27. CREATE command denied to user？
  28. What is the MAX number if I store int(255) in MySQL?
  29. Deleting a row based on the max value
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment