sysbench Benchmark Setup
For our automated MariaDB/MySQL sysbench benchmark tests, we use sysbench fromlp:sysbench. This page describes the basic parameters and configuration we use.
You can find the automation wrapper scripts we use for running sysbench in lp:mariadb-tools
Current general parameters
table_open_cache = 512
thread_cache = 512
query_cache_size = 0
query_cache_type = 0Current InnoDB parameters
innodb_data_home_dir = /data/mysql/
innodb_data_file_path = ibdata1:128M:autoextend
innodb_log_group_home_dir = /data/mysql/
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 = 80Compile
Install MariaDB or MySQL to /usr/local and make a symlink to /usr/local/mysql. Please use non-debug version! On macOS, automake 1.10 is needed.
Start and prepare database to use
Tests
We use the latest sysbench with Lua scripting support. Therefore the test names differ from sysbench <= 0.4. To get reasonable results we use a run time of 5 minutes.
We run the tests with 1, 4, 8, 16, 32, 64, and 128 threads.
Custom added tests
We created a couple of custom tests for SysBench:
select_random_ranges.lua
select_random_points.lua
Both of these have been added to the latest SysBench v0.5 repository.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?

