Skip navigation links

MySQL Forums :: Performance :: Query profile: sending data


Advanced Search

Re: Query profile: sending data
Posted by: James Brown ()
Date: January 12, 2009 05:42AM

After reading the source code, I think I have the answer:

mysql> show profile for query 1;
+--------------------+------------+
| Status | Duration |
+--------------------+------------+
| (initialization) | 0.00006300 |
| Opening tables | 0.00001400 |
| System lock | 0.00000600 |
| Table lock | 0.00001000 |
| init | 0.00002200 |
| optimizing | 0.00001100 |
| statistics | 0.00009300 |
| preparing | 0.00001700 |
| executing | 0.00000700 |
| Sending data | 0.00016800 |
| end | 0.00000700 |
| query end | 0.00000500 |
| freeing items | 0.00001200 |
| closing tables | 0.00000800 |
| logging slow query | 0.00000400 |
+--------------------+------------+

Each time means the time elapsed between the previous event and the new event. So, the line:
| Sending data | 0.00016800 |
means that 0.00016800 seconds elapsed between "executing" and "Sending data". It is, it takes 0.00016800 seconds to execute the query.

Options: ReplyQuote


Subject Views Written By Posted
Query profile: sending data 24401 James Brown 01/08/2009 10:05AM
Re: Query profile: sending data 14796 Rick James 01/09/2009 12:08AM
Re: Query profile: sending data 18242 James Brown 01/09/2009 05:40AM
Re: Query profile: sending data 13818 Rick James 01/12/2009 12:46AM
Re: Query profile: sending data 17341 James Brown 01/12/2009 05:42AM
Re: Query profile: sending data 10753 Cyril SCETBON 03/12/2009 04:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.