Group commit and XA

Returning to post Group commit and real fsync I made several experiments:

I ran sysbench update_key benchmarks without —log-bin, with —log-bin, and with —log-bin and —innodb-support-xa=0 (default value is 1). Results (in transactions / sec)

threadswithout —log-bin—log-bin—log-bin and
—innodb_support-xa=0
11218.68614.941010.44
42686.36667.771162.60
163993.59666.141161.56
643630.55665.181151.36

So we can see group commit is not only broken when XA is enabled but also if XA is disabled but binary log is enabled. Performance without XA can be twice as good as with XA if binary logs are enabled as Innodb will need to flush its log buffer only once. So, if you are using —log-bin with innodb tables it makes sense to set —innodb-support-xa=0

Share this post

Comments (8)

  • mfc Reply

    Hi,

    What version of 4.1 did group commit first show up in?

    Thanks,

    Mike

    June 10, 2007 at 8:25 am
  • Jonatas Reply

    Hello,
    Please, what means “XA” ?
    I cannot find the meaning on the web.

    Regards
    Jonatas

    September 13, 2007 at 6:02 am
  • Vadim Reply September 13, 2007 at 8:34 am

Leave a Reply