sysbench v0.5 - Three Times Five Minutes Runs on work with 5.1.42

MariDB/MySQL sysbench benchmark comparison in %

Each test was run for 5 minutes 3 times

                   Number of threads
                     1       4       8       16      32      64      128
 sysbench test
  delete             98.99   86.56   97.42  102.60  101.25   98.91   99.99
  insert             99.20   97.52   98.18   99.01   99.32   99.76   99.36
  oltp_complex_ro   100.34   99.60   98.97  100.34   99.37   99.98  100.25
  oltp_complex_rw   115.90  101.87  101.93  100.78  100.45   95.67  105.08
  oltp_simple       100.09   99.82   99.73   99.57   99.57  101.48  100.59
  select             99.72   99.83   98.85   99.92  101.29   99.34  100.11
  update_index      112.62  101.40   99.31  100.21   98.15   99.12   99.98
  update_non_index   99.36   99.28  100.20   87.68   97.09  102.04   99.91

(MariaDB q/s / MySQL q/s * 100)

Benchmark was run on work: Linux openSUSE 11.1 (x86_64), daul socket quad-core Intel 3.0GHz. with 6MB L2 cache, 8 GB RAM, data_dir on single disk.

MariaDB and MySQL were compiled with

BUILD/compile-amd64-max

MariaDB revision was:

-rtag:5.1.42

MySQL revision was:

-rtag:5.1.42

sysbench was run with these parameters:

--oltp-table-size=2000000 \
--max-time=300 \
--max-requests=0 \
--mysql-table-engine=InnoDB \
--mysql-user=root \
--mysql-engine-trx=yes

and this variable part of parameters

--num-threads=$THREADS --test=${TEST_DIR}/${SYSBENCH_TEST}

Configuration used for MariaDB and MySQL:

--no-defaults \
--skip-grant-tables \
--language=./sql/share/english \
--datadir=$DATA_DIR \
--tmpdir=$TEMP_DIR \
--socket=$MY_SOCKET \
--table_open_cache=512 \
--thread_cache=512 \
--query_cache_size=0 \
--query_cache_type=0 \
--innodb_data_home_dir=$DATA_DIR \
--innodb_data_file_path=ibdata1:128M:autoextend \
--innodb_log_group_home_dir=$DATA_DIR \
--innodb_buffer_pool_size=1024M \
--innodb_additional_mem_pool_size=32M \
--innodb_log_file_size=256M \
--innodb_log_buffer_size=16M \
--innodb_flush_log_at_trx_commit=1 \
--innodb_lock_wait_timeout=50 \
--innodb_doublewrite=0 \
--innodb_flush_method=O_DIRECT \
--innodb_thread_concurrency=0 \
--innodb_max_dirty_pages_pct=80"