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/1023934 to your computer and use it in GitHub Desktop.
Save bleything/1023934 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 802 98 63279 8 178785 22 3465 97 337376 17 400.9 79
Latency 16370us 2252ms 12813ms 12908us 237ms 71381us
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 1843 9 +++++ +++ 2541 8 2493 12 +++++ +++ 2524 8
Latency 1999ms 644us 49961us 14533us 25us 32424us
1.96,1.96,db01,4,1306892876,193736M,,802,98,63279,8,178785,22,3465,97,337376,17,400.9,79,16,,,,,1843,9,+++++,+++,2541,8,2493,12,+++++,+++,2524,8,16370us,2252ms,12813ms,12908us,237ms,71381us,1999ms,644us,49961us,14533us,25us,32424us
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 765 99 61248 7 165777 20 3134 97 321752 16 413.9 80
Latency 16120us 2259ms 11741ms 20242us 272ms 18215us
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 1740 8 +++++ +++ 2503 8 2499 11 +++++ +++ 2548 8
Latency 2437ms 663us 55227us 14312us 25us 27188us
1.96,1.96,db01,4,1306898199,193736M,,765,99,61248,7,165777,20,3134,97,321752,16,413.9,80,16,,,,,1740,8,+++++,+++,2503,8,2499,11,+++++,+++,2548,8,16120us,2259ms,11741ms,20242us,272ms,18215us,2437ms,663us,55227us,14312us,25us,27188us
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 805 99 62411 8 163271 19 3195 97 284567 14 400.4 77
Latency 15868us 2258ms 12811ms 12705us 255ms 23226us
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 1776 8 +++++ +++ 2476 8 2470 11 +++++ +++ 2424 7
Latency 2352ms 668us 75904us 17532us 27us 44566us
1.96,1.96,db01,4,1306902544,193736M,,805,99,62411,8,163271,19,3195,97,284567,14,400.4,77,16,,,,,1776,8,+++++,+++,2476,8,2470,11,+++++,+++,2424,7,15868us,2258ms,12811ms,12705us,255ms,23226us,2352ms,668us,75904us,17532us,27us,44566us
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 825 99 61778 7 180375 22 3040 98 324414 16 426.0 80
Latency 15683us 2448ms 12547ms 12713us 299ms 18598us
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 1753 8 +++++ +++ 2508 8 2488 11 +++++ +++ 2597 8
Latency 2487ms 646us 38109us 14941us 26us 39386us
1.96,1.96,db01,4,1306907652,193736M,,825,99,61778,7,180375,22,3040,98,324414,16,426.0,80,16,,,,,1753,8,+++++,+++,2508,8,2488,11,+++++,+++,2597,8,15683us,2448ms,12547ms,12713us,299ms,18598us,2487ms,646us,38109us,14941us,26us,39386us
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 795 99 62101 7 161757 19 3423 95 334216 17 422.5 78
Latency 16165us 2311ms 15166ms 34408us 229ms 23419us
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 1769 8 +++++ +++ 2519 8 2481 11 +++++ +++ 2481 8
Latency 2353ms 667us 54095us 23221us 25us 43344us
1.96,1.96,db01,4,1306913103,193736M,,795,99,62101,7,161757,19,3423,95,334216,17,422.5,78,16,,,,,1769,8,+++++,+++,2519,8,2481,11,+++++,+++,2481,8,16165us,2311ms,15166ms,34408us,229ms,23419us,2353ms,667us,54095us,23221us,25us,43344us
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 (129.23Mb/sec)
8270.50 Requests/sec executed
Test execution summary:
total time: 1.2091s
total number of events: 10000
total time taken by event execution: 0.1297
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 18.88ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1297/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 (127.04Mb/sec)
8130.70 Requests/sec executed
Test execution summary:
total time: 1.2299s
total number of events: 10000
total time taken by event execution: 0.1329
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 18.96ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1329/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 (127.19Mb/sec)
8140.27 Requests/sec executed
Test execution summary:
total time: 1.2285s
total number of events: 10000
total time taken by event execution: 0.1293
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 19.07ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1293/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 (125.31Mb/sec)
8019.75 Requests/sec executed
Test execution summary:
total time: 1.2469s
total number of events: 10000
total time taken by event execution: 0.1323
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 18.97ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1323/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 (125.48Mb/sec)
8030.69 Requests/sec executed
Test execution summary:
total time: 1.2452s
total number of events: 10000
total time taken by event execution: 0.1282
per-request statistics:
min: 0.01ms
avg: 0.01ms
max: 19.07ms
approx. 95 percentile: 0.01ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 0.1282/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.4518Mb/sec)
185.84 Requests/sec executed
Test execution summary:
total time: 53.8107s
total number of events: 10000
total time taken by event execution: 53.7725
per-request statistics:
min: 0.01ms
avg: 5.38ms
max: 34.63ms
approx. 95 percentile: 8.14ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 53.7725/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.4675Mb/sec)
187.84 Requests/sec executed
Test execution summary:
total time: 53.2370s
total number of events: 10000
total time taken by event execution: 53.2200
per-request statistics:
min: 0.01ms
avg: 5.32ms
max: 29.62ms
approx. 95 percentile: 8.07ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 53.2200/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.45Mb/sec)
185.60 Requests/sec executed
Test execution summary:
total time: 53.8788s
total number of events: 10000
total time taken by event execution: 53.8619
per-request statistics:
min: 0.01ms
avg: 5.39ms
max: 88.33ms
approx. 95 percentile: 8.14ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 53.8619/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.4691Mb/sec)
188.04 Requests/sec executed
Test execution summary:
total time: 53.1794s
total number of events: 10000
total time taken by event execution: 53.1626
per-request statistics:
min: 0.01ms
avg: 5.32ms
max: 41.67ms
approx. 95 percentile: 8.10ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 53.1626/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.4511Mb/sec)
185.74 Requests/sec executed
Test execution summary:
total time: 53.8395s
total number of events: 10000
total time taken by event execution: 53.8225
per-request statistics:
min: 0.01ms
avg: 5.38ms
max: 32.26ms
approx. 95 percentile: 8.16ms
Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 53.8225/0.00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment