… performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the … Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to … 5.1, then InnoDB‘s group commit works again. PZ: You can disable binary logging to get Group Commit back…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… the binary log to “prepare” XA transaction, when there is record in Innodb log to commit it and finally there is record in Binary log to… operations – MySQL binary logs are not preallocated as Innodb logs are which means both Data AND metadata have critical changes on each binary log write and… overhead besides network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be well below 10…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… all, also you can review binary logs to see which updates were applied to different nodes. Transaction log replay, yes. But fsck? These…. First – hot vs cold. If you’re using decent hardware and care about performance you use O_DIRECT with Innodb which makes… nice mixed environments with MySQL – for example you can replicate binary logs using DRBD so if master node fails you have not…
Comment: MySQL Backup tools used by Percona Remote DBA for MySQL
March 17, 2013 By 8 Comments
…. Some factors that affect speed of restore include innodb_log_file_size, innodb_buffer_pool_size, innodb insert buffer (default to 50% of buffer… of course available disk IO. There are also several other innodb setting that affect the number of background threads doing IO… taken to doing a binary restore so you know when it’s appropriate to begin one type vs the other. Remember the…
Post: READ-COMMITED vs REPETABLE-READ in tpcc-like load
February 11, 2010 By 6 Comments
… poping up again and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level ? and in Repeatable read versus read committed for InnoDB . Serge in his post explains why READ COMMITED is better… 16 and 32 (for 10w) concurrent users. Also I had binary log enabled on RBR mode (as READ-COMMITED does not support…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until…possible. Compressed mydumper typically 3x-5x smaller vs compressed xtrabackup Typically we upload mydumper… mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…subset of changes to the binary log. You could use this to reduce binary log growth, if you have some…on successive queries. Q: Is RBR faster replicating vs SBR replication? RBR is faster than statement based,…with using a write-through cache? A: The InnoDB buffer pool is effectively a type of write…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…the fix improves performance substantially when both innodb_flush_log_at_trx_commit=1 and sync_binlog=…is also result to compare binary logs enabled and disabled. All results are for binaries with group commit fix….38 There is still performance difference binlogs vs no-binlogs, but it is much smaller …
Post: Pretending to fix broken group commit
February 2, 2009 By 11 Comments
… testing from Launchpad) we introduce –innodb-unsafe-group-commit mode. There are results with this options vs without (results are in transactions… in binary-logs will be in different order than in InnoDB transactional log. Why this is bad? For example if box crashes and InnoDB does…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…you look at In Memory storage engines vs Distributed ones. Trying to handle all … To start we have to write second binary log file when all transaction engines have their own…and using Innodb internal data dictionary instead of Innodb files. We would use Innodb transactional log for replication …
