Skip to content

Instantly share code, notes, and snippets.

@optix2000
Created August 7, 2016 05:39
Show Gist options
  • Save optix2000/73bf4ebaf845d57605abd1fad5ca8e4e to your computer and use it in GitHub Desktop.
Save optix2000/73bf4ebaf845d57605abd1fad5ca8e4e to your computer and use it in GitHub Desktop.
mariadb 10.0 vs postgres 9.4
root@hammer-512mb-sfo1-01:~/sysbench-0.4.12/sysbench# ./sysbench --test=oltp --db-driver=pgsql run
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (262.44 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (4986.41 per sec.)
other operations: 20000 (524.89 per sec.)
Test execution summary:
total time: 38.1035s
total number of events: 10000
total time taken by event execution: 38.0397
per-request statistics:
min: 3.07ms
avg: 3.80ms
max: 76.41ms
approx. 95 percentile: 5.36ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 38.0397/0.00
root@hammer-512mb-sfo1-01:~/sysbench-0.4.12/sysbench# ./sysbench --test=oltp --db-driver=mysql --mysql-user=roo trun
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (163.37 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (3103.95 per sec.)
other operations: 20000 (326.73 per sec.)
Test execution summary:
total time: 61.2124s
total number of events: 10000
total time taken by event execution: 61.1316
per-request statistics:
min: 2.90ms
avg: 6.11ms
max: 30.58ms
approx. 95 percentile: 11.98ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 61.1316/0.00
root@hammer-512mb-sfo1-01:~/sysbench-0.4.12/sysbench#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment