pt-mysql-summary semisynchronous informtion is wrong

Bug #1412221 reported by markus_albe
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Confirmed
Undecided
Unassigned

Bug Description

In a pt-mysql-summary output I see the following the stats section:

Rpl_semi_sync_master_net_avg_wait_time 7
Rpl_semi_sync_master_net_wait_time 1750000000 20000 800000
Rpl_semi_sync_master_net_waits 4000000 45 2250
Rpl_semi_sync_master_no_tx 80
Rpl_semi_sync_master_tx_avg_wait_time 4000
Rpl_semi_sync_master_tx_wait_time 6000000000000 70000000 350000
Rpl_semi_sync_master_tx_waits 22500000 250 600
Rpl_semi_sync_master_wait_pos_backtraverse 900000 10 5
Rpl_semi_sync_master_yes_tx 1750000 20 450

And then in the "Semisynchronous Replication" section they appear empty:

   master semisync status |
       master trace level | 32, net wait (more information about network waits)
master timeout in milliseconds | 604800000
  master waits for slaves | ON
           master clients |
 master net_avg_wait_time |
     master net_wait_time |
         master net_waits |
          master no_times |
             master no_tx |
 master timefunc_failures |
  master tx_avg_wait_time |
      master tx_wait_time |
          master tx_waits |
master wait_pos_backtraverse |
     master wait_sessions |
            master yes_tx |
                    Slave | Disabled

Not sure if they are worthy to be there at all, since we have them in the status, but that's true for other entries in other sections too; In any case: if they are to remain there, they should have proper data :-)

summary: - pt-mysql-slave semisynchronous informtion is wrong
+ pt-mysql-summary semisynchronous informtion is wrong
tags: added: pt-mysql-summary
Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Verified with PS 5.6. Agree with Marcos that if stats are available in status counter then it should be in "Semisynchronous Replication" section .

Rpl_semi_sync_master_no_times 40
Rpl_semi_sync_master_no_tx 80

# Semisynchronous Replication ################################
   master semisync status |
       master trace level | 32, net wait (more information about network waits)
master timeout in milliseconds | 10000
  master waits for slaves | ON
           master clients |
 master net_avg_wait_time |
     master net_wait_time |
         master net_waits |
          master no_times |
             master no_tx |
 ...

Changed in percona-toolkit:
status: New → Confirmed
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1261

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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