Installing MariaDB/MySQL system tables in '/mnt/sbtest' ... 2023-09-27 18:03:47 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: 97987.66 qps: 97987.66 (r/w/o: 0.00/97987.66/0.00) lat (ms,99%): 0.21 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 10 tps: 80233.14 qps: 80233.14 (r/w/o: 0.00/80233.14/0.00) lat (ms,99%): 0.68 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 10 tps: 31016.04 qps: 31016.04 (r/w/o: 0.00/31016.04/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 10 tps: 45896.78 qps: 45896.78 (r/w/o: 0.00/45896.78/0.00) lat (ms,99%): 1.16 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 10 tps: 105856.79 qps: 105856.79 (r/w/o: 0.00/105856.79/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 10 tps: 103777.69 qps: 103777.69 (r/w/o: 0.00/103777.69/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 10 tps: 106013.66 qps: 106013.66 (r/w/o: 0.00/106013.66/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 10 tps: 105630.37 qps: 105630.37 (r/w/o: 0.00/105630.37/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 10 tps: 105107.95 qps: 105107.95 (r/w/o: 0.00/105107.95/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 10 tps: 107786.96 qps: 107786.96 (r/w/o: 0.00/107786.96/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 10 tps: 91236.52 qps: 91236.52 (r/w/o: 0.00/91236.52/0.00) lat (ms,99%): 0.46 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 10 tps: 37818.11 qps: 37818.11 (r/w/o: 0.00/37818.11/0.00) lat (ms,99%): 1.14 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 10 tps: 64760.80 qps: 64760.80 (r/w/o: 0.00/64760.80/0.00) lat (ms,99%): 0.86 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 10 tps: 70968.08 qps: 70968.08 (r/w/o: 0.00/70968.08/0.00) lat (ms,99%): 0.84 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 10 tps: 29250.33 qps: 29250.33 (r/w/o: 0.00/29250.33/0.00) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 10 tps: 28875.97 qps: 28875.97 (r/w/o: 0.00/28875.97/0.00) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 10 tps: 29576.40 qps: 29576.40 (r/w/o: 0.00/29576.40/0.00) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 10 tps: 31838.87 qps: 31838.87 (r/w/o: 0.00/31838.87/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 10 tps: 32136.04 qps: 32136.04 (r/w/o: 0.00/32136.04/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 10 tps: 31093.39 qps: 31093.39 (r/w/o: 0.00/31093.39/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 10 tps: 30083.35 qps: 30083.35 (r/w/o: 0.00/30083.35/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 10 tps: 32038.35 qps: 32038.35 (r/w/o: 0.00/32038.35/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 10 tps: 67706.24 qps: 67706.24 (r/w/o: 0.00/67706.24/0.00) lat (ms,99%): 0.87 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 10 tps: 56910.00 qps: 56910.00 (r/w/o: 0.00/56910.00/0.00) lat (ms,99%): 1.04 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 10 tps: 33397.83 qps: 33397.83 (r/w/o: 0.00/33397.83/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 10 tps: 30886.99 qps: 30886.99 (r/w/o: 0.00/30886.99/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 10 tps: 30592.20 qps: 30592.20 (r/w/o: 0.00/30592.20/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 10 tps: 32294.93 qps: 32294.93 (r/w/o: 0.00/32294.93/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 10 tps: 29726.07 qps: 29726.07 (r/w/o: 0.00/29726.07/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 10 tps: 30077.57 qps: 30077.57 (r/w/o: 0.00/30077.57/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 10 tps: 30576.61 qps: 30576.61 (r/w/o: 0.00/30576.61/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 10 tps: 30142.88 qps: 30142.88 (r/w/o: 0.00/30142.88/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 10 tps: 31144.71 qps: 31144.71 (r/w/o: 0.00/31144.71/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 10 tps: 30308.64 qps: 30308.64 (r/w/o: 0.00/30308.64/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 10 tps: 32694.45 qps: 32694.45 (r/w/o: 0.00/32694.45/0.00) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 10 tps: 104321.01 qps: 104321.01 (r/w/o: 0.00/104321.01/0.00) lat (ms,99%): 0.19 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 10 tps: 108884.10 qps: 108884.10 (r/w/o: 0.00/108884.10/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 10 tps: 108160.97 qps: 108160.97 (r/w/o: 0.00/108160.97/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 10 tps: 70105.27 qps: 70105.27 (r/w/o: 0.00/70105.27/0.00) lat (ms,99%): 0.83 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 10 tps: 33625.20 qps: 33625.20 (r/w/o: 0.00/33625.20/0.00) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 10 tps: 33590.64 qps: 33590.64 (r/w/o: 0.00/33590.64/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 10 tps: 31845.61 qps: 31845.61 (r/w/o: 0.00/31845.61/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 10 tps: 38079.42 qps: 38079.42 (r/w/o: 0.00/38079.42/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 10 tps: 30125.28 qps: 30125.28 (r/w/o: 0.00/30125.28/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 10 tps: 29891.76 qps: 29891.76 (r/w/o: 0.00/29891.76/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 10 tps: 31604.20 qps: 31604.20 (r/w/o: 0.00/31604.20/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 10 tps: 30471.57 qps: 30471.57 (r/w/o: 0.00/30471.57/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 10 tps: 36912.63 qps: 36912.63 (r/w/o: 0.00/36912.63/0.00) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 10 tps: 29667.94 qps: 29667.94 (r/w/o: 0.00/29667.94/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 10 tps: 30138.78 qps: 30138.78 (r/w/o: 0.00/30138.78/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 10 tps: 30769.93 qps: 30769.93 (r/w/o: 0.00/30769.93/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 10 tps: 31217.51 qps: 31217.51 (r/w/o: 0.00/31217.51/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 10 tps: 34520.89 qps: 34520.89 (r/w/o: 0.00/34520.89/0.00) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 10 tps: 43182.41 qps: 43182.41 (r/w/o: 0.00/43182.41/0.00) lat (ms,99%): 1.10 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 10 tps: 32441.92 qps: 32441.92 (r/w/o: 0.00/32441.92/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 10 tps: 30798.78 qps: 30798.78 (r/w/o: 0.00/30798.78/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 10 tps: 51481.56 qps: 51481.56 (r/w/o: 0.00/51481.56/0.00) lat (ms,99%): 1.08 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 10 tps: 69594.12 qps: 69594.12 (r/w/o: 0.00/69594.12/0.00) lat (ms,99%): 0.86 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 10 tps: 106110.59 qps: 106110.59 (r/w/o: 0.00/106110.59/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 10 tps: 98600.53 qps: 98600.53 (r/w/o: 0.00/98600.53/0.00) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 15708598 other: 0 total: 15708598 transactions: 15708598 (52359.83 per sec.) queries: 15708598 (52359.83 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0082s total number of events: 15708598 Latency (ms): min: 0.06 avg: 0.19 max: 95.74 99th percentile: 1.08 sum: 2990895.14 Threads fairness: events (avg/stddev): 1570859.8000/9623.85 execution time (avg/stddev): 299.0895/0.02 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: 197515.39 qps: 197515.39 (r/w/o: 0.00/100096.28/97419.11) lat (ms,99%): 0.20 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 20 tps: 185808.61 qps: 185808.61 (r/w/o: 0.00/87390.96/98417.65) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 20 tps: 186345.13 qps: 186345.13 (r/w/o: 0.00/88246.16/98098.97) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 20 tps: 188814.69 qps: 188814.69 (r/w/o: 0.00/90731.12/98083.57) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 20 tps: 201968.32 qps: 201968.32 (r/w/o: 0.00/104085.55/97882.77) lat (ms,99%): 0.20 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 20 tps: 186424.14 qps: 186424.14 (r/w/o: 0.00/89447.30/96976.84) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 20 tps: 186460.04 qps: 186460.04 (r/w/o: 0.00/89991.52/96468.52) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 20 tps: 185491.88 qps: 185491.88 (r/w/o: 0.00/89855.63/95636.25) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 20 tps: 194665.35 qps: 194665.35 (r/w/o: 0.00/98076.94/96588.42) lat (ms,99%): 0.29 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 20 tps: 190725.15 qps: 190725.15 (r/w/o: 0.00/94676.65/96048.50) lat (ms,99%): 0.33 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 20 tps: 185121.67 qps: 185121.67 (r/w/o: 0.00/90601.47/94520.19) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 20 tps: 202287.47 qps: 202287.47 (r/w/o: 0.00/106023.30/96264.17) lat (ms,99%): 0.21 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 20 tps: 202083.28 qps: 202083.28 (r/w/o: 0.00/105161.63/96921.65) lat (ms,99%): 0.20 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 20 tps: 185076.17 qps: 185076.17 (r/w/o: 0.00/91461.20/93614.97) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 20 tps: 184509.82 qps: 184509.82 (r/w/o: 0.00/91673.20/92836.63) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 20 tps: 202231.68 qps: 202231.68 (r/w/o: 0.00/107054.09/95177.59) lat (ms,99%): 0.19 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 20 tps: 185933.53 qps: 185933.53 (r/w/o: 0.00/93416.35/92517.18) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 20 tps: 186280.56 qps: 186280.56 (r/w/o: 0.00/93676.96/92603.59) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 20 tps: 185446.91 qps: 185446.91 (r/w/o: 0.00/93704.72/91742.19) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 20 tps: 200384.56 qps: 200384.56 (r/w/o: 0.00/106659.57/93724.99) lat (ms,99%): 0.22 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 20 tps: 206595.84 qps: 206595.84 (r/w/o: 0.00/112470.25/94125.59) lat (ms,99%): 0.14 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 20 tps: 186629.43 qps: 186629.43 (r/w/o: 0.00/95197.32/91432.11) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 20 tps: 185063.82 qps: 185063.82 (r/w/o: 0.00/94715.65/90348.16) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 20 tps: 186382.95 qps: 186382.95 (r/w/o: 0.00/96317.19/90065.76) lat (ms,99%): 0.34 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 20 tps: 187797.57 qps: 187797.57 (r/w/o: 0.00/98167.03/89630.54) lat (ms,99%): 0.32 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 20 tps: 184883.03 qps: 184883.03 (r/w/o: 0.00/95239.20/89643.83) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 20 tps: 184812.09 qps: 184812.09 (r/w/o: 0.00/95462.98/89349.12) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 20 tps: 184821.00 qps: 184821.00 (r/w/o: 0.00/96533.88/88287.13) lat (ms,99%): 0.34 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 20 tps: 195999.43 qps: 195999.43 (r/w/o: 0.00/116201.78/79797.66) lat (ms,99%): 0.23 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 20 tps: 185906.66 qps: 185906.86 (r/w/o: 0.00/178451.92/7454.94) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 20 tps: 186281.00 qps: 186280.80 (r/w/o: 0.00/186280.80/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 20 tps: 185440.15 qps: 185440.15 (r/w/o: 0.00/185440.15/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 20 tps: 183441.18 qps: 183441.18 (r/w/o: 0.00/183441.18/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 20 tps: 185943.17 qps: 185943.17 (r/w/o: 0.00/185943.17/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 20 tps: 184312.34 qps: 184312.34 (r/w/o: 0.00/184312.34/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 20 tps: 186633.80 qps: 186633.80 (r/w/o: 0.00/186633.80/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 20 tps: 185104.18 qps: 185104.18 (r/w/o: 0.00/185104.18/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 20 tps: 184635.49 qps: 184635.49 (r/w/o: 0.00/184635.49/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 20 tps: 184855.45 qps: 184855.45 (r/w/o: 0.00/184855.45/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 20 tps: 178516.62 qps: 178516.62 (r/w/o: 0.00/178516.62/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 20 tps: 183140.67 qps: 183140.67 (r/w/o: 0.00/183140.67/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 20 tps: 184094.15 qps: 184094.15 (r/w/o: 0.00/184094.15/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 20 tps: 186614.70 qps: 186614.70 (r/w/o: 0.00/186614.70/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 20 tps: 183621.32 qps: 183621.32 (r/w/o: 0.00/183621.32/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 20 tps: 185726.60 qps: 185726.60 (r/w/o: 0.00/185726.60/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 20 tps: 185892.53 qps: 185892.53 (r/w/o: 0.00/185892.53/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 20 tps: 187904.66 qps: 187904.66 (r/w/o: 0.00/187904.66/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 20 tps: 187662.96 qps: 187662.96 (r/w/o: 0.00/187662.96/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 20 tps: 186104.02 qps: 186104.02 (r/w/o: 0.00/186104.02/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 20 tps: 184477.20 qps: 184477.20 (r/w/o: 0.00/184477.20/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 20 tps: 185845.99 qps: 185845.99 (r/w/o: 0.00/185845.99/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 20 tps: 186165.32 qps: 186165.32 (r/w/o: 0.00/186165.32/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 20 tps: 184753.91 qps: 184753.91 (r/w/o: 0.00/184753.91/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 20 tps: 183829.74 qps: 183829.74 (r/w/o: 0.00/183829.74/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 20 tps: 185627.19 qps: 185627.19 (r/w/o: 0.00/185627.19/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 20 tps: 186078.19 qps: 186078.19 (r/w/o: 0.00/186078.19/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 20 tps: 183867.10 qps: 183867.10 (r/w/o: 0.00/183867.10/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 20 tps: 186591.00 qps: 186591.00 (r/w/o: 0.00/186591.00/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 20 tps: 185955.81 qps: 185955.81 (r/w/o: 0.00/185955.81/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 20 tps: 186086.00 qps: 186086.00 (r/w/o: 0.00/186086.00/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 42730218 other: 13608687 total: 56338905 transactions: 56338905 (187785.28 per sec.) queries: 56338905 (187785.28 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0157s total number of events: 56338905 Latency (ms): min: 0.05 avg: 0.11 max: 102.01 99th percentile: 0.24 sum: 5976388.46 Threads fairness: events (avg/stddev): 2816945.2500/190390.45 execution time (avg/stddev): 298.8194/0.07 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: 235536.50 qps: 235536.50 (r/w/o: 0.00/150738.21/84798.29) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 40 tps: 249347.48 qps: 249347.48 (r/w/o: 0.00/160714.08/88633.40) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 40 tps: 190625.74 qps: 190625.74 (r/w/o: 0.00/122348.43/68277.32) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 40 tps: 257701.78 qps: 257701.78 (r/w/o: 0.00/166133.72/91568.06) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 40 tps: 240312.27 qps: 240312.27 (r/w/o: 0.00/154323.31/85988.97) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 40 tps: 238623.45 qps: 238623.45 (r/w/o: 0.00/154150.49/84472.96) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 40 tps: 238833.04 qps: 238833.04 (r/w/o: 0.00/155373.00/83460.04) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 40 tps: 255414.42 qps: 255414.42 (r/w/o: 0.00/165754.97/89659.44) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 40 tps: 254968.03 qps: 254968.03 (r/w/o: 0.00/165833.02/89135.01) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 40 tps: 242055.61 qps: 242055.61 (r/w/o: 0.00/157289.70/84765.91) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 40 tps: 254784.18 qps: 254784.18 (r/w/o: 0.00/165927.78/88856.40) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 40 tps: 252090.70 qps: 252090.70 (r/w/o: 0.00/164731.04/87359.66) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 40 tps: 193374.73 qps: 193374.73 (r/w/o: 0.00/127162.17/66212.55) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 40 tps: 173349.29 qps: 173349.29 (r/w/o: 0.00/112736.50/60612.79) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 40 tps: 136717.06 qps: 136717.06 (r/w/o: 0.00/88056.69/48660.37) lat (ms,99%): 0.43 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 40 tps: 151051.98 qps: 151051.98 (r/w/o: 0.00/97760.74/53291.24) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 40 tps: 150049.91 qps: 150049.91 (r/w/o: 0.00/96956.42/53093.49) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 40 tps: 165836.98 qps: 165836.98 (r/w/o: 0.00/107239.78/58597.19) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 40 tps: 175846.75 qps: 175846.75 (r/w/o: 0.00/114363.32/61483.43) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 40 tps: 226952.05 qps: 226952.05 (r/w/o: 0.00/147586.57/79365.48) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 40 tps: 169174.78 qps: 169174.98 (r/w/o: 0.00/109639.01/59535.98) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 40 tps: 188400.83 qps: 188400.63 (r/w/o: 0.00/123089.89/65310.74) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 40 tps: 170275.19 qps: 170275.19 (r/w/o: 0.00/111136.90/59138.29) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 40 tps: 225652.79 qps: 225652.99 (r/w/o: 0.00/148392.92/77260.06) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 40 tps: 174904.45 qps: 174904.25 (r/w/o: 0.00/114110.52/60793.73) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 40 tps: 191095.96 qps: 191095.96 (r/w/o: 0.00/125068.31/66027.66) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 40 tps: 186969.11 qps: 186969.11 (r/w/o: 0.00/122816.50/64152.62) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 40 tps: 214005.60 qps: 214005.60 (r/w/o: 0.00/140856.38/73149.22) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 40 tps: 166459.02 qps: 166459.02 (r/w/o: 0.00/109334.47/57124.56) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 40 tps: 174172.43 qps: 174172.43 (r/w/o: 0.00/114982.31/59190.13) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 40 tps: 185218.20 qps: 185218.20 (r/w/o: 0.00/122324.12/62894.08) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 40 tps: 200109.15 qps: 200109.15 (r/w/o: 0.00/132638.90/67470.25) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 40 tps: 177281.66 qps: 177281.66 (r/w/o: 0.00/117638.33/59643.33) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 40 tps: 147531.34 qps: 147531.34 (r/w/o: 0.00/98315.16/49216.18) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 40 tps: 200640.68 qps: 200640.68 (r/w/o: 0.00/133789.10/66851.57) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 40 tps: 173722.72 qps: 173722.72 (r/w/o: 0.00/115226.38/58496.34) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 40 tps: 183043.23 qps: 183043.23 (r/w/o: 0.00/120792.73/62250.50) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 40 tps: 228530.46 qps: 228530.46 (r/w/o: 0.00/151714.55/76815.91) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 40 tps: 182780.18 qps: 182780.18 (r/w/o: 0.00/122232.20/60547.98) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 40 tps: 201227.72 qps: 201227.72 (r/w/o: 0.00/134659.46/66568.26) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 40 tps: 192456.93 qps: 192456.93 (r/w/o: 0.00/128628.36/63828.57) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 40 tps: 212178.01 qps: 212178.01 (r/w/o: 0.00/142353.27/69824.74) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 40 tps: 182381.52 qps: 182381.72 (r/w/o: 0.00/122867.07/59514.66) lat (ms,99%): 0.43 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 40 tps: 189591.04 qps: 189590.84 (r/w/o: 0.00/127543.77/62047.08) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 40 tps: 172967.83 qps: 172967.83 (r/w/o: 0.00/116778.30/56189.53) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 40 tps: 224830.27 qps: 224830.27 (r/w/o: 0.00/151791.18/73039.09) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 40 tps: 175520.88 qps: 175520.88 (r/w/o: 0.00/118602.98/56917.89) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 40 tps: 152292.18 qps: 152292.18 (r/w/o: 0.00/102895.66/49396.52) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 40 tps: 166721.79 qps: 166721.79 (r/w/o: 0.00/112794.69/53927.10) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 40 tps: 190907.80 qps: 190907.80 (r/w/o: 0.00/129257.71/61650.09) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 40 tps: 154811.82 qps: 154811.82 (r/w/o: 0.00/104625.83/50186.00) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 40 tps: 133819.99 qps: 133819.99 (r/w/o: 0.00/91057.88/42762.12) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 40 tps: 218326.67 qps: 218326.67 (r/w/o: 0.00/148390.76/69935.91) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 40 tps: 149326.98 qps: 149326.98 (r/w/o: 0.00/101843.82/47483.16) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 40 tps: 140506.48 qps: 140506.48 (r/w/o: 0.00/96034.17/44472.31) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 40 tps: 190596.72 qps: 190596.72 (r/w/o: 0.00/129766.41/60830.31) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 40 tps: 172642.48 qps: 172642.48 (r/w/o: 0.00/117950.33/54692.15) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 40 tps: 154471.14 qps: 154471.14 (r/w/o: 0.00/105899.82/48571.32) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 40 tps: 138149.36 qps: 138149.56 (r/w/o: 0.00/95140.42/43009.14) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 40 tps: 222631.38 qps: 222631.38 (r/w/o: 0.00/153180.90/69450.48) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 38206920 other: 19592409 total: 57799329 transactions: 57799329 (192654.22 per sec.) queries: 57799329 (192654.22 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0138s total number of events: 57799329 Latency (ms): min: 0.05 avg: 0.21 max: 1845.33 99th percentile: 0.40 sum: 11969244.25 Threads fairness: events (avg/stddev): 1444983.2250/101600.68 execution time (avg/stddev): 299.2311/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: 144276.04 qps: 144276.04 (r/w/o: 0.00/91762.01/52514.03) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 80 tps: 173639.02 qps: 173639.02 (r/w/o: 0.00/110299.70/63339.32) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 80 tps: 197943.23 qps: 197943.23 (r/w/o: 0.00/126242.18/71701.05) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 80 tps: 213651.69 qps: 213651.69 (r/w/o: 0.00/135804.50/77847.20) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 80 tps: 166414.82 qps: 166414.82 (r/w/o: 0.00/105956.72/60458.10) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 80 tps: 172305.00 qps: 172305.00 (r/w/o: 0.00/110101.85/62203.15) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 80 tps: 199546.05 qps: 199546.05 (r/w/o: 0.00/127869.21/71676.85) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 80 tps: 202876.95 qps: 202876.95 (r/w/o: 0.00/129743.61/73133.33) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 80 tps: 173707.21 qps: 173707.21 (r/w/o: 0.00/111159.52/62547.69) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 80 tps: 160069.40 qps: 160069.40 (r/w/o: 0.00/103217.35/56852.05) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 80 tps: 205203.70 qps: 205203.70 (r/w/o: 0.00/131899.62/73304.09) lat (ms,99%): 1.50 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 80 tps: 190019.91 qps: 190019.91 (r/w/o: 0.00/121883.27/68136.64) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 80 tps: 176064.92 qps: 176064.92 (r/w/o: 0.00/113736.41/62328.51) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 80 tps: 157170.48 qps: 157170.48 (r/w/o: 0.00/101509.77/55660.71) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 80 tps: 223905.27 qps: 223905.27 (r/w/o: 0.00/145191.62/78713.64) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 80 tps: 192157.95 qps: 192157.95 (r/w/o: 0.00/124680.64/67477.31) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 80 tps: 188189.44 qps: 188189.44 (r/w/o: 0.00/122236.87/65952.58) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 80 tps: 126307.98 qps: 126307.98 (r/w/o: 0.00/82356.15/43951.83) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 80 tps: 216500.34 qps: 216500.34 (r/w/o: 0.00/141008.37/75491.97) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 80 tps: 181620.40 qps: 181620.40 (r/w/o: 0.00/118732.98/62887.42) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 80 tps: 195859.19 qps: 195859.19 (r/w/o: 0.00/128423.30/67435.89) lat (ms,99%): 1.47 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 80 tps: 181207.14 qps: 181207.14 (r/w/o: 0.00/118270.21/62936.93) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 80 tps: 211212.53 qps: 211212.53 (r/w/o: 0.00/138397.30/72815.23) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 80 tps: 123467.31 qps: 123467.31 (r/w/o: 0.00/81073.07/42394.24) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 80 tps: 128899.66 qps: 128899.66 (r/w/o: 0.00/84586.17/44313.49) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 80 tps: 219035.02 qps: 219035.02 (r/w/o: 0.00/143921.41/75113.61) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 80 tps: 158305.42 qps: 158305.42 (r/w/o: 0.00/104218.82/54086.60) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 80 tps: 218102.46 qps: 218102.46 (r/w/o: 0.00/143804.50/74297.96) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 80 tps: 219839.24 qps: 219839.24 (r/w/o: 0.00/144879.07/74960.17) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 80 tps: 216658.32 qps: 216658.32 (r/w/o: 0.00/143069.65/73588.66) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 80 tps: 196277.61 qps: 196277.61 (r/w/o: 0.00/130351.87/65925.74) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 80 tps: 207707.27 qps: 207707.27 (r/w/o: 0.00/137976.05/69731.22) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 80 tps: 161045.33 qps: 161045.33 (r/w/o: 0.00/107215.69/53829.64) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 80 tps: 182469.56 qps: 182469.56 (r/w/o: 0.00/121277.91/61191.66) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 80 tps: 165237.81 qps: 165237.81 (r/w/o: 0.00/110193.39/55044.42) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 80 tps: 238549.50 qps: 238549.50 (r/w/o: 0.00/159082.00/79467.50) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 80 tps: 175472.74 qps: 175472.74 (r/w/o: 0.00/117724.62/57748.12) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 80 tps: 114274.97 qps: 114274.97 (r/w/o: 0.00/76675.77/37599.19) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 80 tps: 201950.58 qps: 201950.58 (r/w/o: 0.00/135507.43/66443.15) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 80 tps: 216024.74 qps: 216024.74 (r/w/o: 0.00/145408.13/70616.62) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 80 tps: 148916.79 qps: 148916.59 (r/w/o: 0.00/100393.73/48522.86) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 80 tps: 218335.14 qps: 218335.34 (r/w/o: 0.00/146614.36/71720.99) lat (ms,99%): 1.47 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 80 tps: 177456.80 qps: 177456.80 (r/w/o: 0.00/119661.54/57795.26) lat (ms,99%): 1.47 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 80 tps: 197017.40 qps: 197017.40 (r/w/o: 0.00/133206.13/63811.26) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 80 tps: 182512.29 qps: 182512.29 (r/w/o: 0.00/123690.12/58822.16) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 80 tps: 225257.53 qps: 225257.53 (r/w/o: 0.00/152806.78/72450.75) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 80 tps: 211504.74 qps: 211504.94 (r/w/o: 0.00/143675.24/67829.70) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 80 tps: 186071.50 qps: 186071.30 (r/w/o: 0.00/126327.51/59743.79) lat (ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 80 tps: 199294.99 qps: 199294.99 (r/w/o: 0.00/135755.41/63539.58) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 80 tps: 178969.11 qps: 178969.11 (r/w/o: 0.00/121989.92/56979.19) lat (ms,99%): 1.55 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 80 tps: 205203.93 qps: 205203.93 (r/w/o: 0.00/139934.75/65269.18) lat (ms,99%): 1.52 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 80 tps: 208832.74 qps: 208832.74 (r/w/o: 0.00/142963.12/65869.62) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 80 tps: 111844.20 qps: 111844.20 (r/w/o: 0.00/76441.82/35402.38) lat (ms,99%): 1.50 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 80 tps: 169697.36 qps: 169697.36 (r/w/o: 0.00/116153.20/53544.15) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 80 tps: 223847.38 qps: 223847.38 (r/w/o: 0.00/153794.29/70053.09) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 80 tps: 148458.92 qps: 148458.92 (r/w/o: 0.00/102069.56/46389.36) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 80 tps: 174352.39 qps: 174352.39 (r/w/o: 0.00/120212.10/54140.29) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 80 tps: 150861.23 qps: 150861.23 (r/w/o: 0.00/103918.93/46942.30) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 80 tps: 230380.64 qps: 230380.64 (r/w/o: 0.00/158748.60/71632.04) lat (ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 80 tps: 161603.23 qps: 161603.23 (r/w/o: 0.00/111386.16/50217.07) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 36786091 other: 18732048 total: 55518139 transactions: 55518139 (185045.10 per sec.) queries: 55518139 (185045.10 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0230s total number of events: 55518139 Latency (ms): min: 0.05 avg: 0.43 max: 2776.37 99th percentile: 1.39 sum: 23964076.01 Threads fairness: events (avg/stddev): 693976.7375/52537.70 execution time (avg/stddev): 299.5510/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: 145471.38 qps: 145471.38 (r/w/o: 0.00/91863.18/53608.20) lat (ms,99%): 3.62 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 160 tps: 192227.90 qps: 192227.90 (r/w/o: 0.00/121797.56/70430.34) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 160 tps: 192393.29 qps: 192393.29 (r/w/o: 0.00/121819.96/70573.33) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 160 tps: 195700.30 qps: 195700.30 (r/w/o: 0.00/124201.74/71498.56) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 160 tps: 191695.05 qps: 191695.05 (r/w/o: 0.00/121594.03/70101.02) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 160 tps: 180062.63 qps: 180062.63 (r/w/o: 0.00/114600.25/65462.37) lat (ms,99%): 2.97 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 160 tps: 177075.44 qps: 177075.44 (r/w/o: 0.00/112796.57/64278.87) lat (ms,99%): 3.49 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 160 tps: 215087.37 qps: 215087.37 (r/w/o: 0.00/137538.17/77549.20) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 160 tps: 176419.76 qps: 176419.76 (r/w/o: 0.00/112647.85/63771.91) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 160 tps: 179726.79 qps: 179726.79 (r/w/o: 0.00/115170.21/64556.58) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 160 tps: 181237.06 qps: 181237.06 (r/w/o: 0.00/116103.42/65133.64) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 160 tps: 214485.89 qps: 214485.89 (r/w/o: 0.00/137883.74/76602.15) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 160 tps: 178173.52 qps: 178173.52 (r/w/o: 0.00/114544.51/63629.02) lat (ms,99%): 3.49 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 160 tps: 211049.69 qps: 211049.49 (r/w/o: 0.00/136208.92/74840.57) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 160 tps: 174364.65 qps: 174364.85 (r/w/o: 0.00/112438.27/61926.58) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 160 tps: 178827.84 qps: 178827.84 (r/w/o: 0.00/115330.62/63497.22) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 160 tps: 153943.14 qps: 153943.14 (r/w/o: 0.00/99411.98/54531.15) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 160 tps: 177341.35 qps: 177341.35 (r/w/o: 0.00/115107.23/62234.13) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 160 tps: 177702.46 qps: 177702.46 (r/w/o: 0.00/115224.57/62477.89) lat (ms,99%): 3.55 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 160 tps: 214907.93 qps: 214907.93 (r/w/o: 0.00/139939.70/74968.24) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 160 tps: 192088.27 qps: 192088.27 (r/w/o: 0.00/125025.52/67062.75) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 160 tps: 185193.37 qps: 185193.37 (r/w/o: 0.00/120421.33/64772.04) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 160 tps: 191552.48 qps: 191552.48 (r/w/o: 0.00/125388.23/66164.25) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 160 tps: 192723.70 qps: 192723.70 (r/w/o: 0.00/125870.48/66853.22) lat (ms,99%): 3.55 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 160 tps: 209034.41 qps: 209034.41 (r/w/o: 0.00/136875.77/72158.65) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 160 tps: 192879.76 qps: 192879.76 (r/w/o: 0.00/126632.88/66246.87) lat (ms,99%): 3.55 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 160 tps: 202411.86 qps: 202411.86 (r/w/o: 0.00/133066.45/69345.42) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 160 tps: 179886.01 qps: 179885.61 (r/w/o: 0.00/118406.51/61479.10) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 160 tps: 181668.45 qps: 181668.85 (r/w/o: 0.00/119901.80/61767.05) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 160 tps: 216156.79 qps: 216156.79 (r/w/o: 0.00/142256.06/73900.73) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 160 tps: 136111.91 qps: 136111.91 (r/w/o: 0.00/90078.21/46033.70) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 160 tps: 177863.76 qps: 177863.56 (r/w/o: 0.00/117831.00/60032.56) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 160 tps: 211260.57 qps: 211260.77 (r/w/o: 0.00/140445.86/70814.91) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 160 tps: 198025.37 qps: 198025.37 (r/w/o: 0.00/131714.48/66310.89) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 160 tps: 198645.21 qps: 198645.21 (r/w/o: 0.00/132446.34/66198.87) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 160 tps: 167738.62 qps: 167738.62 (r/w/o: 0.00/110853.43/56885.19) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 160 tps: 191745.81 qps: 191745.81 (r/w/o: 0.00/127497.07/64248.74) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 160 tps: 211346.17 qps: 211346.17 (r/w/o: 0.00/140686.83/70659.34) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 160 tps: 196864.98 qps: 196864.98 (r/w/o: 0.00/131655.79/65209.19) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 160 tps: 191308.12 qps: 191308.12 (r/w/o: 0.00/128286.14/63021.98) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 160 tps: 211809.69 qps: 211809.69 (r/w/o: 0.00/142355.30/69454.39) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 160 tps: 216951.64 qps: 216951.64 (r/w/o: 0.00/146161.30/70790.34) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 160 tps: 179841.44 qps: 179841.24 (r/w/o: 0.00/120512.63/59328.62) lat (ms,99%): 3.68 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 160 tps: 193841.09 qps: 193841.29 (r/w/o: 0.00/130102.84/63738.45) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 160 tps: 221311.66 qps: 221311.66 (r/w/o: 0.00/149483.46/71828.20) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 160 tps: 231569.54 qps: 231569.54 (r/w/o: 0.00/156959.06/74610.48) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 160 tps: 188807.01 qps: 188807.01 (r/w/o: 0.00/127823.94/60983.07) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 160 tps: 191248.80 qps: 191248.80 (r/w/o: 0.00/129856.16/61392.64) lat (ms,99%): 3.49 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 160 tps: 190455.51 qps: 190455.51 (r/w/o: 0.00/129249.80/61205.70) lat (ms,99%): 3.49 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 160 tps: 179920.96 qps: 179920.96 (r/w/o: 0.00/122296.73/57624.24) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 160 tps: 209212.73 qps: 209212.73 (r/w/o: 0.00/142466.27/66746.46) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 160 tps: 228793.94 qps: 228793.94 (r/w/o: 0.00/156151.65/72642.29) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 160 tps: 183854.69 qps: 183854.69 (r/w/o: 0.00/125695.72/58158.98) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 160 tps: 177103.84 qps: 177103.84 (r/w/o: 0.00/120905.10/56198.74) lat (ms,99%): 3.62 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 160 tps: 211950.94 qps: 211950.74 (r/w/o: 0.00/145607.73/66343.01) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 160 tps: 193189.25 qps: 193189.45 (r/w/o: 0.00/132457.27/60732.18) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 160 tps: 181412.06 qps: 181412.06 (r/w/o: 0.00/124643.37/56768.69) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 160 tps: 202218.66 qps: 202218.66 (r/w/o: 0.00/137951.22/64267.44) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 160 tps: 203378.81 qps: 203378.81 (r/w/o: 0.00/139904.48/63474.33) lat (ms,99%): 3.36 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 160 tps: 185814.99 qps: 185814.99 (r/w/o: 0.00/128131.50/57683.50) lat (ms,99%): 3.25 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 38051980 other: 19524335 total: 57576315 transactions: 57576315 (191886.14 per sec.) queries: 57576315 (191886.14 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0525s total number of events: 57576315 Latency (ms): min: 0.05 avg: 0.83 max: 2257.86 99th percentile: 3.30 sum: 47965708.31 Threads fairness: events (avg/stddev): 359851.9688/24447.00 execution time (avg/stddev): 299.7857/0.01 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'...