2011-03-02 21:57:20 |
Swany |
bug |
|
|
added bug |
2011-05-19 01:31:59 |
Stewart Smith |
percona-server: assignee |
|
Valentine Gostev (core-longbow) |
|
2011-05-19 01:32:03 |
Stewart Smith |
percona-server: importance |
Undecided |
Medium |
|
2011-07-04 07:41:48 |
Stewart Smith |
percona-server: assignee |
Valentine Gostev (longbow) |
|
|
2011-07-04 07:41:49 |
Stewart Smith |
percona-server: status |
New |
Triaged |
|
2011-07-04 07:42:39 |
Stewart Smith |
percona-server: importance |
Medium |
Low |
|
2012-05-16 03:10:53 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.1 |
|
2012-05-16 03:10:53 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.1 |
|
2012-05-16 03:10:53 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.5 |
|
2012-05-16 03:10:53 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.5 |
|
2012-05-16 03:11:02 |
Laurynas Biveinis |
percona-server/5.1: status |
New |
Triaged |
|
2012-05-16 03:11:08 |
Laurynas Biveinis |
percona-server/5.1: importance |
Undecided |
Low |
|
2012-05-16 05:25:31 |
Alexey Kopytov |
summary |
THREAD_STATISTICS is not accessible |
THREAD_STATISTICS is always empty |
|
2012-05-16 05:27:59 |
Alexey Kopytov |
description |
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.8-55 |
+-----------+
1 row in set (0.00 sec)
mysql> use information_schema;
Database changed
mysql> show tables like 'THREAD%';
+----------------------------------------+
| Tables_in_information_schema (THREAD%) |
+----------------------------------------+
| THREAD_STATISTICS |
+----------------------------------------+
1 row in set (0.00 sec)
mysql> select * from THREAD_STATISTICS;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THREAD_STATISTICS' at line 1
mysql> desc THREAD_STATISTICS;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THREAD_STATISTICS' at line 1
mysql>
USER_STATISTICS mostly works (I'll file a separate bug on concurrent connections):
mysql> select * from USER_STATISTICS;
+-----------+-------------------+------------------------+----------------+-----------+----------+----------------+------------+----------------------+--------------+--------------+-----------------+-----------------+-----------------+----------------+---------------------+-----------------------+--------------------+------------------+---------------+---------------+
| USER | TOTAL_CONNECTIONS | CONCURRENT_CONNECTIONS | CONNECTED_TIME | BUSY_TIME | CPU_TIME | BYTES_RECEIVED | BYTES_SENT | BINLOG_BYTES_WRITTEN | ROWS_FETCHED | ROWS_UPDATED | TABLE_ROWS_READ | SELECT_COMMANDS | UPDATE_COMMANDS | OTHER_COMMANDS | COMMIT_TRANSACTIONS | ROLLBACK_TRANSACTIONS | DENIED_CONNECTIONS | LOST_CONNECTIONS | ACCESS_DENIED | EMPTY_QUERIES |
+-----------+-------------------+------------------------+----------------+-----------+----------+----------------+------------+----------------------+--------------+--------------+-----------------+-----------------+-----------------+----------------+---------------------+-----------------------+--------------------+------------------+---------------+---------------+
| cactiuser | 1002 | 0 | 23918 | 41 | 32 | 1823054 | 933888 | 0 | 698035 | 4422 | 19428245 | 7832 | 2398 | 4620 | 9306 | 0 | 0 | 0 | 0 | 2625 |
| root | 11 | 0 | 59401 | 41392 | 27356 | 2147483647 | 70616 | 0 | 252509902 | 138472204 | 2147483647 | 22 | 0 | 11083083 | 11048432 | 34603 | 0 | 8 | 0 | 2 |
+-----------+-------------------+------------------------+----------------+-----------+----------+----------------+------------+----------------------+--------------+--------------+-----------------+-----------------+-----------------+----------------+---------------------+-----------------------+--------------------+------------------+---------------+---------------+
2 rows in set (0.00 sec) |
Reproducible on both 5.1 and 5.5.
mysql> select @@userstat;
+------------+
| @@userstat |
+------------+
| 1 |
+------------+
1 row in set (0.00 sec)
mysql> show thread_statistics;
Empty set (0.00 sec)
mysql> select * from information_schema.thread_statistics;
Empty set (0.01 sec) |
|
2013-05-24 05:10:15 |
Laurynas Biveinis |
tags |
|
userstat |
|
2016-03-17 13:10:15 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.6 |
|
2016-03-17 13:10:15 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.6 |
|
2016-03-17 13:10:15 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.7 |
|
2016-03-17 13:10:15 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.7 |
|
2016-03-17 13:10:38 |
Laurynas Biveinis |
percona-server/5.7: status |
Triaged |
New |
|
2016-03-17 13:10:41 |
Laurynas Biveinis |
percona-server/5.6: importance |
Undecided |
Low |
|
2016-03-17 13:10:45 |
Laurynas Biveinis |
percona-server/5.1: status |
Triaged |
Won't Fix |
|