Skip to content

Instantly share code, notes, and snippets.

@mikoim
Created September 7, 2017 11:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikoim/8346d04abd9b141f6ea11fc13819df45 to your computer and use it in GitHub Desktop.
Save mikoim/8346d04abd9b141f6ea11fc13819df45 to your computer and use it in GitHub Desktop.
sysbench oltp_read_write --mysql-dry-run=off --mysql-socket=/run/mysqld/mysqld.sock --mysql-user=root --mysql-password=foo --table_size=1000000 --tables=20 --mysql-db=foo --time=60
[mysqld]
innodb_buffer_pool_size = 700M
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 1 # may change to 2 or 0
innodb_flush_method = O_DIRECT
sysbench 1.0.8 (using bundled LuaJIT 2.1.0-beta2)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 113414
write: 32404
other: 16202
total: 162020
transactions: 8101 (134.94 per sec.)
queries: 162020 (2698.82 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 60.0212s
total number of events: 8101
Latency (ms):
min: 2.67
avg: 7.40
max: 74.40
95th percentile: 13.46
sum: 59949.49
Threads fairness:
events (avg/stddev): 8101.0000/0.00
execution time (avg/stddev): 59.9495/0.00
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 112700
write: 32200
other: 16100
total: 161000
transactions: 8050 (134.09 per sec.)
queries: 161000 (2681.73 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 60.0316s
total number of events: 8050
Latency (ms):
min: 2.92
avg: 7.45
max: 62.64
95th percentile: 12.75
sum: 59956.47
Threads fairness:
events (avg/stddev): 8050.0000/0.00
execution time (avg/stddev): 59.9565/0.00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment