![]() |
||
---|---|---|
.. | ||
README.md | ||
scan_check_common.lua | ||
scan_check_mixed.lua |
README.md
- start mysqld
- create db test
- run sysbench
sysbench scan_check_mixed.lua --mysql-host=${mysql_ip} --mysql-port=${mysql_port} --mysql-db=test --mysql-user=${user} --threads=40 --insert_thread_num=10 --update_thread_num=10 --events=1000000000 --time=1000000000 --sst_file_limit=2000 --padding_size=128 --report-interval=10 prepare
sysbench scan_check_mixed.lua --mysql-host=${mysql_ip} --mysql-port=${mysql_port} --mysql-db=test --mysql-user=${user} --threads=40 --insert_thread_num=10 --update_thread_num=10 --events=1000000000 --time=1000000000 --sst_file_limit=2000 --padding_size=128 --report-interval=10 run
scan_thread_num is thread_num - insert_thread_num - update_thread_num. For blob, set padding_size to a larger value, e.g. 600000.