Comment 0 for bug 728080

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)