percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00002
[Bug 309004] [NEW] user statistics not working
*** This bug is a duplicate of bug 308849 ***
https://bugs.launchpad.net/bugs/308849
Public bug reported:
By default build10 disables everything ?
At the same time there is user statistics but it is somehow
strange. Looks like only connections are counted.
mysql> show user_statistics \G
*************************** 1. row ***************************
User: wordpress
Total_connections: 4
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 2. row ***************************
User: mailboxer
Total_connections: 3
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 3. row ***************************
User: nagios
Total_connections: 1
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 4. row ***************************
User: root
Total_connections: 2
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 5. row ***************************
User: replicant
Total_connections: 1
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
5 rows in set (0.00 sec)
** Affects: percona-patches
Importance: Undecided
Status: New
** This bug has been marked a duplicate of bug 308849
user statistics not working
--
user statistics not working
https://bugs.launchpad.net/bugs/309004
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.
Status in Patches for MySQL by Percona: New
Bug description:
By default build10 disables everything ?
At the same time there is user statistics but it is somehow
strange. Looks like only connections are counted.
mysql> show user_statistics \G
*************************** 1. row ***************************
User: wordpress
Total_connections: 4
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 2. row ***************************
User: mailboxer
Total_connections: 3
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 3. row ***************************
User: nagios
Total_connections: 1
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 4. row ***************************
User: root
Total_connections: 2
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
*************************** 5. row ***************************
User: replicant
Total_connections: 1
Concurrent_connections: 0
Connected_time: 0
Busy_time: 0
Cpu_time: 0
Bytes_received: 0
Bytes_sent: 0
Binlog_bytes_written: 0
Rows_fetched: 0
Rows_updated: 0
Table_rows_read: 0
Select_commands: 0
Update_commands: 0
Other_commands: 0
Commit_transactions: 0
Rollback_transactions: 0
Denied_connections: 0
Lost_connections: 0
Access_denied: 0
Empty_queries: 0
5 rows in set (0.00 sec)
Follow ups
References
