PHPMyAdmin Query Runtime Different from MySQL Profiling Data

Using the new MySQL Query Profiler in PHPMyAdmin version 2.11.5, I got the 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, Query took 1.6200 sec)

When I add those times, I get 0.000328. I am wondering why PHPMyAdmin reports 1.6200 secs ?

+3
source share
1 answer

Query Profiler , . , PHPMyAdmin (, , ), Query Profiler , .

+4

Source: https://habr.com/ru/post/1747947/


All Articles