…=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… in my previous benchmark run. A small handful of additional tests were also performed using the Cisco UCS C250. The operating… take a look at the data. With the sysbench fileIO test in asynchronous mode, read performance is an extremely steady 3202MiB… graph we look at the card’s performance on sysbench OLTP: It is worth noting here that EXT4 outperforms XFS by…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under… with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init=on –report-interval…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s… run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… has announced the Linkbench benchmark that models the social graph OLTP workload. Sources, along with a very nice description of how… these servers will handle such OLTP workloads in the CPU and IO-bound cases. For this test we used a PowerEdge R720…=100000001 -c config/MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64 -D dbid…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
….. – did you monitor by chance the memory usage during your tests?.. – I’m asking about because in the past I’ve… also probably explain why there is near no difference on OLTP @EXT4 results when BP size is between 13GB and 50GB… db size is big (as it was not mentioned) and OLTP_RW scenario is “standard”?).. Rgds, -Dimitri
Comment: Testing the Micron P320h
April 17, 2013 By 7 Comments
….com/2013/03/21/testing-the-virident-flashmax-ii/ @Dimitri– The data size for these tests was roughly 250GiB, standard oltp_rw scenario.
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size…]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_big –oltp-table-size…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… Sysbench, for example: sysbench –test=oltp –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads…:/etc/mysql# sysbench –test=oltp –oltp-auto-inc=off –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql-password=”" –oltp-table-size=1000000…
Post: Sysbench with support of multi-tables workload
April 29, 2011 By 4 Comments
… –test=tests/db/oltp.lua –oltp-tables-count=25 –num-threads=5 run oltp.lua should understand most options that available for regular sysbench –test=oltp there are couple other scripts, likeoltp_simple select insert delete update_index update_non_index to support different OLTP modes…
