MySQL Forums
Forum List  »  Performance

Status statistics on profile report
Posted by: Alexander Romanchenko
Date: April 29, 2008 08:19AM

Hi All,

I novice in MySQL. I have a bad perfomance on some queries. When I try to profile it I see that most time queries have status statistics.
For example:
+----------------------+-----------+
| Status | Duration |
+----------------------+-----------+
| (initialization) | 0.0005462 |
| checking permissions | 0.0000102 |
| Opening tables | 0.0118362 |
| System lock | 0.0000165 |
| Table lock | 0.000026 |
| init | 0.0008377 |
| optimizing | 0.0000812 |
| statistics | 55.124635 |
| preparing | 0.0001045 |
| executing | 0.000004 |
| Sending data | 0.0025807 |
| end | 0.0000092 |
| query end | 0.000006 |
| freeing items | 0.000042 |
| closing tables | 0.000012 |
| logging slow query | 0.000004 |
+----------------------+-----------+
May be someone describe me where a problem here, and what this state mean?

MySQL 5.0.51, with default settings



Edited 1 time(s). Last edit at 04/29/2008 08:26AM by Alexander Romanchenko.

Options: ReplyQuote


Subject
Views
Written By
Posted
Status statistics on profile report
2408
April 29, 2008 08:19AM


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.