I have modified mysql config to log slow queries
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
And interpreting them with mysqldumpslow. One of the results is as follows
Count: 28 Time=0.21s (5s) Lock=0.00s (0s) Rows=5.0 (140), root[root]@localhost
Question: what do the numbers in brackets mean?
The query does take about 0.21s when run with mysql (or via mysql GUI's); however when making a request to a page the time span is more like 5 seconds.
Extra read: mysqldumpslow: What does these fields indicate..?
