Bug #35786 Incorrect alert for innodb_support_xa =1 when replication/binlog enabled
Submitted: 3 Apr 2008 7:47 Modified: 1 Aug 2008 15:23
Reporter: Andrii Nikitin Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Andy Bang CPU Architecture:Any

[3 Apr 2008 7:47] Andrii Nikitin
Manual clearly states (http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#option_mysqld_innodb_support...):

If you are using replication and/or the binary log then you should set this variable to ON or 1 to ensure that the binary log does not get out of sync compared to the table data. 

But we get such alert on Master server:

Advisor: Administration - XA Distributed Transaction Support Enabled For InnoDB

Problem Description
XA Distributed Transaction support is turned on by default. If you are not using this feature, note that it adds an extra fsync for each transaction and may adversely affect performance.

Turn off XA distributed transaction support if you do not need it: Add innodb_support_xa=0 to your my.cnf/my.ini file and restart the server.

Recommended Action
SET GLOBAL innodb_support_xa = 0;

So customers not sure when they should consider that alert valuable.
Maybe that is DOC bug, but now it clearly states to set innodb_support_xa = 1 when using Replication.

How to repeat:
Advisers on Master server. 

Suggested fix:
Do not alarm that warning in case when binlog enabled. (or clearly state possible out-of-sync results in Advise/Recommended Action sections).
[3 Apr 2008 7:59] Valeriy Kravchuk
Thank you for a problem report.
[21 May 2008 21:38] Andy Bang
Added "&& (%log_bin% = "OFF")" to the expression.

Committed revision 9125.
[5 Jun 2008 17:12] Marcos Palacios
Rule "XA Distributed Transaction Support Enabled For InnoDB" now does not send the warning when the binary log is on.

Verified fixed in advisor build
[23 Jul 2008 8:50] Tony Bedford
Set to "verified" with a "target" of 2.0 as requested.

Also added an entry to the 1.3 changelog:

The rule “XA Distributed Transaction Support Enabled For InnoDB” incorrectly sent a warning when the binary log was on.
[29 Jul 2008 22:03] Andy Bang
This was fixed in the 2.0 codeline at the same time it was fixed in 1.3, so please re-test with the latest 2.0 stuff.
[31 Jul 2008 22:32] Marcos Palacios
Verified fixed in advisor build
[1 Aug 2008 15:23] Tony Bedford
Updated 2.0 changelog.