Cannot Find oltp test on sysbench

user_5503947 0
Viewed 12995

I'm trying to run benchmark on mySQL database using sysbench. However, it says it cannot find built-in test oltp.

Detail: I've installed mySQL, and sysbench on my local machine. Also, I've created database dbtest inside the mySQL. And then I executed following instruction. 

sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=root --mysql-password=<password> prepare

But then this error message occured.

WARNING: the --test option is deprecated. You can pass a script 
name or path on the command line without any options.
sysbench 1.0.8 (using bundled LuaJIT 2.1.0-beta2)

FATAL: Cannot find benchmark 'oltp': no such built-in test, file or module

sysbench worked fine with other test such as

sysbench --test=cpu --cpu-max-prime=20000 run

I think the problem is that sysbench can't find pre-defined test called oltp but I don't know how to figure it out.

Thank you for reading.

sysbench oltp benchmarking mysql database
2 Answers

The dpkg tool is handy to show where files for an installed package are stored on the system. I used it when locating the test scripts for sysbench 1.0.14. See the man page for more options

# dpkg --listfiles sysbench
...
/usr/share/sysbench/bulk_insert.lua
/usr/share/sysbench/select_random_ranges.lua
/usr/share/sysbench/oltp_update_non_index.lua
/usr/share/sysbench/oltp_delete.lua
/usr/share/sysbench/oltp_update_index.lua
/usr/share/sysbench/oltp_read_write.lua
/usr/share/sysbench/oltp_point_select.lua
...
user_59014770
Related