Fast, Reliable, Proven transactional storage for MySQL

InnoDB Plugin 1.0.4 Group Commit Test (Sysbench)

This test employs the well-known Sysbench benchmarking tool that uses a simple read-write transactional workload. Sysbench can be downloaded from Sourceforge.

Historically, InnoDB has used the group commit functionality to group multiple flush requests together to avoid one flush for each commit. This functionality became broken due to changes in MySQL 5.0, with the introduction of support for the distributed transactions using the 2-phase commit protocol that is required when using the MySQL binlog. This release re-enables group commit functionality.

On this test, the InnoDB Plugin 1.0.4 shows significantly better scalability from 16 to 64 users than the built-in InnoDB in MySQL, yielding as much as 60% more throughput at 64 users. The performance comes close to what is achieved when running with the binlog turned off.

Group Commit image010

Configuration
Dual quad-core Intel Xeon, 3.00GHz, 32 GB memory, RAID 5
Relevant my.cnf parameters:
query-cache-type = 0
query-cache-size = 0
table-open-cache = 2048
innodb-data-file-path = ibdata1:2000M:autoextend
innodb-additional-mem-pool-size = 20M
innodb-log-file-size = 100m
innodb_adaptive_hash_index = ON
innodb_buffer_pool_size = 2048M
innodb_checksums = ON
innodb_doublewrite = ON
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_lock_wait_timeout = 50
innodb_max_dirty_pages_pct = 90
innodb_table_locks = ON
innodb_thread_concurrency = 0
innodb_use_sys_malloc = OFF