SHOW QUERY_RESPONSE_TIME is missing the column names
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
High
|
Unassigned | ||
5.1 |
Won't Fix
|
High
|
Unassigned | ||
5.5 |
Triaged
|
High
|
Unassigned | ||
5.6 |
Invalid
|
High
|
Unassigned |
Bug Description
SHOW QUERY_RESPONSE_TIME is missing the column names:
mysql> SHOW QUERY_RESPONSE_
+------
| | | |
+------
| 0.000001 | 1 | 0.000000 |
| 0.000010 | 81 | 0.000249 |
| 0.000100 | 23170 | 1.913216 |
| 0.001000 | 149005 | 31.454326 |
| 0.010000 | 16379 | 113.544756 |
| 0.100000 | 21565 | 294.616263 |
| 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.00000 | 0 | 0.000000 |
| TOO LONG | 0 | TOO LONG |
+------
14 rows in set (0.00 sec)
mysql> select * from INFORMATION_
+------
| time | count | total |
+------
| 0.000001 | 1 | 0.000000 |
| 0.000010 | 81 | 0.000249 |
| 0.000100 | 23204 | 1.915549 |
| 0.001000 | 149033 | 31.461587 |
| 0.010000 | 16380 | 113.546252 |
| 0.100000 | 21565 | 294.616263 |
| 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.00000 | 0 | 0.000000 |
| TOO LONG | 0 | TOO LONG |
+------
14 rows in set (0.00 sec)
Verified on current percona-server/5.5 from launchpad:
mysql> show query_response_ time; ------- ---+--- +------ ------- ---+ ------- ---+--- +------ ------- ---+ ------- ---+--- +------ ------- ---+
+------
| | | |
+------
| 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)
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)
mysql> show variables like '%vers%'; ------- ------- -----+- ------- ------- ------- ------- -+ ------- ------- -----+- ------- ------- ------- ------- -+ conversions | | compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- -+
+------
| Variable_name | Value |
+------
| innodb_version | 1.1.8-29.0 |
| protocol_version | 10 |
| slave_type_
| version | 5.5.28 |
| version_comment | MySQL Community Server (GPL) |
| version_
| version_compile_os | Linux |
+------
7 rows in set (0.00 sec)