PHPMyAdmin's 'Query took' time differs from MySQL Profiling information
Using the new MySQL Query Profiler in PHPMyAdmin version 2.11.5, I got following results (PNG-version)
Status Time
(initialization) 0.00004
Opening tables 0.000059
System lock 0.000003
Table lock 0.000006
init 0.000013
optimizing 0.000004
statistics 0.000015
preparing 0.000012
executing 0.000028
Sending data 0.000129
end 0.000003
query end 0.000002
freeing items 0.000003
closing tables 0.000001
removing tmp table 0.000007
closing tables 0.000002
logging slow query 0.000001
Showing rows 0 - 29 (29,128 total, Quer开发者_运维问答y took 1.6200 sec)
When I add those times, I get 0.000328. I'm wondering why PHPMyAdmin reports 1.6200 secs?
Query Profiler doesn't take into account the actual time it takes for the data to move between the database and the back end. There might be other factors involved, but basically PHPMyAdmin records the whole chain (and perhaps not that accurately) whereas Query Profiler only measures the actions taken inside the database.
精彩评论