Not the answer you need?
Register and ask your own question!

Difference between query_time and response_time

aserdpaserdp EntrantCurrent User Role Beginner
Version | 5.5.45-37.4-log Percona Server (GPL), Release 37.4, Revision 042e02b

Hi,

I am a bit confused on the difference between query_time as reported in the mysql slow logs and the response time as reported by the Response Time Distribution (SHOW QUERY_RESPONSE_TIME;).

The confusion stems from the observation that the mysql slow logs shows the maximum query_time as 347s (when checked with all logs).

While the distribution has entries
+
+
+
+
| | | |
+
+
+
+
| 0.000001 | 914 | 0.000000 |
| 0.000010 | 11716670 | 25.632509 |
| 0.000100 | 183210221 | 6030.333252 |
| 0.001000 | 30203398 | 8305.915448 |
| 0.010000 | 55028382 | 202486.117777 |
| 0.100000 | 51674821 | 1644526.564266 |
| 1.000000 | 7102115 | 2539651.042982 |
| 10.000000 | 278069 | 572907.555653 |
| 100.000000 | 6846 | 111699.020993 |
| 1000.000000 | 31 | 9921.227099 |
| 10000.000000 | 6 | 50372.869107 |
| 100000.000000 | 47 | 520054.762721 |

| 1000000.000000 | 0 | 0.000000 |
| TOO LONG | 0 | TOO LONG |
+

+
+
+

As seen from the highlighted (red color fonts) there are 6 +47 =53 queries that are above the range of the maximum query_time as reported in the slow logs

The above would either imply that the response_time and query_time from the two are different. If so what is the difference between them?
Or if they are the same, then why did the mysql slow log not report/log 6+47 =53 query information.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.