> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/product-development/server-development/quality/benchmarks-and-long-running-tests/benchmark-results/sysbench-v0.5-3x-15-minute-runs-on-perro-with-5.2-wl86-b.md). # sysbench v0.5 - 3x 15 Minute Runs on perro with 5.2-wl86 b 3x 15 Minute Runs on perro with 5.2-wl86 key cache partitions off, 8, and 32 and key buffer size 75 MariDB sysbench benchmark comparison for key\_cache\_partitions in % with key\_buffer\_size = 75MB Each test was run 3 times for 15 minutes with 3 minutes warmup. ``` Number of threads 1 4 8 16 32 64 128 sysbench test oltp_complex_ro 8 / off 3.05 -0.10 0.57 1.00 -0.05 0.15 2.50 32 / off 3.04 -26.61* 0.89 -0.02 1.03 0.44 2.94 oltp_simple 8 / off -0.95 -1.10 -1.17 1.36 -2.65 -0.59 -1.01 32 / off 0.76 -0.02 0.66 2.75 1.96 3.05 -0.86 select 8 / off -1.45 -0.68 -2.31 -27.61* -0.52 -3.97 -0.24 32 / off -0.87 -1.63 -1.15 -2.10 0.44 1.12 1.39 update_index 8 / off -2.55 8.29* 3.14 4.16 1.13 1.95 1.29 32 / off -2.27 9.46* -0.12 2.64 0.69 -7.26* -0.24 ( 8/off*100)-100 (32/off*100)-100 * means unusually high STDEV off means key_cache_partitions off 8 means key_cache_partitions = 8 32 means key_cache_partitions = 32 ``` Benchmark was run on perro: Linux openSUSE 11.1 (x86\_64), single socket dual-core Intel 3.2GHz. with 1MB L2 cache, 2GB RAM, data\_dir on 2 disk software RAID 0 MariaDB and MySQL were compiled with ``` BUILD/compile-amd64-max ``` MariaDB revision was: ``` revno: 2742 committer: Igor Babaev branch nick: maria-5.2-keycache timestamp: Tue 2010-02-16 08:41:11 -0800 message: WL#86: Partitioned key cache for MyISAM. This is the base patch for the task. ``` sysbench was run with the following parameters: ``` --oltp-table-size=20000000 \ # 20 million rows. --max-requests=0 \ --mysql-table-engine=MyISAM \ --mysql-user=root \ --mysql-engine-trx=no \ --myisam-max-rows=50000000 \ --rand-seed=303 ``` and the following variable parameters ``` --num-threads=$THREADS --test=${TEST_DIR}/${SYSBENCH_TEST} ``` Configuration used for MariDB: ``` --no-defaults \ --datadir=/mnt/data/sysbench/data \ --language=./sql/share/english \ --key_buffer_size=75M \ --key_cache_partitions=32 \ # Off | 8 | 32 --max_connections=256 \ --query_cache_size=0 \ --query_cache_type=0 \ --skip-grant-tables \ --socket=/tmp/mysql.sock \ --table_open_cache=512 \ --thread_cache=512 \ --tmpdir=/mnt/data/sysbench ``` *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formId="4316" %}