…MySQL…binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_dbblogpercona.commanual binlog_formatblogpercona.commanual binlog_ignore_dbblogpercona.commanual binlog…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
One of our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system… results – we get 2350 transactions/sec with sync_binlog=1 and 2550 transactions/sec with sync-binlog=0 which is about 10% overhead. EXT2… on MySQL side – may be opening binlog with O_DSYNC flag if sync_binlog=1 instead of using fsync will help ? Or may be binlog…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…_log_at_trx_commit=1, sync_binlog=1 and you do not have storage that provides fast syncs (i.e. you do not… is disabled), innodb_flush_log_at_trx_commit=1 and sync_binlog=1 or in tabular format: Threads Nofix Group Commit fix…-concurrent workload. The last test was done with a disabled sync_binlog=0 and without write-back cache: Threads Nofix Group Commit…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…’re out of sync anyway – whatever sync_binlog option was set to. Well it is still a bit better with sync_binlog enabled as slave…. I guess Jeremy speaks about enabling binary log and setting sync_binlog option which is good for safe replication. But it is… sync_binlog changes things. Two logs are synced now which requires seeks which make certain disks to flush their cache. Watch out for MySQL…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end… logs trx_commit=1 & binlog & sync_bin : innodb_flush_log_at_trx_commit = 1 and binary logs and sync_binlog=1 There are results…. So with binary logs serialization is getting even worse. Enabling sync_binlog makes things really bad, and maximal results I have is…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… with MySQL is not impossible but surely more complicated and has much higher performance overhead – you can run slave with –sync-binlog and…. Innodb during recovery also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax-bin…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…. sync_binlog Is helping by syncing binary log, but at performance penalty. If using Innodb you also might with to use innodb-safe-binlog option in MySQL… with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option was added which…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least… sync_binlog=1 to values 2 and 0 appropriately. Both can be done without server restart with Innodb Plugin, Percona Server and MySQL…, though you may lose some uncommitted transactions and binlog may get out of sync with Innodb transaction logs. I’m also wondering…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
…: sysbench –test=oltp –oltp-table-size=10000000 –db-driver=mysql –mysql-user=root –mysql-db=sbsmall –init-rng=1 –max-requests=100000000 –max… number, though it mainly was because of contention issues in MySQL 5.0 rather than any NAS issues. This number was… binary log stored on NFS volume. This number is for sync_binlog=0 and innodb_flush_log_at_trx_commit=2 I…
