…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: Reasons for MySQL Replication Lag
… (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
…_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: Maximal write througput in MySQL
… 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 ?
… 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
…. 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
… 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
…: 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…

