polardbxengine/storage/xengine/tools/scan_check
dengwendi 1d6524707e INIT 2023-11-15 15:04:10 +08:00
..
README.md INIT 2023-11-15 15:04:10 +08:00
scan_check_common.lua INIT 2023-11-15 15:04:10 +08:00
scan_check_mixed.lua INIT 2023-11-15 15:04:10 +08:00

README.md

  1. start mysqld
  2. create db test
  3. 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.