Mysql-sysbench Installation Test

An address
Githup Address
Https://github.com/akopytov/sysbench
Two versions Sysbench 1.0+
Three Concepts

Sysbench testname

TestName is an optional name for a built-in test (such as FILEIO,OLTP, etc.), or the name of a bound Lua script (such as oltp_read_only), or a path to a custom Lua script. If the test name is not specified on the command line (so there is no command, as in this case it will be resolved to a testname), or the test name is a dash ("-"), then Sysbench wants the Lua script to execute on its standard input.

42 Types of test methods
1 Loading LUA scripts
1 Customizing LUA Scripts
2 Bring your own LUA script
2 Using module testing

Five Test examples

1 sysbench./src/lua/oltp_read_write.lua--table_size=10000--tables=10--rand-spec-res=75--threads=128--time=3600- -warmup-time=100--report-interval=3--point_selects=4--non_index_updates=1--delete_inserts=1--index_updates=1-- Simple_ranges=0--order_ranges=0--range_selects=off Run

Six related combinations description

--oltp-point-selects=n number of point selects [10]
--oltp-simple-ranges=n number of simple ranges [1]
--oltp-sum-ranges=n number of sum ranges [1]
--oltp-order-ranges=n number of ordered ranges [1]
--oltp-distinct-ranges=n number of distinct ranges [1]
--oltp-index-updates=n number of index Update [1]
--oltp-non-index-updates=n number of Non-index updates [1]

Mysql-sysbench Installation Test