This is a discussion on understanding output of SHOW PROFILE within the MySQL Database forums, part of the Database Forums category; Hi, I'm trying to tune a couple of queries on a website of mine. Now if I enable profiling, ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hi,
I'm trying to tune a couple of queries on a website of mine. Now if I enable profiling, perform the query and ask SHOW PROFILE, mysql gives me the following output: mysql> show profile; +--------------------+------------+ | Status | Duration | +--------------------+------------+ | Opening tables | 0.00015700 | | System lock | 0.00001600 | | Table lock | 0.00000700 | | init | 0.00000900 | | optimizing | 0.00004000 | | statistics | 0.00005400 | | preparing | 0.00001100 | | executing | 0.00001100 | | Sending data | 0.00001100 | | end | 0.29179100 | | query end | 0.00001500 | | freeing items | 0.00000500 | | closing tables | 0.00001500 | | logging slow query | 0.00000800 | | cleaning up | 0.00000400 | +--------------------+------------+ 15 rows in set (0.00 sec) My question now is: what do those fields mean? On the mysql website (nor on any other site I could find) no information can be found. Most of them are clear but what is 'end'? I thought it would mean sending the data to the client but that's not it as there is also a 'sending data' state. Anyone? -- -------------------------------------------------------------------- Phone: +31-6-41278122, PGP-key: 1F28D8AE, www.vanheusden.com |