Closed
Bug 694230
Opened 14 years ago
Closed 13 years ago
sync: disable XA transactions in all non-binlog mysql via GLOBAL innodb_support_xa=0
Categories
(Cloud Services :: Operations: Deployment Requests - DEPRECATED, task)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: Atoll, Assigned: Atoll)
Details
(Whiteboard: [needs loadtest][qa?])
http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_support_xa
SET GLOBAL innodb_support_xa=0;
removes "an extra disk flush for transaction preparation" that is only relevant in any way when binlogs are enabled. we run without binlogs, and do not want more fsync().
|
||
Updated•14 years ago
|
Whiteboard: [needs loadtest] → [needs loadtest][qa-]
|
|
||
Updated•14 years ago
|
Whiteboard: [needs loadtest][qa-] → [needs loadtest][qa?]
Summary: disable XA transactions in all non-binlog mysql via GLOBAL innodb_support_xa=0 → sync: disable XA transactions in all non-binlog mysql via GLOBAL innodb_support_xa=0
This has been pushed in the production configs since 2012-03-06 and will be deployed to sync servers as they're rebuilt. SCL2 is deprecated, PHX1 will be rebuilt as RH6+, and any new site would receive the new config. Therefore, resolving this as FIXED without upgrading existing databases.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•