|
chris@home~$ uname -a |
|
Linux home 4.2.0-38-generic #45-Ubuntu SMP Wed Jun 8 21:21:49 UTC 2016 x86_64 |
|
x86_64 x86_64 GNU/Linux |
|
|
|
======================================================================== |
|
======================================================================== |
|
======================================================================== |
|
|
|
with transactions - unfair b/c upscaledb doesn't implement them |
|
|
|
innodb ---------------------------------------------------- |
|
Database "testidb" dropped |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Creating table 'sbtest1'... |
|
Inserting 1000000 records into 'sbtest1' |
|
2.17user 0.04system 0:18.30elapsed 12%CPU (0avgtext+0avgdata 5328maxresident)k |
|
776inputs+0outputs (2major+426minor)pagefaults 0swaps |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Running the test with following options: |
|
Number of threads: 1 |
|
Initializing random number generator from current time |
|
|
|
|
|
Initializing worker threads... |
|
|
|
Threads started! |
|
|
|
OLTP test statistics: |
|
queries performed: |
|
read: 80290 |
|
write: 22940 |
|
other: 11470 |
|
total: 114700 |
|
transactions: 5735 (95.57 per sec.) |
|
read/write requests: 103230 (1720.34 per sec.) |
|
other operations: 11470 (191.15 per sec.) |
|
ignored errors: 0 (0.00 per sec.) |
|
reconnects: 0 (0.00 per sec.) |
|
|
|
General statistics: |
|
total time: 60.0055s |
|
total number of events: 5735 |
|
total time taken by event execution: 59.9957s |
|
response time: |
|
min: 3.70ms |
|
avg: 10.46ms |
|
max: 71.32ms |
|
approx. 95 percentile: 16.73ms |
|
|
|
Threads fairness: |
|
events (avg/stddev): 5735.0000/0.00 |
|
execution time (avg/stddev): 59.9957/0.00 |
|
|
|
upscaledb ------------------------------------------------- |
|
mysqladmin: DROP DATABASE test failed; |
|
error: 'Error dropping database (can't rmdir './test/', errno: 17)' |
|
mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'test'; |
|
database exists' |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Creating table 'sbtest1'... |
|
Inserting 1000000 records into 'sbtest1' |
|
2.02user 0.02system 0:50.82elapsed 4%CPU (0avgtext+0avgdata 5236maxresident)k |
|
0inputs+0outputs (0major+422minor)pagefaults 0swaps |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Running the test with following options: |
|
Number of threads: 1 |
|
Initializing random number generator from current time |
|
|
|
|
|
Initializing worker threads... |
|
|
|
Threads started! |
|
|
|
OLTP test statistics: |
|
queries performed: |
|
read: 528374 |
|
write: 150964 |
|
other: 75482 |
|
total: 754820 |
|
transactions: 37741 (629.01 per sec.) |
|
read/write requests: 679338 (11322.16 per sec.) |
|
other operations: 75482 (1258.02 per sec.) |
|
ignored errors: 0 (0.00 per sec.) |
|
reconnects: 0 (0.00 per sec.) |
|
|
|
General statistics: |
|
total time: 60.0007s |
|
total number of events: 37741 |
|
total time taken by event execution: 59.9660s |
|
response time: |
|
min: 1.05ms |
|
avg: 1.59ms |
|
max: 9.15ms |
|
approx. 95 percentile: 3.75ms |
|
|
|
Threads fairness: |
|
events (avg/stddev): 37741.0000/0.00 |
|
execution time (avg/stddev): 59.9660/0.00 |
|
|
|
======================================================================== |
|
======================================================================== |
|
======================================================================== |
|
|
|
same tests w/o transactions (oltp_skip_trx = 'on') - only read/write |
|
|
|
innodb ---------------------------------------------------- |
|
Database "testidb" dropped |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Creating table 'sbtest1'... |
|
Inserting 1000000 records into 'sbtest1' |
|
2.17user 0.04system 0:17.69elapsed 12%CPU (0avgtext+0avgdata 5236maxresident)k |
|
0inputs+0outputs (0major+427minor)pagefaults 0swaps |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Running the test with following options: |
|
Number of threads: 1 |
|
Initializing random number generator from current time |
|
|
|
|
|
Initializing worker threads... |
|
|
|
Threads started! |
|
|
|
OLTP test statistics: |
|
queries performed: |
|
read: 22274 |
|
write: 6364 |
|
other: 0 |
|
total: 28638 |
|
transactions: 0 (0.00 per sec.) |
|
read/write requests: 28638 (477.25 per sec.) |
|
other operations: 0 (0.00 per sec.) |
|
ignored errors: 0 (0.00 per sec.) |
|
reconnects: 0 (0.00 per sec.) |
|
|
|
General statistics: |
|
total time: 60.0058s |
|
total number of events: 1591 |
|
total time taken by event execution: 59.9990s |
|
response time: |
|
min: 22.75ms |
|
avg: 37.71ms |
|
max: 101.84ms |
|
approx. 95 percentile: 54.81ms |
|
|
|
Threads fairness: |
|
events (avg/stddev): 1591.0000/0.00 |
|
execution time (avg/stddev): 59.9990/0.00 |
|
|
|
upscaledb ------------------------------------------------- |
|
mysqladmin: DROP DATABASE test failed; |
|
error: 'Error dropping database (can't rmdir './test/', errno: 17)' |
|
mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'test'; |
|
database exists' |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Creating table 'sbtest1'... |
|
Inserting 1000000 records into 'sbtest1' |
|
2.07user 0.04system 0:53.79elapsed 3%CPU (0avgtext+0avgdata 5328maxresident)k |
|
0inputs+0outputs (0major+420minor)pagefaults 0swaps |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Running the test with following options: |
|
Number of threads: 1 |
|
Initializing random number generator from current time |
|
|
|
|
|
Initializing worker threads... |
|
|
|
Threads started! |
|
|
|
OLTP test statistics: |
|
queries performed: |
|
read: 524748 |
|
write: 149928 |
|
other: 0 |
|
total: 674676 |
|
transactions: 0 (0.00 per sec.) |
|
read/write requests: 674676 (11244.40 per sec.) |
|
other operations: 0 (0.00 per sec.) |
|
ignored errors: 0 (0.00 per sec.) |
|
reconnects: 0 (0.00 per sec.) |
|
|
|
General statistics: |
|
total time: 60.0011s |
|
total number of events: 37482 |
|
total time taken by event execution: 59.9594s |
|
response time: |
|
min: 1.03ms |
|
avg: 1.60ms |
|
max: 151.81ms |
|
approx. 95 percentile: 3.63ms |
|
|
|
Threads fairness: |
|
events (avg/stddev): 37482.0000/0.00 |
|
execution time (avg/stddev): 59.9594/0.00 |
|
|
|
======================================================================== |
|
======================================================================== |
|
======================================================================== |
|
|
|
with LOCK TABLE |
|
|
|
innodb ---------------------------------------------------- |
|
Database "testidb" dropped |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Creating table 'sbtest1'... |
|
Inserting 1000000 records into 'sbtest1' |
|
2.16user 0.03system 0:18.05elapsed 12%CPU (0avgtext+0avgdata 5368maxresident)k |
|
0inputs+0outputs (0major+422minor)pagefaults 0swaps |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Running the test with following options: |
|
Number of threads: 1 |
|
Initializing random number generator from current time |
|
|
|
|
|
Initializing worker threads... |
|
|
|
Threads started! |
|
|
|
OLTP test statistics: |
|
queries performed: |
|
read: 21826 |
|
write: 6236 |
|
other: 3118 |
|
total: 31180 |
|
transactions: 1559 (25.97 per sec.) |
|
read/write requests: 28062 (467.52 per sec.) |
|
other operations: 3118 (51.95 per sec.) |
|
ignored errors: 0 (0.00 per sec.) |
|
reconnects: 0 (0.00 per sec.) |
|
|
|
General statistics: |
|
total time: 60.0230s |
|
total number of events: 1559 |
|
total time taken by event execution: 60.0182s |
|
response time: |
|
min: 26.85ms |
|
avg: 38.50ms |
|
max: 99.85ms |
|
approx. 95 percentile: 57.02ms |
|
|
|
Threads fairness: |
|
events (avg/stddev): 1559.0000/0.00 |
|
execution time (avg/stddev): 60.0182/0.00 |
|
|
|
upscaledb ------------------------------------------------- |
|
mysqladmin: DROP DATABASE test failed; |
|
error: 'Error dropping database (can't rmdir './test/', errno: 17)' |
|
mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'test'; |
|
database exists' |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Creating table 'sbtest1'... |
|
Inserting 1000000 records into 'sbtest1' |
|
2.01user 0.03system 0:51.15elapsed 4%CPU (0avgtext+0avgdata 5368maxresident)k |
|
0inputs+0outputs (0major+426minor)pagefaults 0swaps |
|
sysbench 1.0: multi-threaded system evaluation benchmark |
|
|
|
Running the test with following options: |
|
Number of threads: 1 |
|
Initializing random number generator from current time |
|
|
|
|
|
Initializing worker threads... |
|
|
|
Threads started! |
|
|
|
OLTP test statistics: |
|
queries performed: |
|
read: 536872 |
|
write: 153392 |
|
other: 76696 |
|
total: 766960 |
|
transactions: 38348 (639.12 per sec.) |
|
read/write requests: 690264 (11504.23 per sec.) |
|
other operations: 76696 (1278.25 per sec.) |
|
ignored errors: 0 (0.00 per sec.) |
|
reconnects: 0 (0.00 per sec.) |
|
|
|
General statistics: |
|
total time: 60.0009s |
|
total number of events: 38348 |
|
total time taken by event execution: 59.9621s |
|
response time: |
|
min: 1.02ms |
|
avg: 1.56ms |
|
max: 6.91ms |
|
approx. 95 percentile: 3.65ms |
|
|
|
Threads fairness: |
|
events (avg/stddev): 38348.0000/0.00 |
|
execution time (avg/stddev): 59.9621/0.00 |