for anyone using phpMyAdmin, I just upgraded to 2.11 and they added a query profiling tool which is really handy for optimizing your queries.
Here’s an example output i got from a quick query on a sessions table using innodb on mysql 5
checking query cache for query 0.000038
Opening tables 0.000012
System lock 0.000018
Table lock 0.000044
Sending data 0.004121
query end 0.000008
storing result in query cache 0.000026
freeing items 0.000016
closing tables 0.000009
logging slow query 0.000004
Showing rows 0 - 29 (~3251 total, Query took 0.0060 sec)
i can’t wait to start tuning my queries with this. it shows me just what’s going on and is easy to access.
just a heads up. hope it helps!