Skip to content

Instantly share code, notes, and snippets.

@bleything
Created June 13, 2011 22:51
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 bleything/1023935 to your computer and use it in GitHub Desktop.
Save bleything/1023935 to your computer and use it in GitHub Desktop.
Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 4 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
db01 193736M 790 99 66142 8 227980 27 2683 85 655455 31 358.8 68
Latency 15846us 2271ms 1682ms 162ms 582ms 35860us
Version 1.96 ------Sequential Create------ --------Random Create--------
db01 -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 2218 9 +++++ +++ 4101 11 3624 15 +++++ +++ 4114 11
Latency 2496ms 667us 948us 936us 160us 453us
1.96,1.96,db01,4,1306949260,193736M,,790,99,66142,8,227980,27,2683,85,655455,31,358.8,68,16,,,,,2218,9,+++++,+++,4101,11,3624,15,+++++,+++,4114,11,15846us,2271ms,1682ms,162ms,582ms,35860us,2496ms,667us,948us,936us,160us,453us
Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 4 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
db01 193736M 814 99 67043 8 226384 27 2637 84 617670 29 368.7 70
Latency 15969us 2283ms 1707ms 179ms 781ms 49602us
Version 1.96 ------Sequential Create------ --------Random Create--------
db01 -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 2185 10 +++++ +++ 4005 12 3415 16 +++++ +++ 3953 12
Latency 2343ms 648us 1034us 2877us 25us 993us
1.96,1.96,db01,4,1306953678,193736M,,814,99,67043,8,226384,27,2637,84,617670,29,368.7,70,16,,,,,2185,10,+++++,+++,4005,12,3415,16,+++++,+++,3953,12,15969us,2283ms,1707ms,179ms,781ms,49602us,2343ms,648us,1034us,2877us,25us,993us
Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 4 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
db01 193736M 802 99 67635 8 215959 26 2515 81 557031 26 349.1 66
Latency 15830us 2289ms 1649ms 141ms 775ms 35032us
Version 1.96 ------Sequential Create------ --------Random Create--------
db01 -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 2167 10 +++++ +++ 3947 12 3415 16 +++++ +++ 3925 12
Latency 2449ms 658us 1101us 1613us 27us 849us
1.96,1.96,db01,4,1306957456,193736M,,802,99,67635,8,215959,26,2515,81,557031,26,349.1,66,16,,,,,2167,10,+++++,+++,3947,12,3415,16,+++++,+++,3925,12,15830us,2289ms,1649ms,141ms,775ms,35032us,2449ms,658us,1101us,1613us,27us,849us
Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 4 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
db01 193736M 819 99 67327 8 236997 30 2940 83 659125 31 374.4 71
Latency 15740us 2225ms 1662ms 167ms 371ms 31467us
Version 1.96 ------Sequential Create------ --------Random Create--------
db01 -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 2204 9 +++++ +++ 4118 12 3630 15 +++++ +++ 4127 11
Latency 2451ms 662us 911us 888us 41us 861us
1.96,1.96,db01,4,1306961361,193736M,,819,99,67327,8,236997,30,2940,83,659125,31,374.4,71,16,,,,,2204,9,+++++,+++,4118,12,3630,15,+++++,+++,4127,11,15740us,2225ms,1662ms,167ms,371ms,31467us,2451ms,662us,911us,888us,41us,861us
Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 4 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
db01 193736M 798 99 67300 8 218617 26 2634 82 586393 28 391.3 71
Latency 15926us 2244ms 1644ms 203ms 303ms 31256us
Version 1.96 ------Sequential Create------ --------Random Create--------
db01 -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
16 2212 10 +++++ +++ 3981 13 3428 16 +++++ +++ 3971 13
Latency 2365ms 653us 967us 1570us 27us 895us
1.96,1.96,db01,4,1306965460,193736M,,798,99,67300,8,218617,26,2634,82,586393,28,391.3,71,16,,,,,2212,10,+++++,+++,3981,13,3428,16,+++++,+++,3971,13,15926us,2244ms,1644ms,203ms,303ms,31256us,2365ms,653us,967us,1570us,27us,895us
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
1 files, 16Kb each
16Kb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 1 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random write test
Threads started!
Done.
Operations performed: 0 Read, 10000 Write, 10000 Other = 20000 Total
Read 0b Written 156.25Mb Total transferred 156.25Mb (49.54Mb/sec)
3170.57 Requests/sec executed
Test execution summary:
total time: 3.1540s
total number of events: 10000
total time taken by event execution: 0.1374
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 24.96ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1374/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
1 files, 16Kb each
16Kb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 1 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random write test
Threads started!
Done.
Operations performed: 0 Read, 10000 Write, 10000 Other = 20000 Total
Read 0b Written 156.25Mb Total transferred 156.25Mb (118.85Mb/sec)
7606.69 Requests/sec executed
Test execution summary:
total time: 1.3146s
total number of events: 10000
total time taken by event execution: 0.1350
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 24.99ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1350/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
1 files, 16Kb each
16Kb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 1 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random write test
Threads started!
Done.
Operations performed: 0 Read, 10000 Write, 10000 Other = 20000 Total
Read 0b Written 156.25Mb Total transferred 156.25Mb (130.93Mb/sec)
8379.83 Requests/sec executed
Test execution summary:
total time: 1.1933s
total number of events: 10000
total time taken by event execution: 0.1397
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 24.93ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1397/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
1 files, 16Kb each
16Kb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 1 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random write test
Threads started!
Done.
Operations performed: 0 Read, 10000 Write, 10000 Other = 20000 Total
Read 0b Written 156.25Mb Total transferred 156.25Mb (119.18Mb/sec)
7627.63 Requests/sec executed
Test execution summary:
total time: 1.3110s
total number of events: 10000
total time taken by event execution: 0.1360
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 24.89ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1360/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
1 files, 16Kb each
16Kb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 1 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random write test
Threads started!
Done.
Operations performed: 0 Read, 10000 Write, 10000 Other = 20000 Total
Read 0b Written 156.25Mb Total transferred 156.25Mb (117.55Mb/sec)
7523.14 Requests/sec executed
Test execution summary:
total time: 1.3292s
total number of events: 10000
total time taken by event execution: 0.1384
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 25.11ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1384/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
500 files, 1Gb each
500Gb total file size
Block size 8Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random read test
Threads started!
Done.
Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 78.125Mb Written 0b Total transferred 78.125Mb (1.6201Mb/sec)
207.37 Requests/sec executed
Test execution summary:
total time: 48.2220s
total number of events: 10000
total time taken by event execution: 48.1874
per-request statistics:
min: 0.01ms
avg: 4.82ms
max: 42.64ms
approx. 95 percentile: 7.34ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 48.1874/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
500 files, 1Gb each
500Gb total file size
Block size 8Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random read test
Threads started!
Done.
Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 78.125Mb Written 0b Total transferred 78.125Mb (1.6477Mb/sec)
210.90 Requests/sec executed
Test execution summary:
total time: 47.4152s
total number of events: 10000
total time taken by event execution: 47.3777
per-request statistics:
min: 0.01ms
avg: 4.74ms
max: 19.52ms
approx. 95 percentile: 7.22ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 47.3777/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
500 files, 1Gb each
500Gb total file size
Block size 8Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random read test
Threads started!
Done.
Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 78.125Mb Written 0b Total transferred 78.125Mb (1.6308Mb/sec)
208.75 Requests/sec executed
Test execution summary:
total time: 47.9050s
total number of events: 10000
total time taken by event execution: 47.8730
per-request statistics:
min: 0.01ms
avg: 4.79ms
max: 20.36ms
approx. 95 percentile: 7.31ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 47.8730/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
500 files, 1Gb each
500Gb total file size
Block size 8Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random read test
Threads started!
Done.
Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 78.125Mb Written 0b Total transferred 78.125Mb (1.6449Mb/sec)
210.54 Requests/sec executed
Test execution summary:
total time: 47.4959s
total number of events: 10000
total time taken by event execution: 47.4616
per-request statistics:
min: 0.01ms
avg: 4.75ms
max: 21.57ms
approx. 95 percentile: 7.27ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 47.4616/0.00
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
500 files, 1Gb each
500Gb total file size
Block size 8Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random read test
Threads started!
Done.
Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 78.125Mb Written 0b Total transferred 78.125Mb (1.6243Mb/sec)
207.91 Requests/sec executed
Test execution summary:
total time: 48.0988s
total number of events: 10000
total time taken by event execution: 48.0632
per-request statistics:
min: 0.01ms
avg: 4.81ms
max: 80.17ms
approx. 95 percentile: 7.33ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 48.0632/0.00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment