Status statistics on profile report

[Alexander Romanchenko]

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.