**** CPU1 **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Prime numbers limit: 10000 Initializing worker threads... Threads started! CPU speed: events per second: 1465.67 General statistics: total time: 10.0005s total number of events: 14663 Latency (ms): min: 0.67 avg: 0.68 max: 1.71 95th percentile: 0.69 sum: 9997.97 Threads fairness: events (avg/stddev): 14663.0000/0.00 execution time (avg/stddev): 9.9980/0.00 **** CPU2 **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 2 Initializing random number generator from current time Prime numbers limit: 10000 Initializing worker threads... Threads started! CPU speed: events per second: 2926.68 General statistics: total time: 10.0007s total number of events: 29279 Latency (ms): min: 0.66 avg: 0.68 max: 1.84 95th percentile: 0.69 sum: 19993.87 Threads fairness: events (avg/stddev): 14639.5000/7.50 execution time (avg/stddev): 9.9969/0.00 **** CPU4 **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 4 Initializing random number generator from current time Prime numbers limit: 100000 Initializing worker threads... Threads started! CPU speed: events per second: 234.86 General statistics: total time: 10.0194s total number of events: 2354 Latency (ms): min: 16.84 avg: 17.01 max: 42.33 95th percentile: 17.32 sum: 40041.83 Threads fairness: events (avg/stddev): 588.5000/2.50 execution time (avg/stddev): 10.0105/0.01 **** OLTP1 **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 121954 write: 34844 other: 17422 total: 174220 transactions: 8711 (145.17 per sec.) queries: 174220 (2903.43 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0013s total number of events: 8711 Latency (ms): min: 3.38 avg: 6.88 max: 49.55 95th percentile: 8.28 sum: 59971.64 Threads fairness: events (avg/stddev): 8711.0000/0.00 execution time (avg/stddev): 59.9716/0.00 **** OLTP4 **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 4 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 400372 write: 114392 other: 57196 total: 571960 transactions: 28598 (476.55 per sec.) queries: 571960 (9530.96 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0074s total number of events: 28598 Latency (ms): min: 4.21 avg: 8.39 max: 58.24 95th percentile: 9.73 sum: 239907.43 Threads fairness: events (avg/stddev): 7149.5000/24.74 execution time (avg/stddev): 59.9769/0.00 **** OLTP8 **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 8 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 734356 write: 209816 other: 104908 total: 1049080 transactions: 52454 (874.08 per sec.) queries: 1049080 (17481.55 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 60.0075s total number of events: 52454 Latency (ms): min: 4.02 avg: 9.15 max: 86.43 95th percentile: 10.65 sum: 479827.46 Threads fairness: events (avg/stddev): 6556.7500/33.08 execution time (avg/stddev): 59.9784/0.00 **** RNDRW - random read/write **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Extra file open flags: (none) 128 files, 48MiB each 6GiB total file size Block size 16KiB Number of IO requests: 0 Read/Write ratio for combined random IO test: 1.50 Periodic FSYNC enabled, calling fsync() each 100 requests. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random r/w test Initializing worker threads... Threads started! File operations: reads/s: 739.95 writes/s: 493.30 fsyncs/s: 1578.98 Throughput: read, MiB/s: 11.56 written, MiB/s: 7.71 General statistics: total time: 300.0161s total number of events: 843597 Latency (ms): min: 0.00 avg: 0.35 max: 16.38 95th percentile: 1.82 sum: 299127.84 Threads fairness: events (avg/stddev): 843597.0000/0.00 execution time (avg/stddev): 299.1278/0.00 **** RNDWR - random write **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Extra file open flags: (none) 128 files, 48MiB each 6GiB total file size Block size 16KiB Number of IO requests: 0 Read/Write ratio for combined random IO test: 1.50 Periodic FSYNC enabled, calling fsync() each 100 requests. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random write test Initializing worker threads... Threads started! File operations: reads/s: 0.00 writes/s: 717.20 fsyncs/s: 918.33 Throughput: read, MiB/s: 0.00 written, MiB/s: 11.21 General statistics: total time: 300.0536s total number of events: 490624 Latency (ms): min: 0.00 avg: 0.61 max: 17.58 95th percentile: 1.93 sum: 299413.53 Threads fairness: events (avg/stddev): 490624.0000/0.00 execution time (avg/stddev): 299.4135/0.00 **** SEQWR - sequential write **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Extra file open flags: (none) 128 files, 48MiB each 6GiB total file size Block size 16KiB Periodic FSYNC enabled, calling fsync() each 100 requests. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing sequential write (creation) test Initializing worker threads... Threads started! File operations: reads/s: 0.00 writes/s: 3717.36 fsyncs/s: 4758.58 Throughput: read, MiB/s: 0.00 written, MiB/s: 58.08 General statistics: total time: 300.0214s total number of events: 2542864 Latency (ms): min: 0.00 avg: 0.12 max: 20.25 95th percentile: 0.15 sum: 298435.74 Threads fairness: events (avg/stddev): 2542864.0000/0.00 execution time (avg/stddev): 298.4357/0.00 **** SEQRD - sequential read **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Extra file open flags: (none) 128 files, 48MiB each 6GiB total file size Block size 16KiB Periodic FSYNC enabled, calling fsync() each 100 requests. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing sequential read test Initializing worker threads... Threads started! File operations: reads/s: 536678.44 writes/s: 0.00 fsyncs/s: 0.00 Throughput: read, MiB/s: 8385.60 written, MiB/s: 0.00 General statistics: total time: 300.0002s total number of events: 161005610 Latency (ms): min: 0.00 avg: 0.00 max: 0.33 95th percentile: 0.00 sum: 274064.03 Threads fairness: events (avg/stddev): 161005610.0000/0.00 execution time (avg/stddev): 274.0640/0.00 **** RNDRD - random read **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Extra file open flags: (none) 128 files, 48MiB each 6GiB total file size Block size 16KiB Number of IO requests: 0 Read/Write ratio for combined random IO test: 1.50 Periodic FSYNC enabled, calling fsync() each 100 requests. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random read test Initializing worker threads... Threads started! File operations: reads/s: 421293.68 writes/s: 0.00 fsyncs/s: 0.00 Throughput: read, MiB/s: 6582.71 written, MiB/s: 0.00 General statistics: total time: 300.0002s total number of events: 126389759 Latency (ms): min: 0.00 avg: 0.00 max: 0.27 95th percentile: 0.00 sum: 278085.58 Threads fairness: events (avg/stddev): 126389759.0000/0.00 execution time (avg/stddev): 278.0856/0.00 **** SEQREWR - sequential rewrite **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Extra file open flags: (none) 128 files, 48MiB each 6GiB total file size Block size 16KiB Periodic FSYNC enabled, calling fsync() each 100 requests. Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing sequential rewrite test Initializing worker threads... Threads started! File operations: reads/s: 0.00 writes/s: 3806.65 fsyncs/s: 4872.58 Throughput: read, MiB/s: 0.00 written, MiB/s: 59.48 General statistics: total time: 300.0241s total number of events: 2603879 Latency (ms): min: 0.00 avg: 0.11 max: 41.58 95th percentile: 0.15 sum: 298453.26 Threads fairness: events (avg/stddev): 2603879.0000/0.00 execution time (avg/stddev): 298.4533/0.00 **** MEMORY **** sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 1 Initializing random number generator from current time Running memory speed test with the following options: block size: 1KiB total size: 102400MiB operation: write scope: global Initializing worker threads... Threads started! Total operations: 48999476 (4898039.74 per second) 47851.05 MiB transferred (4783.24 MiB/sec) General statistics: total time: 10.0002s total number of events: 48999476 Latency (ms): min: 0.00 avg: 0.00 max: 0.31 95th percentile: 0.00 sum: 4219.16 Threads fairness: events (avg/stddev): 48999476.0000/0.00 execution time (avg/stddev): 4.2192/0.00