user statistics not working

Bug #308849 reported by Evgeniy Stepchenko on 2008-12-17
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) on 2008-12-23
Changed in percona-patches:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers