← Back to team overview

percona-discussion team mailing list archive

[Bug 308849] Re: user statistics not working

 

** Changed in: percona-patches
       Status: Fix Committed => Fix Released

-- 
user statistics not working
https://bugs.launchpad.net/bugs/308849
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: Fix Released

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)



References