Created
June 13, 2011 22:51
-
-
Save bleything/1023934 to your computer and use it in GitHub Desktop.
Revisions
-
bleything created this gist
Jun 13, 2011 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,11 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,11 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,11 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,11 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,11 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,36 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,36 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,36 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,36 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,36 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,34 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,34 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,34 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,34 @@ 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 This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,34 @@ 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