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
27487
January 08, 2009 10:05AM
16082
January 09, 2009 12:08AM
19854
January 09, 2009 05:40AM
14841
January 12, 2009 12:46AM
Re: Query profile: sending data
20149
January 12, 2009 05:42AM
11789
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.