…that are prepared and then committed on multiple systems, with an external transaction coordinator. This is actually not precisely what this …user-initiated XA, but also for internal XA coordination between the InnoDB transaction logs and the MySQL binary logs, to ensure that they are consistent…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… Linux. O_DIRECT is an alternative but Linus hates it. What are your suggestions here? HT: According to tests by Peter Zaitsev… write and the InnoDB log flush with a mutex in 5.1, to implement XA, and switching off the XA will not remove… can disable binary logging to get Group Commit back. Though this is often not the option. Here are some benchmarks we did…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
…. And the server performs an XA transaction between InnoDB and the binary log. This adds more fsync calls, … can be an order of magnitude or more. What‘s the solution? I’m not sure I …I can think of are too simplistic. For example, doing replication through the InnoDB transaction log would work fine …
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… the table content and binary log content in case of a crash. For example, if you are using InnoDB tables and the… obsolete by the introduction of XA transaction support.)” I’m not sure what to make of that. XA support is traditionally for 2… that the binary log ITSELF is XA-compliant:) I guess what I’m really asking is, if you have enabled binary logging (replication), sync…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… affected by –log-bin settings, which usually has just couple of percent overhead. So what is going… trigered by enabled binary log. if binary log is disabled, so is XA and old group commit …good thing RAID with battery backed up cache are becoming really inexpensive. You also probably want …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…xa=0 innodb_flush_method = O_DIRECT First the options are somethat benchmark optimized – for example doublewrite is disabled; checksums are disabled; binary log is disabled – this is not what …
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… and log writes, which is critical and latency sensitive. What many people do not realize is MySQL has to deal with multiple logs… is event written to the binary log to “prepare” XA transaction, when there is record in Innodb log to commit it and finally… in-cache write speed (and this is what a lot of transaction and binary logs are) – in this case you have about 100…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
…MySQL 5.0. Guess what? They’re both right. ” But is it really what results are telling us ? I…be not. In particular: innodb_support_xa=0, innodb_doublewrite=0 are not normally used in production …relevant for production I also would keep binary log enabled – most big installations of MySQL use …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… extra trip) involved. This in particular hurts log writes which are very latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable transactions the log… more than one fsync() for the log because it internally implements XA to synchronize with binary log and also if you’re looking…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… what I find good or bad would base of my MySQL use with existing applications – if you design new applications which are… transaction spawns multiple databases you need multiple log flushes on commit, plus ether you use XA to synchronize these which is expensive… found much information about is regarding handling fragmentation – what happens on row updates, are they stored in the same position or in…
