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
30352
January 08, 2009 10:05AM
17134
January 09, 2009 12:08AM
21299
January 09, 2009 05:40AM
15810
January 12, 2009 12:46AM
Re: Query profile: sending data
23000
January 12, 2009 05:42AM
12818
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.