Bug #49705 Some undocumented semi-synch replication status and variables
Submitted: 15 Dec 2009 8:54 Modified: 16 Dec 2009 3:56
Reporter: Giuseppe Maxia Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: Docs, replication, semisynch, STATUS, variables

[15 Dec 2009 8:54] Giuseppe Maxia
Description:
In this manual page, 
http://dev.mysql.com/doc/refman/5.5/en/replication-semisync-interface.html
The following items are not documented:

STATUS:
Rpl_semi_sync_master_net_avg_wait_time     
Rpl_semi_sync_master_net_wait_time         
Rpl_semi_sync_master_net_waits             
Rpl_semi_sync_master_no_times              
Rpl_semi_sync_master_timefunc_failures     
Rpl_semi_sync_master_tx_avg_wait_time      
Rpl_semi_sync_master_tx_wait_time          
Rpl_semi_sync_master_tx_waits              
Rpl_semi_sync_master_wait_pos_backtraverse 
Rpl_semi_sync_master_wait_sessions         
Rpl_semi_sync_master_yes_tx                

VARIABLES:
rpl_semi_sync_master_trace_level  
rpl_semi_sync_master_wait_no_slave 
(explained in http://dev.mysql.com/doc/refman/5.5/en/dynamic-system-variables.html but not mentioned in the semi-synch administrative page)

How to repeat:
see the above page. Then run:
SHOW STATUS LIKE 'Rpl_semi_sync%';
[15 Dec 2009 10:07] Sveta Smirnova
Thank you for the report.

Verified as described.
[15 Dec 2009 11:09] Jon Stephens
Paul's handling semi-sync, so assigned to him.
[16 Dec 2009 3:56] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

This page is intended only to give examples of the more important variables. I'll indicate that the list is not complete and add cross references to the sections that list them all:

http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html
http://dev.mysql.com/doc/refman/5.5/en/server-status-variables.html