MySQL Forums
Forum List  »  Performance

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
30323
January 08, 2009 10:05AM
17128
January 09, 2009 12:08AM
21289
January 09, 2009 05:40AM
15800
January 12, 2009 12:46AM
Re: Query profile: sending data
22985
January 12, 2009 05:42AM
12811
March 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.