A common misunderstanding about innodb_support_xa is that it enables user-initiated XA transactions, that is, transactions that are prepared and then committed… use XA transactions, you can disable this variable to reduce the number of disk flushes and get better InnoDB performance. Having innodb_support_xa enabled…
Post: Group commit and XA
May 19, 2006 By 8 Comments
… and —innodb-support-xa=0 (default value is 1). Results (in transactions / sec) threads without —log-bin —log-bin —log-bin and —innodb_support-xa=0… enabled. Performance without XA can be twice as good as with XA if binary logs are enabled as Innodb will need to flush… only once. So, if you are using —log-bin with innodb tables it makes sense to set —innodb-support-xa=0
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…
Comment: Group commit and real fsync
May 19, 2006 By 9 Comments
… –log-bin, with –log-bin, and with –log-bin and –innodb-support-xa = 0 (default value is 1). Results (in transactions / sec) threads…-bin  3 – with –log-bin and –innodb_support-xa=0 ) As you see with –innodb_support-xa=0 the result is almost by 2 times… is used). So, if you are using –log-bin with innodb tables it makes sense to set –innodb_support-xa=0 [...]
Comment: Tuning for heavy writing workloads
October 15, 2009 By 9 Comments
… (or fix it). Whether innodb_support_xa is needed or not is depend on the each user. If innodb_support_xa=1 and using binlog, 2… transaction is committed in the binlog. So innodb_support_xa=1 seems to be safer than innodb_support_xa=0, but it is not perfect. There are possibility still that the transaction which is committed in InnoDB but…
Comment: Tuning for heavy writing workloads
October 15, 2009 By 9 Comments
Yasufumi, Is it safe to not use binlog in production? I thought binlog is needed for recovery purpose. If binlog is needed, then innodb_support_xa is also needed, right? How much of a performance penalty does enabling binlog & innodb_support_xa incur then?
Comment: Looking at Redis
September 4, 2009 By 27 Comments
… it the binlog? innodb_support_xa? What if I have a MySQL server without replication, but still have binlog & innodb_support_xa enabled for data recovery…
Comment: MySQL Crash Recovery
August 2, 2006 By 26 Comments
In “Binary log corruption”, you say “In MySQL 5.0 XA is taking care of this synchronization”. If you know any document or URL about synchronization between binary log and InnoDB log w/ innodb_support_xa, would you like to tell me? Does MySQL AB Document refer to this synchronization?
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… to innodb_current_row_locks. (Yasufumi Kinoshita) Old system variable innodb_enable_unsafe_group_commit was deleted. The existing MySQL variable innodb_support_xa can… – binary distributions and Percona Software Repositories Installation instructions Consulting, support, training, and custom development Release notes Documentation Developer discussion group…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… ON innodb_stats_sample_pages 8 innodb_strict_mode OFF innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_use…
