# INFORMATION\_SCHEMA.QUERY\_RESPONSE\_TIME is empty

**URL:** <https://forums.percona.com/t/information-schema-query-response-time-is-empty/1879>\
**Category:** Other MySQL® Questions\
**Created:** [August 30, 2012, 2:55am UTC](https://forums.percona.com/t/information-schema-query-response-time-is-empty/1879 "2012-08-30T02:55:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chan](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@chan](https://forums.percona.com/u/chan)\
**Post date:** [August 30, 2012, 2:55am UTC](https://forums.percona.com/t/information-schema-query-response-time-is-empty/1879/1 "2012-08-30T02:55:43Z")

</div>

Hi there!  
I have problem  
mysql\> SELECT \* from INFORMATION\_SCHEMA.QUERY\_RESPONSE\_TIME ;  
±---------------±------±---------------+  
| time | count | total |  
±---------------±------±---------------+  
| 0.000001 | 0 | 0.000000 |  
| 0.000010 | 0 | 0.000000 |  
| 0.000100 | 0 | 0.000000 |  
| 0.001000 | 0 | 0.000000 |  
| 0.010000 | 0 | 0.000000 |  
| 0.100000 | 0 | 0.000000 |  
| 1.000000 | 0 | 0.000000 |  
| 10.000000 | 0 | 0.000000 |  
| 100.000000 | 0 | 0.000000 |  
| 1000.000000 | 0 | 0.000000 |  
| 10000.000000 | 0 | 0.000000 |  
| 100000.000000 | 0 | 0.000000 |  
| 1000000.000000 | 0 | 0.000000 |  
| TOO LONG | 0 | TOO LONG |  
±---------------±------±---------------+  
14 rows in set (0.00 sec)

but slow queries exists.  
Could you explane What I do wrong? )))

Variable\_name: version  
Value: 5.5.27-28.0-log  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 366. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Variable\_name: version\_comment  
Value: Percona Server (GPL), Release 28.0  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 367. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Variable\_name: version\_compile\_machine  
Value: x86\_64  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 368. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Variable\_name: version\_compile\_os  
Value: Linux

| Qcache\_free\_blocks | 6072 |  
| Qcache\_free\_memory | 244855696 |  
| Qcache\_hits | 19989810 |  
| Qcache\_inserts | 10049 |  
| Qcache\_lowmem\_prunes | 0 |  
| Qcache\_not\_cached | 224 |  
| Qcache\_queries\_in\_cache | 10049 |  
| Qcache\_total\_blocks | 26178 |  
| Queries | 20000438 |  
| Questions | 20000438 |

---

<div class="post-metadata">

**Author:** ![miketaylor61](https://avatars.discourse-cdn.com/v4/letter/m/c89c15/32.png) [@miketaylor61](https://forums.percona.com/u/miketaylor61)\
**Post date:** [August 30, 2012, 2:58am UTC](https://forums.percona.com/t/information-schema-query-response-time-is-empty/1879/2 "2012-08-30T02:58:09Z")

</div>

you have to set the variable

query\_response\_time\_stats

i.e.

mysql\> set global query\_response\_time\_stats=ON;

Then it will start filling up the table with stats (In our case 321000 queries in 2 mins!!).

---

<div class="post-metadata">

**Author:** ![chan](https://avatars.discourse-cdn.com/v4/letter/c/4491bb/32.png) [@chan](https://forums.percona.com/u/chan)\
**Post date:** [August 30, 2012, 3:06am UTC](https://forums.percona.com/t/information-schema-query-response-time-is-empty/1879/3 "2012-08-30T03:06:47Z")

</div>

Oh! It’s so simple. I read all cross hawto’s and did not find it.  
Many thanks.

> (In our case 321000 queries in 2 mins!!)  
> It’s just tests. But this tests show me without query cache perfomance is higher in 5 times

Narrow place is here:  
SHOW PROCESSLIST;  
| 244 | testtable | localhost | glavsport | Query | 0 | Waiting for query cache lock | SELECT `t0`.`id` `t0.id`,`t0`.`name` `t0.name`,`t0`.`icon` `t0.icon`,`t0`.`text` `t0.text`,IFNULL(c | 0 | 0 | 1 |  
101 rows in set (0.00 sec)

Thanks a lot!