user statistics not working

Bug #308849 reported by Evgeniy Stepchenko
8
Affects Status Importance Assigned to Milestone
Percona patches
Fix Released
Medium
Vadim Tkachenko

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)

Changed in percona-xtradb:
assignee: nobody → yasufumi-kinoshita
importance: Undecided → Medium
Changed in percona-patches:
status: New → Fix Committed
assignee: yasufumi-kinoshita → vadim-tk
Percona (percona-team)
Changed in percona-patches:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.