…:259 ‘Aborted_clients’, ’267108′ ‘Aborted_connects’, ’25997′ ‘Binlog_cache_disk_use’, ’145′ ‘Binlog_cache_use’, ’9638599′ ‘Bytes_received’, ’2671219831′ ‘Bytes_…innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… guess Jeremy speaks about enabling binary log and setting sync_binlog option which is good for safe replication. But it is… Binary log with MySQL 5.0 you loose group commit which can dramatically increase commit rate for multiple user load. See this post… to single stream so group commit can’t work. Furthermore even if you run with innodb_flush_logs_at_trx_commit=2 you still…
Comment: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
Agree with your points here. My group commit work will provide a partial solution to this (it is … fsync() per group commit is needed (on the binary log). This will make the binlog only slightly more expensive than using InnoDB durably without… to one fsync() per group commit, we are in pretty good shape already, able to do 1000-10000 commits per second on typical…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… results. Fix broken group commit in InnoDB As you know, the group commit of InnoDB doesn’t work after MySQL 5.0 with binlog. We pretend to fix this and added “innodb_enable_unsafe_group_commit=[0…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…binlog-ignore-db=edmunds #binlog-ignore-db=evox #binlog-ignore-db=jato #binlog-ignore-db=kbb binlog-ignore-db=mysql binlog-ignore-db=test #binlog…innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb…
Comment: Benchmarking Galera replication overhead
October 14, 2011 By 12 Comments
… did you use for sync_binlog, innodb_support_xa? 3) What values of innodb_flush_log_at_trx_commit did you use? 4) You… “group commit” for writing to write sets to disk? 5) I’m actually surprised that Galera is slower than regular replication. When binlog & sync_bonlog are enabled, group commit is broken and performance can drop by over 90%. Since Galera doesn’t need binlog I…
Comment: How many fsync / sec FusionIO can handle
March 4, 2010 By 13 Comments
Group commit is fixed when the binlog is off. Otherwise, prepare_commit_mutex is locked in innobase_xa_prepare and unlocked in innobase_commit. The binlog… MySQL or InnoDB docs and the plugin release notes that state that group commit is fixed might confuse people. Not having group commit can be…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… proper comparison is single node with both innodb_flush_log_at_trx_commit=1 and sync_binlog=1, and two Galera nodes with… difference if you use an InnoDB version with group commit bug fixed or not. If you have the group commit bug, then it is easy to get much better performance just because the binlog goes away. See…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…commit 1 innodb_flush_method O_DIRECT innodb_force_recovery 0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb…
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… makes it very expensive to do sync_binlog=1 unless you have battery backed up …however can do group commit, meaning it can commit several transactions which are waiting to be commited at the …) – once transaction is commited the data is recorded in Innodb log files before COMMIT returns. The data …
