Bluehost.com Web Hosting $6.95

understanding output of SHOW PROFILE

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, ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-18-2007
Folkert van Heusden
 
Posts: n/a
Default understanding output of SHOW PROFILE

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



Reply With Quote
  #2 (permalink)  
Old 04-29-2007
Patrick
 
Posts: n/a
Default Re: understanding output of SHOW PROFILE

I've been looking for the exact same thing. It seems like there is no
documentation out there for it. I specifically need to know what
having an extremely high "init" value means.

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 10:00 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0