Three Times Five Minutes Runs on work with 5.1.42
From Askmonty.org
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 ran on work: two-way quad-core core 4GB RAM?
MariaDB and MySQL was compiled with
BUILD/compile-amd64-max
MariaDB revision is:
-rtag:5.1.42
MySQL revision is:
-rtag:5.1.42
sysbench was run with this 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"
