Skip to content

Instantly share code, notes, and snippets.

@fipar
Created November 19, 2015 19:05
Show Gist options
  • Select an option

  • Save fipar/897f1ce6be2a28caddcc to your computer and use it in GitHub Desktop.

Select an option

Save fipar/897f1ce6be2a28caddcc to your computer and use it in GitHub Desktop.
#!/bin/bash
sysbench \
--test=/usr/share/doc/sysbench/tests/db/insert.lua \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=sysbench \
--mysql-password=sysbench \
--mysql-db=sysbench \
--mysql-table-engine=innodb \
--oltp-test-mode=complex \
--oltp-read-only=off \
--oltp-reconnect=on \
--oltp-table-size=1000000 \
--max-requests=100000000 \
--num-threads=3 \
--report-interval=1 \
--report-checkpoints=10 \
--tx-rate=24 \
$1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment