Installing MariaDB/MySQL system tables in '/mnt/sbtest' ... 2023-09-27 16:06:23 0 [Warning] Ignoring user change to 'marko' because the user was set to 'root' earlier on the command line OK waiting for server to come up .mysqld is alive sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Creating table 'sbtest1'... Inserting 1500000 records into 'sbtest1' Creating a secondary index on 'sbtest1'... Creating table 'sbtest2'... Inserting 1500000 records into 'sbtest2' Creating a secondary index on 'sbtest2'... Creating table 'sbtest3'... Inserting 1500000 records into 'sbtest3' Creating a secondary index on 'sbtest3'... Creating table 'sbtest4'... Inserting 1500000 records into 'sbtest4' Creating a secondary index on 'sbtest4'... Creating table 'sbtest5'... Inserting 1500000 records into 'sbtest5' Creating a secondary index on 'sbtest5'... Creating table 'sbtest6'... Inserting 1500000 records into 'sbtest6' Creating a secondary index on 'sbtest6'... Creating table 'sbtest7'... Inserting 1500000 records into 'sbtest7' Creating a secondary index on 'sbtest7'... Creating table 'sbtest8'... Inserting 1500000 records into 'sbtest8' Creating a secondary index on 'sbtest8'... Creating table 'sbtest9'... Inserting 1500000 records into 'sbtest9' Creating a secondary index on 'sbtest9'... Creating table 'sbtest10'... Inserting 1500000 records into 'sbtest10' Creating a secondary index on 'sbtest10'... Creating table 'sbtest11'... Inserting 1500000 records into 'sbtest11' Creating a secondary index on 'sbtest11'... Creating table 'sbtest12'... Inserting 1500000 records into 'sbtest12' Creating a secondary index on 'sbtest12'... Creating table 'sbtest13'... Inserting 1500000 records into 'sbtest13' Creating a secondary index on 'sbtest13'... Creating table 'sbtest14'... Inserting 1500000 records into 'sbtest14' Creating a secondary index on 'sbtest14'... Creating table 'sbtest15'... Inserting 1500000 records into 'sbtest15' Creating a secondary index on 'sbtest15'... Creating table 'sbtest16'... Inserting 1500000 records into 'sbtest16' Creating a secondary index on 'sbtest16'... Creating table 'sbtest17'... Inserting 1500000 records into 'sbtest17' Creating a secondary index on 'sbtest17'... Creating table 'sbtest18'... Inserting 1500000 records into 'sbtest18' Creating a secondary index on 'sbtest18'... Creating table 'sbtest19'... Inserting 1500000 records into 'sbtest19' Creating a secondary index on 'sbtest19'... Creating table 'sbtest20'... Inserting 1500000 records into 'sbtest20' Creating a secondary index on 'sbtest20'... Creating table 'sbtest21'... Inserting 1500000 records into 'sbtest21' Creating a secondary index on 'sbtest21'... Creating table 'sbtest22'... Inserting 1500000 records into 'sbtest22' Creating a secondary index on 'sbtest22'... Creating table 'sbtest23'... Inserting 1500000 records into 'sbtest23' Creating a secondary index on 'sbtest23'... Creating table 'sbtest24'... Inserting 1500000 records into 'sbtest24' Creating a secondary index on 'sbtest24'... Creating table 'sbtest25'... Inserting 1500000 records into 'sbtest25' Creating a secondary index on 'sbtest25'... Creating table 'sbtest26'... Inserting 1500000 records into 'sbtest26' Creating a secondary index on 'sbtest26'... Creating table 'sbtest27'... Inserting 1500000 records into 'sbtest27' Creating a secondary index on 'sbtest27'... Creating table 'sbtest28'... Inserting 1500000 records into 'sbtest28' Creating a secondary index on 'sbtest28'... Creating table 'sbtest29'... Inserting 1500000 records into 'sbtest29' Creating a secondary index on 'sbtest29'... Creating table 'sbtest30'... Inserting 1500000 records into 'sbtest30' Creating a secondary index on 'sbtest30'... Creating table 'sbtest31'... Inserting 1500000 records into 'sbtest31' Creating a secondary index on 'sbtest31'... Creating table 'sbtest32'... Inserting 1500000 records into 'sbtest32' Creating a secondary index on 'sbtest32'... Creating table 'sbtest33'... Inserting 1500000 records into 'sbtest33' Creating a secondary index on 'sbtest33'... Creating table 'sbtest34'... Inserting 1500000 records into 'sbtest34' Creating a secondary index on 'sbtest34'... Creating table 'sbtest35'... Inserting 1500000 records into 'sbtest35' Creating a secondary index on 'sbtest35'... Creating table 'sbtest36'... Inserting 1500000 records into 'sbtest36' Creating a secondary index on 'sbtest36'... Creating table 'sbtest37'... Inserting 1500000 records into 'sbtest37' Creating a secondary index on 'sbtest37'... Creating table 'sbtest38'... Inserting 1500000 records into 'sbtest38' Creating a secondary index on 'sbtest38'... Creating table 'sbtest39'... Inserting 1500000 records into 'sbtest39' Creating a secondary index on 'sbtest39'... Creating table 'sbtest40'... Inserting 1500000 records into 'sbtest40' Creating a secondary index on 'sbtest40'... Creating table 'sbtest41'... Inserting 1500000 records into 'sbtest41' Creating a secondary index on 'sbtest41'... Creating table 'sbtest42'... Inserting 1500000 records into 'sbtest42' Creating a secondary index on 'sbtest42'... Creating table 'sbtest43'... Inserting 1500000 records into 'sbtest43' Creating a secondary index on 'sbtest43'... Creating table 'sbtest44'... Inserting 1500000 records into 'sbtest44' Creating a secondary index on 'sbtest44'... Creating table 'sbtest45'... Inserting 1500000 records into 'sbtest45' Creating a secondary index on 'sbtest45'... Creating table 'sbtest46'... Inserting 1500000 records into 'sbtest46' Creating a secondary index on 'sbtest46'... Creating table 'sbtest47'... Inserting 1500000 records into 'sbtest47' Creating a secondary index on 'sbtest47'... Creating table 'sbtest48'... Inserting 1500000 records into 'sbtest48' Creating a secondary index on 'sbtest48'... Creating table 'sbtest49'... Inserting 1500000 records into 'sbtest49' Creating a secondary index on 'sbtest49'... Creating table 'sbtest50'... Inserting 1500000 records into 'sbtest50' Creating a secondary index on 'sbtest50'... Creating table 'sbtest51'... Inserting 1500000 records into 'sbtest51' Creating a secondary index on 'sbtest51'... Creating table 'sbtest52'... Inserting 1500000 records into 'sbtest52' Creating a secondary index on 'sbtest52'... Creating table 'sbtest53'... Inserting 1500000 records into 'sbtest53' Creating a secondary index on 'sbtest53'... Creating table 'sbtest54'... Inserting 1500000 records into 'sbtest54' Creating a secondary index on 'sbtest54'... Creating table 'sbtest55'... Inserting 1500000 records into 'sbtest55' Creating a secondary index on 'sbtest55'... Creating table 'sbtest56'... Inserting 1500000 records into 'sbtest56' Creating a secondary index on 'sbtest56'... Creating table 'sbtest57'... Inserting 1500000 records into 'sbtest57' Creating a secondary index on 'sbtest57'... Creating table 'sbtest58'... Inserting 1500000 records into 'sbtest58' Creating a secondary index on 'sbtest58'... Creating table 'sbtest59'... Inserting 1500000 records into 'sbtest59' Creating a secondary index on 'sbtest59'... Creating table 'sbtest60'... Inserting 1500000 records into 'sbtest60' Creating a secondary index on 'sbtest60'... Creating table 'sbtest61'... Inserting 1500000 records into 'sbtest61' Creating a secondary index on 'sbtest61'... Creating table 'sbtest62'... Inserting 1500000 records into 'sbtest62' Creating a secondary index on 'sbtest62'... Creating table 'sbtest63'... Inserting 1500000 records into 'sbtest63' Creating a secondary index on 'sbtest63'... Creating table 'sbtest64'... Inserting 1500000 records into 'sbtest64' Creating a secondary index on 'sbtest64'... Creating table 'sbtest65'... Inserting 1500000 records into 'sbtest65' Creating a secondary index on 'sbtest65'... Creating table 'sbtest66'... Inserting 1500000 records into 'sbtest66' Creating a secondary index on 'sbtest66'... Creating table 'sbtest67'... Inserting 1500000 records into 'sbtest67' Creating a secondary index on 'sbtest67'... Creating table 'sbtest68'... Inserting 1500000 records into 'sbtest68' Creating a secondary index on 'sbtest68'... Creating table 'sbtest69'... Inserting 1500000 records into 'sbtest69' Creating a secondary index on 'sbtest69'... Creating table 'sbtest70'... Inserting 1500000 records into 'sbtest70' Creating a secondary index on 'sbtest70'... Creating table 'sbtest71'... Inserting 1500000 records into 'sbtest71' Creating a secondary index on 'sbtest71'... Creating table 'sbtest72'... Inserting 1500000 records into 'sbtest72' Creating a secondary index on 'sbtest72'... Creating table 'sbtest73'... Inserting 1500000 records into 'sbtest73' Creating a secondary index on 'sbtest73'... Creating table 'sbtest74'... Inserting 1500000 records into 'sbtest74' Creating a secondary index on 'sbtest74'... Creating table 'sbtest75'... Inserting 1500000 records into 'sbtest75' Creating a secondary index on 'sbtest75'... Creating table 'sbtest76'... Inserting 1500000 records into 'sbtest76' Creating a secondary index on 'sbtest76'... Creating table 'sbtest77'... Inserting 1500000 records into 'sbtest77' Creating a secondary index on 'sbtest77'... Creating table 'sbtest78'... Inserting 1500000 records into 'sbtest78' Creating a secondary index on 'sbtest78'... Creating table 'sbtest79'... Inserting 1500000 records into 'sbtest79' Creating a secondary index on 'sbtest79'... Creating table 'sbtest80'... Inserting 1500000 records into 'sbtest80' Creating a secondary index on 'sbtest80'... Creating table 'sbtest81'... Inserting 1500000 records into 'sbtest81' Creating a secondary index on 'sbtest81'... Creating table 'sbtest82'... Inserting 1500000 records into 'sbtest82' Creating a secondary index on 'sbtest82'... Creating table 'sbtest83'... Inserting 1500000 records into 'sbtest83' Creating a secondary index on 'sbtest83'... Creating table 'sbtest84'... Inserting 1500000 records into 'sbtest84' Creating a secondary index on 'sbtest84'... Creating table 'sbtest85'... Inserting 1500000 records into 'sbtest85' Creating a secondary index on 'sbtest85'... Creating table 'sbtest86'... Inserting 1500000 records into 'sbtest86' Creating a secondary index on 'sbtest86'... Creating table 'sbtest87'... Inserting 1500000 records into 'sbtest87' Creating a secondary index on 'sbtest87'... Creating table 'sbtest88'... Inserting 1500000 records into 'sbtest88' Creating a secondary index on 'sbtest88'... Creating table 'sbtest89'... Inserting 1500000 records into 'sbtest89' Creating a secondary index on 'sbtest89'... Creating table 'sbtest90'... Inserting 1500000 records into 'sbtest90' Creating a secondary index on 'sbtest90'... Creating table 'sbtest91'... Inserting 1500000 records into 'sbtest91' Creating a secondary index on 'sbtest91'... Creating table 'sbtest92'... Inserting 1500000 records into 'sbtest92' Creating a secondary index on 'sbtest92'... Creating table 'sbtest93'... Inserting 1500000 records into 'sbtest93' Creating a secondary index on 'sbtest93'... Creating table 'sbtest94'... Inserting 1500000 records into 'sbtest94' Creating a secondary index on 'sbtest94'... Creating table 'sbtest95'... Inserting 1500000 records into 'sbtest95' Creating a secondary index on 'sbtest95'... Creating table 'sbtest96'... Inserting 1500000 records into 'sbtest96' Creating a secondary index on 'sbtest96'... Creating table 'sbtest97'... Inserting 1500000 records into 'sbtest97' Creating a secondary index on 'sbtest97'... Creating table 'sbtest98'... Inserting 1500000 records into 'sbtest98' Creating a secondary index on 'sbtest98'... Creating table 'sbtest99'... Inserting 1500000 records into 'sbtest99' Creating a secondary index on 'sbtest99'... Creating table 'sbtest100'... Inserting 1500000 records into 'sbtest100' Creating a secondary index on 'sbtest100'... sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 10 Report intermediate results every 5 second(s) Initializing random number generator from seed (42). Initializing worker threads... Threads started! [ 5s ] thds: 10 tps: 88551.38 qps: 88551.38 (r/w/o: 0.00/88551.38/0.00) lat (ms,99%): 0.48 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 10 tps: 106535.91 qps: 106535.91 (r/w/o: 0.00/106535.91/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 10 tps: 106445.14 qps: 106445.14 (r/w/o: 0.00/106445.14/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 10 tps: 108152.28 qps: 108152.28 (r/w/o: 0.00/108152.28/0.00) lat (ms,99%): 0.16 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 10 tps: 71478.03 qps: 71478.23 (r/w/o: 0.00/71478.23/0.00) lat (ms,99%): 0.87 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 10 tps: 68004.49 qps: 68004.29 (r/w/o: 0.00/68004.29/0.00) lat (ms,99%): 0.87 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 10 tps: 30520.20 qps: 30520.20 (r/w/o: 0.00/30520.20/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 10 tps: 81914.54 qps: 81914.54 (r/w/o: 0.00/81914.54/0.00) lat (ms,99%): 0.65 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 10 tps: 108755.89 qps: 108755.89 (r/w/o: 0.00/108755.89/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 10 tps: 93455.65 qps: 93455.65 (r/w/o: 0.00/93455.65/0.00) lat (ms,99%): 0.46 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 10 tps: 32191.68 qps: 32191.68 (r/w/o: 0.00/32191.68/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 10 tps: 36204.95 qps: 36204.95 (r/w/o: 0.00/36204.95/0.00) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 10 tps: 31058.52 qps: 31058.52 (r/w/o: 0.00/31058.52/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 10 tps: 32248.17 qps: 32248.17 (r/w/o: 0.00/32248.17/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 10 tps: 32463.61 qps: 32463.61 (r/w/o: 0.00/32463.61/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 10 tps: 33394.33 qps: 33394.33 (r/w/o: 0.00/33394.33/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 10 tps: 36639.81 qps: 36639.81 (r/w/o: 0.00/36639.81/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 10 tps: 33408.67 qps: 33408.67 (r/w/o: 0.00/33408.67/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 10 tps: 32989.71 qps: 32989.71 (r/w/o: 0.00/32989.71/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 10 tps: 33197.18 qps: 33197.18 (r/w/o: 0.00/33197.18/0.00) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 10 tps: 30994.91 qps: 30994.91 (r/w/o: 0.00/30994.91/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 10 tps: 34144.42 qps: 34144.42 (r/w/o: 0.00/34144.42/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 10 tps: 36002.24 qps: 36002.24 (r/w/o: 0.00/36002.24/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 10 tps: 31945.90 qps: 31945.90 (r/w/o: 0.00/31945.90/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 10 tps: 31732.01 qps: 31732.01 (r/w/o: 0.00/31732.01/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 10 tps: 31225.63 qps: 31225.63 (r/w/o: 0.00/31225.63/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 10 tps: 31451.56 qps: 31451.56 (r/w/o: 0.00/31451.56/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 10 tps: 33133.96 qps: 33133.96 (r/w/o: 0.00/33133.96/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 10 tps: 30371.33 qps: 30371.33 (r/w/o: 0.00/30371.33/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 10 tps: 31095.81 qps: 31095.81 (r/w/o: 0.00/31095.81/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 10 tps: 35481.46 qps: 35481.46 (r/w/o: 0.00/35481.46/0.00) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 10 tps: 31614.78 qps: 31614.78 (r/w/o: 0.00/31614.78/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 10 tps: 31690.56 qps: 31690.56 (r/w/o: 0.00/31690.56/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 10 tps: 30625.09 qps: 30625.09 (r/w/o: 0.00/30625.09/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 10 tps: 31202.57 qps: 31202.57 (r/w/o: 0.00/31202.57/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 10 tps: 31622.95 qps: 31622.95 (r/w/o: 0.00/31622.95/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 10 tps: 28882.83 qps: 28882.83 (r/w/o: 0.00/28882.83/0.00) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 10 tps: 31529.21 qps: 31529.21 (r/w/o: 0.00/31529.21/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 10 tps: 45217.62 qps: 45217.62 (r/w/o: 0.00/45217.62/0.00) lat (ms,99%): 1.12 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 10 tps: 31244.64 qps: 31244.64 (r/w/o: 0.00/31244.64/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 10 tps: 32119.50 qps: 32119.50 (r/w/o: 0.00/32119.50/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 10 tps: 31582.74 qps: 31582.74 (r/w/o: 0.00/31582.74/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 10 tps: 30450.44 qps: 30450.44 (r/w/o: 0.00/30450.44/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 10 tps: 33450.12 qps: 33450.12 (r/w/o: 0.00/33450.12/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 10 tps: 30455.23 qps: 30455.23 (r/w/o: 0.00/30455.23/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 10 tps: 31026.83 qps: 31027.03 (r/w/o: 0.00/31027.03/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 10 tps: 32525.74 qps: 32525.54 (r/w/o: 0.00/32525.54/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 10 tps: 30554.91 qps: 30554.91 (r/w/o: 0.00/30554.91/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 10 tps: 31358.79 qps: 31358.79 (r/w/o: 0.00/31358.79/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 10 tps: 31143.10 qps: 31143.10 (r/w/o: 0.00/31143.10/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 10 tps: 30805.18 qps: 30805.18 (r/w/o: 0.00/30805.18/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 10 tps: 32056.00 qps: 32056.20 (r/w/o: 0.00/32056.20/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 10 tps: 37808.14 qps: 37808.14 (r/w/o: 0.00/37808.14/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 10 tps: 35118.94 qps: 35118.74 (r/w/o: 0.00/35118.74/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 10 tps: 32209.32 qps: 32209.32 (r/w/o: 0.00/32209.32/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 10 tps: 30704.67 qps: 30704.67 (r/w/o: 0.00/30704.67/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 10 tps: 41134.58 qps: 41134.58 (r/w/o: 0.00/41134.58/0.00) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 10 tps: 36767.30 qps: 36767.30 (r/w/o: 0.00/36767.30/0.00) lat (ms,99%): 1.18 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 10 tps: 33678.96 qps: 33678.96 (r/w/o: 0.00/33678.96/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 10 tps: 32055.91 qps: 32055.91 (r/w/o: 0.00/32055.91/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 12529501 other: 0 total: 12529501 transactions: 12529501 (41763.37 per sec.) queries: 12529501 (41763.37 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0085s total number of events: 12529501 Latency (ms): min: 0.06 avg: 0.24 max: 97.11 99th percentile: 1.21 sum: 2990621.42 Threads fairness: events (avg/stddev): 1252950.1000/7529.55 execution time (avg/stddev): 299.0621/0.01 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 20 Report intermediate results every 5 second(s) Initializing random number generator from seed (42). Initializing worker threads... Threads started! [ 5s ] thds: 20 tps: 196725.80 qps: 196725.80 (r/w/o: 0.00/97037.51/99688.29) lat (ms,99%): 0.22 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 20 tps: 185884.47 qps: 185884.47 (r/w/o: 0.00/84633.03/101251.44) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 20 tps: 169528.95 qps: 169528.95 (r/w/o: 0.00/76950.60/92578.35) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 20 tps: 186218.76 qps: 186218.76 (r/w/o: 0.00/85462.01/100756.76) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 20 tps: 188867.68 qps: 188867.68 (r/w/o: 0.00/88501.13/100366.55) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 20 tps: 190486.27 qps: 190486.27 (r/w/o: 0.00/90183.04/100303.23) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 20 tps: 188355.58 qps: 188355.58 (r/w/o: 0.00/86972.62/101382.96) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 20 tps: 188189.83 qps: 188189.83 (r/w/o: 0.00/87435.32/100754.51) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 20 tps: 189400.01 qps: 189400.01 (r/w/o: 0.00/89308.60/100091.41) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 20 tps: 187395.50 qps: 187395.50 (r/w/o: 0.00/87924.29/99471.21) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 20 tps: 200539.53 qps: 200539.53 (r/w/o: 0.00/100455.67/100083.85) lat (ms,99%): 0.25 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 20 tps: 202737.51 qps: 202737.51 (r/w/o: 0.00/103787.77/98949.74) lat (ms,99%): 0.19 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 20 tps: 185381.70 qps: 185381.70 (r/w/o: 0.00/88487.80/96893.90) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 20 tps: 188561.74 qps: 188561.74 (r/w/o: 0.00/92474.63/96087.11) lat (ms,99%): 0.34 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 20 tps: 183255.30 qps: 183255.30 (r/w/o: 0.00/88560.25/94695.05) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 20 tps: 180100.99 qps: 180100.99 (r/w/o: 0.00/87240.88/92860.11) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 20 tps: 201204.85 qps: 201205.05 (r/w/o: 0.00/104912.97/96292.07) lat (ms,99%): 0.19 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 20 tps: 190200.31 qps: 190200.11 (r/w/o: 0.00/94395.56/95804.56) lat (ms,99%): 0.33 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 20 tps: 191510.83 qps: 191510.83 (r/w/o: 0.00/96035.42/95475.41) lat (ms,99%): 0.31 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 20 tps: 160273.07 qps: 160273.07 (r/w/o: 0.00/79438.80/80834.26) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 20 tps: 64359.88 qps: 64359.88 (r/w/o: 0.00/34701.62/29658.26) lat (ms,99%): 0.24 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 20 tps: 63833.84 qps: 63833.84 (r/w/o: 0.00/34336.89/29496.95) lat (ms,99%): 0.24 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 20 tps: 64033.08 qps: 64033.08 (r/w/o: 0.00/33535.88/30497.20) lat (ms,99%): 0.26 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 20 tps: 65009.21 qps: 65009.21 (r/w/o: 0.00/35364.38/29644.84) lat (ms,99%): 0.24 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 20 tps: 60499.60 qps: 60499.60 (r/w/o: 0.00/31483.81/29015.79) lat (ms,99%): 0.32 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 20 tps: 66367.46 qps: 66367.46 (r/w/o: 0.00/33906.83/32460.62) lat (ms,99%): 0.34 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 20 tps: 64789.50 qps: 64789.50 (r/w/o: 0.00/33087.72/31701.78) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 20 tps: 65939.90 qps: 65939.90 (r/w/o: 0.00/33997.47/31942.42) lat (ms,99%): 0.49 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 20 tps: 60146.07 qps: 60146.07 (r/w/o: 0.00/35481.34/24664.73) lat (ms,99%): 0.27 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 20 tps: 50402.87 qps: 50402.87 (r/w/o: 0.00/36720.29/13682.58) lat (ms,99%): 0.26 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 20 tps: 42779.99 qps: 42779.99 (r/w/o: 0.00/36641.27/6138.71) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 20 tps: 39601.75 qps: 39601.75 (r/w/o: 0.00/36238.97/3362.78) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 20 tps: 37893.44 qps: 37893.44 (r/w/o: 0.00/37711.86/181.58) lat (ms,99%): 0.30 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 20 tps: 38269.89 qps: 38269.89 (r/w/o: 0.00/38269.89/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 20 tps: 37983.80 qps: 37983.80 (r/w/o: 0.00/37983.80/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 20 tps: 36254.18 qps: 36254.18 (r/w/o: 0.00/36254.18/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 20 tps: 37675.35 qps: 37675.35 (r/w/o: 0.00/37675.35/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 20 tps: 37623.76 qps: 37623.96 (r/w/o: 0.00/37623.96/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 20 tps: 36943.31 qps: 36943.11 (r/w/o: 0.00/36943.11/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 20 tps: 35650.51 qps: 35650.51 (r/w/o: 0.00/35650.51/0.00) lat (ms,99%): 0.30 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 20 tps: 38154.03 qps: 38154.03 (r/w/o: 0.00/38154.03/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 20 tps: 36754.97 qps: 36754.97 (r/w/o: 0.00/36754.97/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 20 tps: 36282.52 qps: 36282.52 (r/w/o: 0.00/36282.52/0.00) lat (ms,99%): 0.30 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 20 tps: 38575.29 qps: 38575.29 (r/w/o: 0.00/38575.29/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 20 tps: 37383.90 qps: 37383.90 (r/w/o: 0.00/37383.90/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 20 tps: 36986.77 qps: 36986.77 (r/w/o: 0.00/36986.77/0.00) lat (ms,99%): 0.30 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 20 tps: 36279.43 qps: 36279.43 (r/w/o: 0.00/36279.43/0.00) lat (ms,99%): 0.30 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 20 tps: 37948.92 qps: 37948.92 (r/w/o: 0.00/37948.92/0.00) lat (ms,99%): 0.27 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 20 tps: 35157.63 qps: 35157.63 (r/w/o: 0.00/35157.63/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 20 tps: 38194.06 qps: 38194.06 (r/w/o: 0.00/38194.06/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 20 tps: 36897.12 qps: 36897.12 (r/w/o: 0.00/36897.12/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 20 tps: 38013.07 qps: 38013.07 (r/w/o: 0.00/38013.07/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 20 tps: 38269.83 qps: 38269.83 (r/w/o: 0.00/38269.83/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 20 tps: 37777.69 qps: 37777.69 (r/w/o: 0.00/37777.69/0.00) lat (ms,99%): 0.30 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 20 tps: 36579.16 qps: 36579.16 (r/w/o: 0.00/36579.16/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 20 tps: 38553.36 qps: 38553.36 (r/w/o: 0.00/38553.36/0.00) lat (ms,99%): 0.28 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 20 tps: 35407.19 qps: 35407.19 (r/w/o: 0.00/35407.19/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 20 tps: 37770.63 qps: 37770.63 (r/w/o: 0.00/37770.63/0.00) lat (ms,99%): 0.27 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 20 tps: 39032.31 qps: 39032.31 (r/w/o: 0.00/39032.31/0.00) lat (ms,99%): 0.27 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 20 tps: 36543.52 qps: 36543.52 (r/w/o: 0.00/36543.52/0.00) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 16352177 other: 11185653 total: 27537830 transactions: 27537830 (91734.40 per sec.) queries: 27537830 (91734.40 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.1868s total number of events: 27537830 Latency (ms): min: 0.05 avg: 0.22 max: 2132.19 99th percentile: 0.32 sum: 5987675.74 Threads fairness: events (avg/stddev): 1376891.5000/173633.91 execution time (avg/stddev): 299.3838/0.10 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 40 Report intermediate results every 5 second(s) Initializing random number generator from seed (42). Initializing worker threads... Threads started! [ 5s ] thds: 40 tps: 62209.96 qps: 62209.96 (r/w/o: 0.00/33328.21/28881.75) lat (ms,99%): 0.52 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 40 tps: 63992.15 qps: 63992.15 (r/w/o: 0.00/33793.03/30199.12) lat (ms,99%): 0.48 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 40 tps: 64664.24 qps: 64664.24 (r/w/o: 0.00/35078.68/29585.56) lat (ms,99%): 0.45 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 40 tps: 58270.64 qps: 58270.64 (r/w/o: 0.00/31614.73/26655.91) lat (ms,99%): 0.55 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 40 tps: 54891.42 qps: 54891.42 (r/w/o: 0.00/30929.76/23961.65) lat (ms,99%): 0.56 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 40 tps: 64291.99 qps: 64291.99 (r/w/o: 0.00/35169.50/29122.49) lat (ms,99%): 0.46 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 40 tps: 59919.23 qps: 59919.23 (r/w/o: 0.00/33109.40/26809.83) lat (ms,99%): 0.65 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 40 tps: 64699.47 qps: 64699.47 (r/w/o: 0.00/35385.66/29313.80) lat (ms,99%): 0.49 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 40 tps: 57742.22 qps: 57742.22 (r/w/o: 0.00/32421.43/25320.79) lat (ms,99%): 0.47 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 40 tps: 66391.47 qps: 66391.47 (r/w/o: 0.00/35895.40/30496.07) lat (ms,99%): 0.55 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 40 tps: 59225.78 qps: 59225.78 (r/w/o: 0.00/32745.07/26480.70) lat (ms,99%): 0.62 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 40 tps: 62453.58 qps: 62453.58 (r/w/o: 0.00/34483.92/27969.66) lat (ms,99%): 0.60 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 40 tps: 63119.46 qps: 63119.46 (r/w/o: 0.00/34894.90/28224.56) lat (ms,99%): 0.54 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 40 tps: 58297.60 qps: 58297.60 (r/w/o: 0.00/32111.98/26185.62) lat (ms,99%): 0.54 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 40 tps: 57519.16 qps: 57519.16 (r/w/o: 0.00/31262.23/26256.93) lat (ms,99%): 0.50 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 40 tps: 66100.52 qps: 66100.52 (r/w/o: 0.00/36884.18/29216.34) lat (ms,99%): 0.51 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 40 tps: 67885.21 qps: 67885.21 (r/w/o: 0.00/37891.55/29993.66) lat (ms,99%): 0.59 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 40 tps: 67336.84 qps: 67336.84 (r/w/o: 0.00/37210.79/30126.04) lat (ms,99%): 0.59 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 40 tps: 72191.76 qps: 72191.76 (r/w/o: 0.00/40231.99/31959.77) lat (ms,99%): 0.56 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 40 tps: 72469.29 qps: 72469.29 (r/w/o: 0.00/40701.07/31768.22) lat (ms,99%): 0.59 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 40 tps: 70201.07 qps: 70201.07 (r/w/o: 0.00/39127.65/31073.42) lat (ms,99%): 0.70 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 40 tps: 72571.71 qps: 72571.71 (r/w/o: 0.00/40797.74/31773.97) lat (ms,99%): 0.62 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 40 tps: 73444.32 qps: 73444.32 (r/w/o: 0.00/41454.09/31990.23) lat (ms,99%): 0.65 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 40 tps: 74642.12 qps: 74642.12 (r/w/o: 0.00/43580.89/31061.23) lat (ms,99%): 0.63 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 40 tps: 79686.80 qps: 79686.80 (r/w/o: 0.00/45464.49/34222.31) lat (ms,99%): 0.63 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 40 tps: 72185.89 qps: 72185.89 (r/w/o: 0.00/40790.04/31395.84) lat (ms,99%): 0.73 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 40 tps: 71798.18 qps: 71798.18 (r/w/o: 0.00/41166.89/30631.29) lat (ms,99%): 0.58 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 40 tps: 111174.14 qps: 111174.14 (r/w/o: 0.00/64111.06/47063.08) lat (ms,99%): 0.55 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 40 tps: 93899.42 qps: 93899.42 (r/w/o: 0.00/54316.13/39583.29) lat (ms,99%): 0.62 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 40 tps: 102772.09 qps: 102772.09 (r/w/o: 0.00/60038.32/42733.77) lat (ms,99%): 0.58 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 40 tps: 101513.40 qps: 101513.40 (r/w/o: 0.00/59227.43/42285.96) lat (ms,99%): 0.60 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 40 tps: 104166.89 qps: 104166.89 (r/w/o: 0.00/60245.31/43921.57) lat (ms,99%): 0.62 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 40 tps: 107257.62 qps: 107257.62 (r/w/o: 0.00/63151.96/44105.67) lat (ms,99%): 0.56 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 40 tps: 108264.48 qps: 108264.48 (r/w/o: 0.00/62966.55/45297.93) lat (ms,99%): 0.54 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 40 tps: 99187.78 qps: 99187.78 (r/w/o: 0.00/57156.29/42031.49) lat (ms,99%): 0.57 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 40 tps: 102194.74 qps: 102194.74 (r/w/o: 0.00/59671.22/42523.53) lat (ms,99%): 0.58 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 40 tps: 111280.45 qps: 111280.45 (r/w/o: 0.00/66168.21/45112.24) lat (ms,99%): 0.56 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 40 tps: 128231.77 qps: 128231.77 (r/w/o: 0.00/75517.38/52714.39) lat (ms,99%): 0.51 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 40 tps: 124416.37 qps: 124416.37 (r/w/o: 0.00/72969.20/51447.17) lat (ms,99%): 0.55 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 40 tps: 121515.47 qps: 121515.67 (r/w/o: 0.00/72922.36/48593.31) lat (ms,99%): 0.52 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 40 tps: 121804.58 qps: 121804.38 (r/w/o: 0.00/73043.83/48760.55) lat (ms,99%): 0.49 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 40 tps: 130666.67 qps: 130666.67 (r/w/o: 0.00/75480.39/55186.28) lat (ms,99%): 0.51 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 40 tps: 123656.22 qps: 123656.22 (r/w/o: 0.00/73518.15/50138.07) lat (ms,99%): 0.50 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 40 tps: 123262.23 qps: 123262.23 (r/w/o: 0.00/73859.10/49403.13) lat (ms,99%): 0.52 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 40 tps: 141012.08 qps: 141012.08 (r/w/o: 0.00/82151.93/58860.15) lat (ms,99%): 0.50 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 40 tps: 130406.86 qps: 130406.86 (r/w/o: 0.00/77675.35/52731.51) lat (ms,99%): 0.49 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 40 tps: 135304.43 qps: 135304.43 (r/w/o: 0.00/80354.42/54950.01) lat (ms,99%): 0.48 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 40 tps: 119770.33 qps: 119770.33 (r/w/o: 0.00/71456.29/48314.04) lat (ms,99%): 0.51 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 40 tps: 97271.89 qps: 97271.89 (r/w/o: 0.00/58031.65/39240.24) lat (ms,99%): 0.61 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 40 tps: 88074.35 qps: 88074.35 (r/w/o: 0.00/52362.74/35711.61) lat (ms,99%): 0.64 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 40 tps: 80168.46 qps: 80168.46 (r/w/o: 0.00/48490.51/31677.96) lat (ms,99%): 0.67 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 40 tps: 78499.82 qps: 78500.02 (r/w/o: 0.00/47081.93/31418.09) lat (ms,99%): 0.62 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 40 tps: 76001.59 qps: 76001.39 (r/w/o: 0.00/44500.41/31500.99) lat (ms,99%): 0.64 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 40 tps: 70221.98 qps: 70221.98 (r/w/o: 0.00/40572.31/29649.67) lat (ms,99%): 0.64 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 40 tps: 71376.29 qps: 71376.29 (r/w/o: 0.00/40659.80/30716.49) lat (ms,99%): 0.59 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 40 tps: 61625.44 qps: 61625.44 (r/w/o: 0.00/35504.20/26121.24) lat (ms,99%): 0.56 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 40 tps: 56074.15 qps: 56074.15 (r/w/o: 0.00/31780.72/24293.43) lat (ms,99%): 0.49 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 40 tps: 54439.55 qps: 54439.55 (r/w/o: 0.00/30878.64/23560.90) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 40 tps: 55182.52 qps: 55182.52 (r/w/o: 0.00/31620.34/23562.18) lat (ms,99%): 0.45 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 40 tps: 59258.33 qps: 59258.33 (r/w/o: 0.00/32419.67/26838.66) lat (ms,99%): 0.48 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 14587276 other: 10753717 total: 25340993 transactions: 25340993 (84433.94 per sec.) queries: 25340993 (84433.94 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.1240s total number of events: 25340993 Latency (ms): min: 0.05 avg: 0.47 max: 1587.66 99th percentile: 0.56 sum: 11983718.23 Threads fairness: events (avg/stddev): 633524.8250/35917.93 execution time (avg/stddev): 299.5930/0.04 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 80 Report intermediate results every 5 second(s) Initializing random number generator from seed (42). Initializing worker threads... Threads started! [ 5s ] thds: 80 tps: 55080.18 qps: 55080.18 (r/w/o: 0.00/28869.87/26210.31) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 80 tps: 60160.27 qps: 60160.27 (r/w/o: 0.00/31742.73/28417.54) lat (ms,99%): 1.08 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 80 tps: 55869.08 qps: 55869.08 (r/w/o: 0.00/29280.09/26588.99) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 80 tps: 50711.59 qps: 50711.59 (r/w/o: 0.00/27476.78/23234.81) lat (ms,99%): 0.72 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 80 tps: 53830.41 qps: 53830.41 (r/w/o: 0.00/28251.08/25579.33) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 80 tps: 57202.93 qps: 57202.93 (r/w/o: 0.00/30198.56/27004.37) lat (ms,99%): 1.52 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 80 tps: 59271.06 qps: 59271.06 (r/w/o: 0.00/29305.62/29965.44) lat (ms,99%): 0.89 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 80 tps: 54940.57 qps: 54940.57 (r/w/o: 0.00/28523.05/26417.52) lat (ms,99%): 1.06 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 80 tps: 52239.79 qps: 52239.79 (r/w/o: 0.00/28427.63/23812.16) lat (ms,99%): 1.12 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 80 tps: 53090.13 qps: 53090.13 (r/w/o: 0.00/27633.11/25457.02) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 80 tps: 63542.57 qps: 63542.57 (r/w/o: 0.00/31930.88/31611.69) lat (ms,99%): 1.58 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 80 tps: 57090.70 qps: 57090.70 (r/w/o: 0.00/30261.17/26829.53) lat (ms,99%): 1.10 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 80 tps: 52025.38 qps: 52025.38 (r/w/o: 0.00/27812.75/24212.62) lat (ms,99%): 0.99 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 80 tps: 51793.71 qps: 51793.71 (r/w/o: 0.00/27148.84/24644.87) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 80 tps: 54535.28 qps: 54535.28 (r/w/o: 0.00/28634.55/25900.73) lat (ms,99%): 1.93 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 80 tps: 51420.64 qps: 51420.64 (r/w/o: 0.00/26837.77/24582.87) lat (ms,99%): 1.18 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 80 tps: 49815.26 qps: 49815.26 (r/w/o: 0.00/26570.28/23244.97) lat (ms,99%): 1.67 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 80 tps: 50783.82 qps: 50783.82 (r/w/o: 0.00/25305.71/25478.11) lat (ms,99%): 0.95 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 80 tps: 53567.05 qps: 53567.05 (r/w/o: 0.00/27760.96/25806.09) lat (ms,99%): 1.06 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 80 tps: 55050.34 qps: 55050.34 (r/w/o: 0.00/28267.20/26783.14) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 80 tps: 57383.84 qps: 57383.84 (r/w/o: 0.00/30598.35/26785.49) lat (ms,99%): 0.68 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 80 tps: 53952.24 qps: 53952.24 (r/w/o: 0.00/28331.09/25621.15) lat (ms,99%): 1.55 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 80 tps: 57140.14 qps: 57140.14 (r/w/o: 0.00/28723.90/28416.24) lat (ms,99%): 0.95 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 80 tps: 51613.91 qps: 51613.91 (r/w/o: 0.00/25299.15/26314.76) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 80 tps: 47359.00 qps: 47359.00 (r/w/o: 0.00/24476.99/22882.01) lat (ms,99%): 0.56 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 80 tps: 57012.60 qps: 57012.60 (r/w/o: 0.00/29434.64/27577.96) lat (ms,99%): 1.16 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 80 tps: 55092.35 qps: 55092.35 (r/w/o: 0.00/30033.87/25058.48) lat (ms,99%): 1.55 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 80 tps: 57163.24 qps: 57163.24 (r/w/o: 0.00/30748.93/26414.31) lat (ms,99%): 1.55 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 80 tps: 46871.40 qps: 46871.40 (r/w/o: 0.00/25055.02/21816.38) lat (ms,99%): 1.58 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 80 tps: 62053.53 qps: 62053.53 (r/w/o: 0.00/33027.19/29026.34) lat (ms,99%): 1.73 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 80 tps: 49505.79 qps: 49505.79 (r/w/o: 0.00/25952.12/23553.67) lat (ms,99%): 1.70 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 80 tps: 45281.23 qps: 45281.43 (r/w/o: 0.00/23303.33/21978.10) lat (ms,99%): 1.04 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 80 tps: 51371.13 qps: 51370.93 (r/w/o: 0.00/26817.96/24552.97) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 80 tps: 53984.56 qps: 53984.56 (r/w/o: 0.00/29464.01/24520.56) lat (ms,99%): 1.70 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 80 tps: 65021.87 qps: 65021.87 (r/w/o: 0.00/34543.12/30478.75) lat (ms,99%): 2.35 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 80 tps: 56426.57 qps: 56426.57 (r/w/o: 0.00/31131.92/25294.66) lat (ms,99%): 2.07 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 80 tps: 65258.00 qps: 65258.00 (r/w/o: 0.00/33024.36/32233.64) lat (ms,99%): 2.00 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 80 tps: 64443.21 qps: 64443.21 (r/w/o: 0.00/34401.51/30041.70) lat (ms,99%): 1.89 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 80 tps: 58029.86 qps: 58029.86 (r/w/o: 0.00/32867.15/25162.71) lat (ms,99%): 1.82 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 80 tps: 59098.52 qps: 59098.52 (r/w/o: 0.00/31810.10/27288.43) lat (ms,99%): 2.26 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 80 tps: 63435.08 qps: 63435.08 (r/w/o: 0.00/33706.74/29728.35) lat (ms,99%): 1.73 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 80 tps: 58337.81 qps: 58337.81 (r/w/o: 0.00/32065.79/26272.02) lat (ms,99%): 1.96 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 80 tps: 64478.91 qps: 64478.91 (r/w/o: 0.00/34406.67/30072.24) lat (ms,99%): 1.61 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 80 tps: 51928.21 qps: 51928.21 (r/w/o: 0.00/28672.95/23255.26) lat (ms,99%): 1.04 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 80 tps: 59012.88 qps: 59013.08 (r/w/o: 0.00/32228.57/26784.50) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 80 tps: 60036.44 qps: 60036.24 (r/w/o: 0.00/33379.42/26656.82) lat (ms,99%): 2.03 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 80 tps: 64143.84 qps: 64143.84 (r/w/o: 0.00/34908.12/29235.71) lat (ms,99%): 1.64 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 80 tps: 61456.93 qps: 61456.93 (r/w/o: 0.00/33189.63/28267.30) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 80 tps: 55568.55 qps: 55568.55 (r/w/o: 0.00/28833.22/26735.32) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 80 tps: 54697.14 qps: 54697.14 (r/w/o: 0.00/27896.78/26800.36) lat (ms,99%): 1.50 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 80 tps: 60995.78 qps: 60995.78 (r/w/o: 0.00/32238.58/28757.20) lat (ms,99%): 1.12 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 80 tps: 59297.73 qps: 59297.73 (r/w/o: 0.00/31899.83/27397.90) lat (ms,99%): 2.76 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 80 tps: 61049.36 qps: 61049.36 (r/w/o: 0.00/35255.75/25793.61) lat (ms,99%): 1.76 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 80 tps: 61193.68 qps: 61193.68 (r/w/o: 0.00/33186.37/28007.31) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 80 tps: 61993.05 qps: 61993.05 (r/w/o: 0.00/34346.64/27646.41) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 80 tps: 64687.23 qps: 64687.23 (r/w/o: 0.00/33848.36/30838.87) lat (ms,99%): 1.58 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 80 tps: 59068.72 qps: 59068.72 (r/w/o: 0.00/32156.20/26912.53) lat (ms,99%): 0.94 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 80 tps: 62426.36 qps: 62426.36 (r/w/o: 0.00/32940.21/29486.15) lat (ms,99%): 0.94 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 80 tps: 56412.45 qps: 56412.45 (r/w/o: 0.00/29653.72/26758.74) lat (ms,99%): 0.95 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 80 tps: 61968.70 qps: 61968.70 (r/w/o: 0.00/34281.92/27686.78) lat (ms,99%): 1.12 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 9042079 other: 7999566 total: 17041645 transactions: 17041645 (56763.85 per sec.) queries: 17041645 (56763.85 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.2160s total number of events: 17041645 Latency (ms): min: 0.05 avg: 1.41 max: 3400.70 99th percentile: 1.42 sum: 23992098.39 Threads fairness: events (avg/stddev): 213020.5625/30177.61 execution time (avg/stddev): 299.9012/0.03 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Running the test with following options: Number of threads: 160 Report intermediate results every 5 second(s) Initializing random number generator from seed (42). Initializing worker threads... Threads started! [ 5s ] thds: 160 tps: 79523.10 qps: 79523.10 (r/w/o: 0.00/32758.11/46765.00) lat (ms,99%): 3.68 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 160 tps: 70205.95 qps: 70205.95 (r/w/o: 0.00/31306.54/38899.41) lat (ms,99%): 2.81 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 160 tps: 72783.14 qps: 72783.14 (r/w/o: 0.00/32302.32/40480.82) lat (ms,99%): 3.75 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 160 tps: 70659.99 qps: 70659.99 (r/w/o: 0.00/33329.28/37330.71) lat (ms,99%): 1.79 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 160 tps: 66528.64 qps: 66528.64 (r/w/o: 0.00/31963.72/34564.92) lat (ms,99%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 160 tps: 75675.27 qps: 75675.27 (r/w/o: 0.00/33251.77/42423.50) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 160 tps: 76602.10 qps: 76602.10 (r/w/o: 0.00/34561.21/42040.90) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 160 tps: 77481.95 qps: 77481.95 (r/w/o: 0.00/36939.69/40542.26) lat (ms,99%): 1.76 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 160 tps: 77431.09 qps: 77431.09 (r/w/o: 0.00/36095.03/41336.06) lat (ms,99%): 2.71 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 160 tps: 81239.73 qps: 81239.73 (r/w/o: 0.00/34819.28/46420.44) lat (ms,99%): 2.91 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 160 tps: 81414.43 qps: 81414.43 (r/w/o: 0.00/37838.64/43575.80) lat (ms,99%): 3.49 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 160 tps: 71328.80 qps: 71328.80 (r/w/o: 0.00/33974.67/37354.13) lat (ms,99%): 5.18 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 160 tps: 84623.39 qps: 84623.39 (r/w/o: 0.00/41083.50/43539.89) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 160 tps: 88071.02 qps: 88071.02 (r/w/o: 0.00/41463.56/46607.46) lat (ms,99%): 2.22 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 160 tps: 87186.47 qps: 87186.47 (r/w/o: 0.00/43197.83/43988.63) lat (ms,99%): 6.32 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 160 tps: 95011.29 qps: 95011.29 (r/w/o: 0.00/40539.78/54471.51) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 160 tps: 88850.44 qps: 88850.44 (r/w/o: 0.00/41079.79/47770.66) lat (ms,99%): 4.03 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 160 tps: 100866.50 qps: 100866.50 (r/w/o: 0.00/49303.45/51563.05) lat (ms,99%): 2.14 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 160 tps: 85328.26 qps: 85328.26 (r/w/o: 0.00/42750.11/42578.14) lat (ms,99%): 3.89 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 160 tps: 91392.55 qps: 91392.55 (r/w/o: 0.00/42549.42/48843.13) lat (ms,99%): 4.57 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 160 tps: 92782.73 qps: 92782.73 (r/w/o: 0.00/43404.62/49378.11) lat (ms,99%): 3.75 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 160 tps: 37107.59 qps: 37107.19 (r/w/o: 0.00/17537.89/19569.30) lat (ms,99%): 7.98 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 160 tps: 224095.43 qps: 224096.03 (r/w/o: 0.00/101175.51/122920.52) lat (ms,99%): 5.37 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 160 tps: 115373.44 qps: 115373.24 (r/w/o: 0.00/56001.22/59372.02) lat (ms,99%): 4.33 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 160 tps: 100767.13 qps: 100767.13 (r/w/o: 0.00/45366.83/55400.30) lat (ms,99%): 3.49 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 160 tps: 92552.55 qps: 92552.55 (r/w/o: 0.00/44567.29/47985.26) lat (ms,99%): 7.30 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 160 tps: 96889.92 qps: 96889.92 (r/w/o: 0.00/50335.91/46554.01) lat (ms,99%): 5.28 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 160 tps: 82204.90 qps: 82204.90 (r/w/o: 0.00/42976.72/39228.18) lat (ms,99%): 37.56 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 160 tps: 82488.88 qps: 82488.88 (r/w/o: 0.00/43085.76/39403.11) lat (ms,99%): 37.56 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 160 tps: 103074.02 qps: 103074.02 (r/w/o: 0.00/50845.84/52228.19) lat (ms,99%): 4.82 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 160 tps: 102951.48 qps: 102951.48 (r/w/o: 0.00/53053.88/49897.59) lat (ms,99%): 4.49 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 160 tps: 191083.20 qps: 191083.00 (r/w/o: 0.00/98879.27/92203.73) lat (ms,99%): 3.96 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 160 tps: 88258.09 qps: 88258.29 (r/w/o: 0.00/46136.09/42122.19) lat (ms,99%): 12.08 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 160 tps: 98734.17 qps: 98734.17 (r/w/o: 0.00/51949.43/46784.73) lat (ms,99%): 9.56 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 160 tps: 88221.53 qps: 88221.53 (r/w/o: 0.00/44455.36/43766.17) lat (ms,99%): 39.65 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 160 tps: 82746.76 qps: 82746.76 (r/w/o: 0.00/42004.95/40741.80) lat (ms,99%): 16.12 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 160 tps: 111825.93 qps: 111825.93 (r/w/o: 0.00/55202.21/56623.72) lat (ms,99%): 5.00 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 160 tps: 92098.46 qps: 92098.46 (r/w/o: 0.00/49696.69/42401.77) lat (ms,99%): 15.27 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 160 tps: 96001.62 qps: 96001.62 (r/w/o: 0.00/49606.83/46394.79) lat (ms,99%): 6.32 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 160 tps: 85813.17 qps: 85813.17 (r/w/o: 0.00/42924.19/42888.99) lat (ms,99%): 26.20 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 160 tps: 83648.34 qps: 83648.14 (r/w/o: 0.00/43937.88/39710.25) lat (ms,99%): 15.55 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 160 tps: 90037.01 qps: 90037.21 (r/w/o: 0.00/45747.67/44289.54) lat (ms,99%): 7.56 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 160 tps: 85449.15 qps: 85449.15 (r/w/o: 0.00/46551.50/38897.66) lat (ms,99%): 4.65 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 160 tps: 100360.09 qps: 100360.09 (r/w/o: 0.00/52452.35/47907.73) lat (ms,99%): 7.70 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 160 tps: 73405.16 qps: 73405.16 (r/w/o: 0.00/38696.39/34708.77) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 160 tps: 73885.35 qps: 73885.35 (r/w/o: 0.00/38353.80/35531.55) lat (ms,99%): 41.10 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 160 tps: 84293.48 qps: 84293.08 (r/w/o: 0.00/41295.97/42997.11) lat (ms,99%): 5.99 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 160 tps: 92516.49 qps: 92516.89 (r/w/o: 0.00/41181.97/51334.92) lat (ms,99%): 4.82 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 160 tps: 75789.14 qps: 75789.14 (r/w/o: 0.00/38665.71/37123.43) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 160 tps: 73541.34 qps: 73541.34 (r/w/o: 0.00/39017.35/34523.99) lat (ms,99%): 20.74 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 160 tps: 75352.09 qps: 75352.09 (r/w/o: 0.00/36380.67/38971.42) lat (ms,99%): 5.67 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 160 tps: 70688.59 qps: 70688.59 (r/w/o: 0.00/37912.21/32776.38) lat (ms,99%): 6.43 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 160 tps: 66004.07 qps: 66004.07 (r/w/o: 0.00/35142.09/30861.98) lat (ms,99%): 6.21 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 160 tps: 68490.25 qps: 68490.25 (r/w/o: 0.00/36751.19/31739.06) lat (ms,99%): 6.09 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 160 tps: 68546.34 qps: 68546.34 (r/w/o: 0.00/34434.23/34112.10) lat (ms,99%): 29.72 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 160 tps: 60243.58 qps: 60243.58 (r/w/o: 0.00/34690.51/25553.07) lat (ms,99%): 7.70 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 160 tps: 63013.28 qps: 63013.28 (r/w/o: 0.00/33333.49/29679.79) lat (ms,99%): 38.94 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 160 tps: 59176.09 qps: 59176.09 (r/w/o: 0.00/34421.72/24754.37) lat (ms,99%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 160 tps: 54434.53 qps: 54434.53 (r/w/o: 0.00/33085.28/21349.25) lat (ms,99%): 51.94 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 160 tps: 52049.88 qps: 52049.88 (r/w/o: 0.00/32786.88/19263.00) lat (ms,99%): 36.89 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 12775956 other: 13015324 total: 25791280 transactions: 25791280 (85852.38 per sec.) queries: 25791280 (85852.38 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.4100s total number of events: 25791280 Latency (ms): min: 0.04 avg: 1.86 max: 4276.24 99th percentile: 5.37 sum: 48003788.21 Threads fairness: events (avg/stddev): 161195.5000/29847.61 execution time (avg/stddev): 300.0237/0.07 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) Dropping table 'sbtest1'... Dropping table 'sbtest2'... Dropping table 'sbtest3'... Dropping table 'sbtest4'... Dropping table 'sbtest5'... Dropping table 'sbtest6'... Dropping table 'sbtest7'... Dropping table 'sbtest8'... Dropping table 'sbtest9'... Dropping table 'sbtest10'... Dropping table 'sbtest11'... Dropping table 'sbtest12'... Dropping table 'sbtest13'... Dropping table 'sbtest14'... Dropping table 'sbtest15'... Dropping table 'sbtest16'... Dropping table 'sbtest17'... Dropping table 'sbtest18'... Dropping table 'sbtest19'... Dropping table 'sbtest20'... Dropping table 'sbtest21'... Dropping table 'sbtest22'... Dropping table 'sbtest23'... Dropping table 'sbtest24'... Dropping table 'sbtest25'... Dropping table 'sbtest26'... Dropping table 'sbtest27'... Dropping table 'sbtest28'... Dropping table 'sbtest29'... Dropping table 'sbtest30'... Dropping table 'sbtest31'... Dropping table 'sbtest32'... Dropping table 'sbtest33'... Dropping table 'sbtest34'... Dropping table 'sbtest35'... Dropping table 'sbtest36'... Dropping table 'sbtest37'... Dropping table 'sbtest38'... Dropping table 'sbtest39'... Dropping table 'sbtest40'... Dropping table 'sbtest41'... Dropping table 'sbtest42'... Dropping table 'sbtest43'... Dropping table 'sbtest44'... Dropping table 'sbtest45'... Dropping table 'sbtest46'... Dropping table 'sbtest47'... Dropping table 'sbtest48'... Dropping table 'sbtest49'... Dropping table 'sbtest50'... Dropping table 'sbtest51'... Dropping table 'sbtest52'... Dropping table 'sbtest53'... Dropping table 'sbtest54'... Dropping table 'sbtest55'... Dropping table 'sbtest56'... Dropping table 'sbtest57'... Dropping table 'sbtest58'... Dropping table 'sbtest59'... Dropping table 'sbtest60'... Dropping table 'sbtest61'... Dropping table 'sbtest62'... Dropping table 'sbtest63'... Dropping table 'sbtest64'... Dropping table 'sbtest65'... Dropping table 'sbtest66'... Dropping table 'sbtest67'... Dropping table 'sbtest68'... Dropping table 'sbtest69'... Dropping table 'sbtest70'... Dropping table 'sbtest71'... Dropping table 'sbtest72'... Dropping table 'sbtest73'... Dropping table 'sbtest74'... Dropping table 'sbtest75'... Dropping table 'sbtest76'... Dropping table 'sbtest77'... Dropping table 'sbtest78'... Dropping table 'sbtest79'... Dropping table 'sbtest80'... Dropping table 'sbtest81'... Dropping table 'sbtest82'... Dropping table 'sbtest83'... Dropping table 'sbtest84'... Dropping table 'sbtest85'... Dropping table 'sbtest86'... Dropping table 'sbtest87'... Dropping table 'sbtest88'... Dropping table 'sbtest89'... Dropping table 'sbtest90'... Dropping table 'sbtest91'... Dropping table 'sbtest92'... Dropping table 'sbtest93'... Dropping table 'sbtest94'... Dropping table 'sbtest95'... Dropping table 'sbtest96'... Dropping table 'sbtest97'... Dropping table 'sbtest98'... Dropping table 'sbtest99'... Dropping table 'sbtest100'...