Installing MariaDB/MySQL system tables in '/mnt/sbtest' ... 2023-09-27 19:27:24 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: 36590.16 qps: 36590.16 (r/w/o: 0.00/36590.16/0.00) lat (ms,99%): 1.39 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 10 tps: 30230.48 qps: 30230.48 (r/w/o: 0.00/30230.48/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 10 tps: 30068.25 qps: 30068.25 (r/w/o: 0.00/30068.25/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 10 tps: 29991.14 qps: 29991.14 (r/w/o: 0.00/29991.14/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 10 tps: 29922.47 qps: 29922.47 (r/w/o: 0.00/29922.47/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 10 tps: 29286.95 qps: 29286.95 (r/w/o: 0.00/29286.95/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 10 tps: 29954.97 qps: 29954.97 (r/w/o: 0.00/29954.97/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 10 tps: 30038.57 qps: 30038.57 (r/w/o: 0.00/30038.57/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 10 tps: 43001.18 qps: 43001.18 (r/w/o: 0.00/43001.18/0.00) lat (ms,99%): 1.16 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 10 tps: 30128.81 qps: 30128.81 (r/w/o: 0.00/30128.81/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 10 tps: 30769.11 qps: 30769.11 (r/w/o: 0.00/30769.11/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 10 tps: 29661.51 qps: 29661.51 (r/w/o: 0.00/29661.51/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 10 tps: 29955.10 qps: 29955.10 (r/w/o: 0.00/29955.10/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 10 tps: 36388.83 qps: 36388.83 (r/w/o: 0.00/36388.83/0.00) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 10 tps: 29774.72 qps: 29774.72 (r/w/o: 0.00/29774.72/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 10 tps: 30416.31 qps: 30416.31 (r/w/o: 0.00/30416.31/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 10 tps: 29882.79 qps: 29882.79 (r/w/o: 0.00/29882.79/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 10 tps: 30270.42 qps: 30270.42 (r/w/o: 0.00/30270.42/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 10 tps: 29990.22 qps: 29990.22 (r/w/o: 0.00/29990.22/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 10 tps: 30537.74 qps: 30537.74 (r/w/o: 0.00/30537.74/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 10 tps: 30168.92 qps: 30168.92 (r/w/o: 0.00/30168.92/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 10 tps: 30036.41 qps: 30036.41 (r/w/o: 0.00/30036.41/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 10 tps: 30414.91 qps: 30414.91 (r/w/o: 0.00/30414.91/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 10 tps: 30051.51 qps: 30051.51 (r/w/o: 0.00/30051.51/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 10 tps: 29662.32 qps: 29662.32 (r/w/o: 0.00/29662.32/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 10 tps: 29373.85 qps: 29373.85 (r/w/o: 0.00/29373.85/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 10 tps: 29734.87 qps: 29734.87 (r/w/o: 0.00/29734.87/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 10 tps: 29421.87 qps: 29421.87 (r/w/o: 0.00/29421.87/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 10 tps: 29759.21 qps: 29759.21 (r/w/o: 0.00/29759.21/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 10 tps: 30653.99 qps: 30653.99 (r/w/o: 0.00/30653.99/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 10 tps: 30172.29 qps: 30172.29 (r/w/o: 0.00/30172.29/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 10 tps: 29570.32 qps: 29570.32 (r/w/o: 0.00/29570.32/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 10 tps: 29655.10 qps: 29655.10 (r/w/o: 0.00/29655.10/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 10 tps: 30071.49 qps: 30071.49 (r/w/o: 0.00/30071.49/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 10 tps: 29216.05 qps: 29216.05 (r/w/o: 0.00/29216.05/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 10 tps: 29475.09 qps: 29475.09 (r/w/o: 0.00/29475.09/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 10 tps: 29395.81 qps: 29395.81 (r/w/o: 0.00/29395.81/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 10 tps: 29939.50 qps: 29939.50 (r/w/o: 0.00/29939.50/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 10 tps: 29566.56 qps: 29566.56 (r/w/o: 0.00/29566.56/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 10 tps: 30120.73 qps: 30120.73 (r/w/o: 0.00/30120.73/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 10 tps: 29843.87 qps: 29844.07 (r/w/o: 0.00/29844.07/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 10 tps: 30107.67 qps: 30107.47 (r/w/o: 0.00/30107.47/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 10 tps: 30071.11 qps: 30071.11 (r/w/o: 0.00/30071.11/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 10 tps: 29786.51 qps: 29786.51 (r/w/o: 0.00/29786.51/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 10 tps: 29555.77 qps: 29555.77 (r/w/o: 0.00/29555.77/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 10 tps: 30235.88 qps: 30235.88 (r/w/o: 0.00/30235.88/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 10 tps: 29711.70 qps: 29711.70 (r/w/o: 0.00/29711.70/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 10 tps: 29859.62 qps: 29859.62 (r/w/o: 0.00/29859.62/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 10 tps: 29376.09 qps: 29376.09 (r/w/o: 0.00/29376.09/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 10 tps: 30097.23 qps: 30097.23 (r/w/o: 0.00/30097.23/0.00) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 10 tps: 30216.97 qps: 30216.97 (r/w/o: 0.00/30216.97/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 10 tps: 30102.53 qps: 30102.53 (r/w/o: 0.00/30102.53/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 10 tps: 29937.30 qps: 29937.30 (r/w/o: 0.00/29937.30/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 10 tps: 29871.87 qps: 29871.87 (r/w/o: 0.00/29871.87/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 10 tps: 30314.76 qps: 30314.76 (r/w/o: 0.00/30314.76/0.00) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 10 tps: 30309.67 qps: 30309.67 (r/w/o: 0.00/30309.67/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 10 tps: 30681.56 qps: 30681.56 (r/w/o: 0.00/30681.56/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 10 tps: 30510.96 qps: 30510.96 (r/w/o: 0.00/30510.96/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 10 tps: 30070.68 qps: 30070.68 (r/w/o: 0.00/30070.68/0.00) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 10 tps: 29480.96 qps: 29480.96 (r/w/o: 0.00/29480.96/0.00) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 9117483 other: 0 total: 9117483 transactions: 9117483 (30390.47 per sec.) queries: 9117483 (30390.47 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0083s total number of events: 9117483 Latency (ms): min: 0.06 avg: 0.33 max: 9.45 99th percentile: 1.30 sum: 2991565.98 Threads fairness: events (avg/stddev): 911748.3000/4106.87 execution time (avg/stddev): 299.1566/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: 189395.34 qps: 189395.34 (r/w/o: 0.00/84995.52/104399.82) lat (ms,99%): 0.34 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 20 tps: 190943.62 qps: 190943.62 (r/w/o: 0.00/83693.94/107249.68) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 20 tps: 191878.86 qps: 191878.86 (r/w/o: 0.00/84445.58/107433.28) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 20 tps: 191255.82 qps: 191255.82 (r/w/o: 0.00/84193.30/107062.52) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 20 tps: 191705.82 qps: 191705.82 (r/w/o: 0.00/84531.72/107174.10) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 20 tps: 191282.57 qps: 191282.57 (r/w/o: 0.00/84802.41/106480.16) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 20 tps: 192253.97 qps: 192253.97 (r/w/o: 0.00/85695.94/106558.03) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 20 tps: 192191.51 qps: 192191.51 (r/w/o: 0.00/86378.01/105813.50) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 20 tps: 191597.65 qps: 191597.65 (r/w/o: 0.00/86299.52/105298.12) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 20 tps: 191271.14 qps: 191271.14 (r/w/o: 0.00/86089.76/105181.38) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 20 tps: 191350.29 qps: 191350.29 (r/w/o: 0.00/86566.20/104784.09) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 20 tps: 193380.85 qps: 193380.85 (r/w/o: 0.00/88394.96/104985.89) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 20 tps: 192024.63 qps: 192024.63 (r/w/o: 0.00/87868.58/104156.05) lat (ms,99%): 0.36 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 20 tps: 192525.02 qps: 192525.02 (r/w/o: 0.00/88652.53/103872.49) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 20 tps: 191700.15 qps: 191700.15 (r/w/o: 0.00/88281.58/103418.57) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 20 tps: 192042.80 qps: 192042.80 (r/w/o: 0.00/96591.54/95451.26) lat (ms,99%): 0.35 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 20 tps: 190692.03 qps: 190692.03 (r/w/o: 0.00/188376.88/2315.15) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 20 tps: 189932.42 qps: 189932.42 (r/w/o: 0.00/189932.42/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 20 tps: 190198.07 qps: 190198.07 (r/w/o: 0.00/190198.07/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 20 tps: 189587.41 qps: 189587.61 (r/w/o: 0.00/189587.61/0.00) lat (ms,99%): 0.16 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 20 tps: 190855.63 qps: 190855.43 (r/w/o: 0.00/190855.43/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 20 tps: 190612.31 qps: 190612.31 (r/w/o: 0.00/190612.31/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 20 tps: 190197.20 qps: 190197.20 (r/w/o: 0.00/190197.20/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 20 tps: 190497.76 qps: 190497.76 (r/w/o: 0.00/190497.76/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 20 tps: 190472.79 qps: 190472.79 (r/w/o: 0.00/190472.79/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 20 tps: 190302.47 qps: 190302.47 (r/w/o: 0.00/190302.47/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 20 tps: 190165.24 qps: 190165.24 (r/w/o: 0.00/190165.24/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 20 tps: 190430.69 qps: 190430.69 (r/w/o: 0.00/190430.69/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 20 tps: 190399.25 qps: 190399.25 (r/w/o: 0.00/190399.25/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 20 tps: 190068.27 qps: 190068.27 (r/w/o: 0.00/190068.27/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 20 tps: 190422.86 qps: 190422.86 (r/w/o: 0.00/190422.86/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 20 tps: 190589.90 qps: 190589.90 (r/w/o: 0.00/190589.90/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 20 tps: 190695.00 qps: 190695.00 (r/w/o: 0.00/190695.00/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 20 tps: 191331.55 qps: 191331.55 (r/w/o: 0.00/191331.55/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 20 tps: 190703.61 qps: 190703.61 (r/w/o: 0.00/190703.61/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 20 tps: 190395.13 qps: 190395.13 (r/w/o: 0.00/190395.13/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 20 tps: 190283.69 qps: 190283.69 (r/w/o: 0.00/190283.69/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 20 tps: 190886.73 qps: 190886.73 (r/w/o: 0.00/190886.73/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 20 tps: 190543.42 qps: 190543.42 (r/w/o: 0.00/190543.42/0.00) lat (ms,99%): 0.15 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 20 tps: 141876.56 qps: 141876.56 (r/w/o: 0.00/141876.56/0.00) lat (ms,99%): 0.20 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 20 tps: 181470.80 qps: 181470.80 (r/w/o: 0.00/181470.80/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 20 tps: 183297.30 qps: 183297.30 (r/w/o: 0.00/183297.30/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 20 tps: 180560.65 qps: 180560.65 (r/w/o: 0.00/180560.65/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 20 tps: 180646.44 qps: 180646.44 (r/w/o: 0.00/180646.44/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 20 tps: 182757.96 qps: 182757.96 (r/w/o: 0.00/182757.96/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 20 tps: 180322.40 qps: 180322.40 (r/w/o: 0.00/180322.40/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 20 tps: 182650.26 qps: 182650.26 (r/w/o: 0.00/182650.26/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 20 tps: 178147.04 qps: 178147.04 (r/w/o: 0.00/178147.04/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 20 tps: 180597.66 qps: 180597.66 (r/w/o: 0.00/180597.66/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 20 tps: 182647.51 qps: 182647.51 (r/w/o: 0.00/182647.51/0.00) lat (ms,99%): 0.17 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 20 tps: 180918.51 qps: 180918.51 (r/w/o: 0.00/180918.51/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 20 tps: 183036.47 qps: 183036.47 (r/w/o: 0.00/183036.47/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 20 tps: 180079.71 qps: 180079.71 (r/w/o: 0.00/180079.71/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 20 tps: 181291.61 qps: 181291.61 (r/w/o: 0.00/181291.61/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 20 tps: 179492.24 qps: 179492.24 (r/w/o: 0.00/179492.24/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 20 tps: 180708.25 qps: 180708.25 (r/w/o: 0.00/180708.25/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 20 tps: 180678.73 qps: 180678.73 (r/w/o: 0.00/180678.73/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 20 tps: 184129.84 qps: 184129.84 (r/w/o: 0.00/184129.84/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 20 tps: 176261.12 qps: 176261.12 (r/w/o: 0.00/176261.12/0.00) lat (ms,99%): 0.18 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 20 tps: 168407.71 qps: 168407.71 (r/w/o: 0.00/168407.71/0.00) lat (ms,99%): 0.19 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 47577197 other: 8408490 total: 55985687 transactions: 55985687 (186611.64 per sec.) queries: 55985687 (186611.64 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0090s total number of events: 55985687 Latency (ms): min: 0.05 avg: 0.11 max: 717.41 99th percentile: 0.23 sum: 5978571.16 Threads fairness: events (avg/stddev): 2799284.3500/149268.34 execution time (avg/stddev): 298.9286/0.04 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: 235747.14 qps: 235747.14 (r/w/o: 0.00/150864.88/84882.26) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 40 tps: 264524.64 qps: 264524.64 (r/w/o: 0.00/169282.73/95241.91) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 40 tps: 266617.11 qps: 266617.11 (r/w/o: 0.00/170807.20/95809.91) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 40 tps: 264537.20 qps: 264537.20 (r/w/o: 0.00/169983.26/94553.94) lat (ms,99%): 0.37 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 40 tps: 263187.46 qps: 263187.46 (r/w/o: 0.00/169689.08/93498.38) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 40 tps: 265004.59 qps: 265004.59 (r/w/o: 0.00/170569.93/94434.66) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 40 tps: 255305.32 qps: 255305.32 (r/w/o: 0.00/164964.97/90340.35) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 40 tps: 189058.45 qps: 189058.45 (r/w/o: 0.00/122230.68/66827.77) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 40 tps: 230290.30 qps: 230290.30 (r/w/o: 0.00/149237.15/81053.15) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 40 tps: 230759.20 qps: 230759.20 (r/w/o: 0.00/149746.65/81012.55) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 40 tps: 248385.44 qps: 248385.64 (r/w/o: 0.00/161460.67/86924.97) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 40 tps: 246824.99 qps: 246824.99 (r/w/o: 0.00/160844.74/85980.25) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 40 tps: 247223.69 qps: 247223.49 (r/w/o: 0.00/161517.27/85706.22) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 40 tps: 229572.81 qps: 229572.81 (r/w/o: 0.00/150057.42/79515.39) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 40 tps: 246543.49 qps: 246543.69 (r/w/o: 0.00/161416.21/85127.48) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 40 tps: 247031.98 qps: 247031.78 (r/w/o: 0.00/162481.49/84550.30) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 40 tps: 212648.35 qps: 212648.35 (r/w/o: 0.00/139768.51/72879.84) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 40 tps: 113695.81 qps: 113695.81 (r/w/o: 0.00/74444.83/39250.98) lat (ms,99%): 0.44 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 40 tps: 84887.41 qps: 84887.41 (r/w/o: 0.00/54604.04/30283.37) lat (ms,99%): 0.46 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 40 tps: 76529.49 qps: 76529.49 (r/w/o: 0.00/49426.27/27103.21) lat (ms,99%): 0.46 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 40 tps: 77255.25 qps: 77255.25 (r/w/o: 0.00/49928.84/27326.41) lat (ms,99%): 0.45 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 40 tps: 95391.78 qps: 95391.78 (r/w/o: 0.00/61985.89/33405.89) lat (ms,99%): 0.44 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 40 tps: 75612.94 qps: 75612.94 (r/w/o: 0.00/49130.20/26482.74) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 40 tps: 91387.63 qps: 91387.63 (r/w/o: 0.00/59748.62/31639.01) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 40 tps: 81771.34 qps: 81771.34 (r/w/o: 0.00/53412.85/28358.50) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 40 tps: 75917.41 qps: 75917.41 (r/w/o: 0.00/49445.41/26472.01) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 40 tps: 103150.00 qps: 103150.00 (r/w/o: 0.00/67300.43/35849.57) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 40 tps: 66712.88 qps: 66712.88 (r/w/o: 0.00/43761.09/22951.79) lat (ms,99%): 0.44 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 40 tps: 97834.18 qps: 97834.18 (r/w/o: 0.00/64109.92/33724.26) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 40 tps: 84446.40 qps: 84446.40 (r/w/o: 0.00/55301.83/29144.56) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 40 tps: 75346.97 qps: 75346.97 (r/w/o: 0.00/49428.50/25918.47) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 40 tps: 101110.05 qps: 101110.05 (r/w/o: 0.00/66354.38/34755.67) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 40 tps: 67211.38 qps: 67211.38 (r/w/o: 0.00/44070.30/23141.08) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 40 tps: 92737.87 qps: 92737.87 (r/w/o: 0.00/60641.92/32095.95) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 40 tps: 75294.01 qps: 75294.01 (r/w/o: 0.00/49477.33/25816.69) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 40 tps: 80912.65 qps: 80912.65 (r/w/o: 0.00/53203.19/27709.46) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 40 tps: 83358.67 qps: 83358.67 (r/w/o: 0.00/54967.70/28390.96) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 40 tps: 69961.99 qps: 69961.99 (r/w/o: 0.00/46029.95/23932.04) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 40 tps: 93529.67 qps: 93529.67 (r/w/o: 0.00/61602.47/31927.19) lat (ms,99%): 0.43 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 40 tps: 120806.80 qps: 120806.80 (r/w/o: 0.00/79824.53/40982.26) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 40 tps: 170304.45 qps: 170304.45 (r/w/o: 0.00/112522.33/57782.13) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 40 tps: 144855.22 qps: 144855.22 (r/w/o: 0.00/95667.97/49187.25) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 40 tps: 215317.18 qps: 215317.38 (r/w/o: 0.00/143258.34/72059.04) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 40 tps: 161060.22 qps: 161060.22 (r/w/o: 0.00/107130.74/53929.48) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 40 tps: 126742.74 qps: 126742.54 (r/w/o: 0.00/84761.87/41980.66) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 40 tps: 215384.01 qps: 215384.01 (r/w/o: 0.00/143253.85/72130.16) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 40 tps: 136574.53 qps: 136574.53 (r/w/o: 0.00/90533.49/46041.05) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 40 tps: 129229.39 qps: 129229.39 (r/w/o: 0.00/85867.10/43362.29) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 40 tps: 235169.02 qps: 235169.02 (r/w/o: 0.00/157238.32/77930.70) lat (ms,99%): 0.38 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 40 tps: 139887.74 qps: 139887.94 (r/w/o: 0.00/93492.36/46395.58) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 40 tps: 130620.02 qps: 130619.82 (r/w/o: 0.00/87228.62/43391.20) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 40 tps: 218430.42 qps: 218430.42 (r/w/o: 0.00/146651.76/71778.66) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 40 tps: 171545.02 qps: 171545.02 (r/w/o: 0.00/115418.41/56126.61) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 40 tps: 199368.22 qps: 199368.22 (r/w/o: 0.00/134279.87/65088.35) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 40 tps: 134805.74 qps: 134805.74 (r/w/o: 0.00/90643.93/44161.81) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 40 tps: 207935.96 qps: 207935.96 (r/w/o: 0.00/140529.21/67406.74) lat (ms,99%): 0.40 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 40 tps: 157940.82 qps: 157940.82 (r/w/o: 0.00/106853.32/51087.50) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 40 tps: 114810.81 qps: 114810.81 (r/w/o: 0.00/78280.97/36529.84) lat (ms,99%): 0.42 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 40 tps: 200620.62 qps: 200620.62 (r/w/o: 0.00/136873.31/63747.31) lat (ms,99%): 0.39 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 40 tps: 142788.38 qps: 142788.38 (r/w/o: 0.00/97205.36/45583.02) lat (ms,99%): 0.41 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 31154686 other: 16253832 total: 47408518 transactions: 47408518 (158020.22 per sec.) queries: 47408518 (158020.22 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0135s total number of events: 47408518 Latency (ms): min: 0.05 avg: 0.25 max: 2646.58 99th percentile: 0.39 sum: 11972341.08 Threads fairness: events (avg/stddev): 1185212.9500/76006.38 execution time (avg/stddev): 299.3085/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: 150493.40 qps: 150493.40 (r/w/o: 0.00/91939.54/58553.87) lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 80 tps: 209400.15 qps: 209400.15 (r/w/o: 0.00/127648.32/81751.83) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 80 tps: 199034.12 qps: 199034.12 (r/w/o: 0.00/121370.26/77663.86) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 80 tps: 157220.99 qps: 157220.99 (r/w/o: 0.00/96167.64/61053.36) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 80 tps: 169221.35 qps: 169221.35 (r/w/o: 0.00/103597.08/65624.27) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 80 tps: 203134.54 qps: 203134.54 (r/w/o: 0.00/124291.61/78842.93) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 80 tps: 140460.57 qps: 140460.57 (r/w/o: 0.00/86124.44/54336.13) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 80 tps: 181867.43 qps: 181867.43 (r/w/o: 0.00/111523.56/70343.88) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 80 tps: 170966.32 qps: 170966.32 (r/w/o: 0.00/105608.68/65357.64) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 80 tps: 134852.91 qps: 134853.11 (r/w/o: 0.00/83245.75/51607.36) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 80 tps: 215600.45 qps: 215600.25 (r/w/o: 0.00/133196.21/82404.03) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 80 tps: 132257.35 qps: 132257.35 (r/w/o: 0.00/81936.65/50320.70) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 80 tps: 137870.46 qps: 137870.46 (r/w/o: 0.00/85533.46/52336.99) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 80 tps: 221926.84 qps: 221926.84 (r/w/o: 0.00/137987.47/83939.36) lat (ms,99%): 1.18 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 80 tps: 131443.79 qps: 131443.79 (r/w/o: 0.00/81120.65/50323.14) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 80 tps: 153010.96 qps: 153010.96 (r/w/o: 0.00/95309.45/57701.51) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 80 tps: 196150.16 qps: 196150.16 (r/w/o: 0.00/122274.21/73875.95) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 80 tps: 121575.90 qps: 121575.90 (r/w/o: 0.00/75992.11/45583.79) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 80 tps: 196163.27 qps: 196163.27 (r/w/o: 0.00/122925.59/73237.67) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 80 tps: 132561.72 qps: 132561.72 (r/w/o: 0.00/83376.90/49184.82) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 80 tps: 120373.13 qps: 120373.13 (r/w/o: 0.00/75541.41/44831.71) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 80 tps: 221378.91 qps: 221379.11 (r/w/o: 0.00/139033.00/82346.12) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 80 tps: 112092.24 qps: 112092.24 (r/w/o: 0.00/70556.33/41535.91) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 80 tps: 173043.15 qps: 173042.95 (r/w/o: 0.00/108941.67/64101.28) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 80 tps: 156304.63 qps: 156304.63 (r/w/o: 0.00/98663.06/57641.57) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 80 tps: 105944.75 qps: 105944.75 (r/w/o: 0.00/66815.90/39128.85) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 80 tps: 239532.09 qps: 239532.09 (r/w/o: 0.00/151760.19/87771.90) lat (ms,99%): 1.18 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 80 tps: 117336.73 qps: 117336.73 (r/w/o: 0.00/74060.98/43275.74) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 80 tps: 151389.37 qps: 151389.37 (r/w/o: 0.00/96330.98/55058.39) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 80 tps: 183435.45 qps: 183435.45 (r/w/o: 0.00/116765.61/66669.84) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 80 tps: 90101.54 qps: 90101.54 (r/w/o: 0.00/57504.01/32597.53) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 80 tps: 229526.02 qps: 229526.02 (r/w/o: 0.00/146137.87/83388.15) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 80 tps: 111866.96 qps: 111866.96 (r/w/o: 0.00/71354.62/40512.34) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 80 tps: 138903.22 qps: 138903.22 (r/w/o: 0.00/88424.76/50478.46) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 80 tps: 191518.40 qps: 191518.40 (r/w/o: 0.00/122504.69/69013.72) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 80 tps: 92040.69 qps: 92040.69 (r/w/o: 0.00/59200.44/32840.25) lat (ms,99%): 1.18 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 80 tps: 218757.39 qps: 218757.39 (r/w/o: 0.00/140408.82/78348.57) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 80 tps: 163799.17 qps: 163799.17 (r/w/o: 0.00/104158.31/59640.86) lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 80 tps: 152214.43 qps: 152214.43 (r/w/o: 0.00/98095.67/54118.76) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 80 tps: 183154.04 qps: 183154.04 (r/w/o: 0.00/118085.93/65068.11) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 80 tps: 141241.63 qps: 141241.63 (r/w/o: 0.00/91230.28/50011.35) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 80 tps: 104421.22 qps: 104421.22 (r/w/o: 0.00/67387.03/37034.19) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 80 tps: 212502.55 qps: 212502.55 (r/w/o: 0.00/137546.80/74955.74) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 80 tps: 128607.35 qps: 128607.35 (r/w/o: 0.00/83531.56/45075.79) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 80 tps: 157605.87 qps: 157605.87 (r/w/o: 0.00/102151.15/55454.72) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 80 tps: 151152.69 qps: 151152.69 (r/w/o: 0.00/98079.60/53073.09) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 80 tps: 102071.20 qps: 102071.20 (r/w/o: 0.00/66453.58/35617.63) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 80 tps: 219801.44 qps: 219801.44 (r/w/o: 0.00/143278.30/76523.14) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 80 tps: 111773.49 qps: 111773.49 (r/w/o: 0.00/72577.00/39196.49) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 80 tps: 160210.28 qps: 160210.28 (r/w/o: 0.00/104616.35/55593.93) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 80 tps: 163073.35 qps: 163073.35 (r/w/o: 0.00/106785.63/56287.73) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 80 tps: 95902.35 qps: 95902.35 (r/w/o: 0.00/62610.65/33291.70) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 80 tps: 228774.97 qps: 228774.97 (r/w/o: 0.00/149975.74/78799.24) lat (ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 80 tps: 104319.49 qps: 104319.49 (r/w/o: 0.00/68486.93/35832.56) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 80 tps: 144777.76 qps: 144777.76 (r/w/o: 0.00/94914.70/49863.06) lat (ms,99%): 1.30 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 80 tps: 196547.31 qps: 196547.31 (r/w/o: 0.00/129295.87/67251.44) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 80 tps: 110386.57 qps: 110386.37 (r/w/o: 0.00/72513.57/37872.79) lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 80 tps: 176373.50 qps: 176373.70 (r/w/o: 0.00/116685.73/59687.97) lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 80 tps: 141117.71 qps: 141117.71 (r/w/o: 0.00/93345.81/47771.91) lat (ms,99%): 1.27 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 80 tps: 122399.06 qps: 122399.06 (r/w/o: 0.00/80992.24/41406.82) lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 30090417 other: 17315392 total: 47405809 transactions: 47405809 (158004.07 per sec.) queries: 47405809 (158004.07 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0268s total number of events: 47405809 Latency (ms): min: 0.05 avg: 0.51 max: 2981.90 99th percentile: 1.25 sum: 23973361.20 Threads fairness: events (avg/stddev): 592572.6125/44090.27 execution time (avg/stddev): 299.6670/0.02 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: 202943.99 qps: 202943.79 (r/w/o: 0.00/124343.55/78600.23) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 160 tps: 108063.20 qps: 108063.40 (r/w/o: 0.00/66107.75/41955.66) lat (ms,99%): 2.81 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 160 tps: 213606.72 qps: 213606.72 (r/w/o: 0.00/130538.40/83068.32) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 160 tps: 199513.82 qps: 199513.82 (r/w/o: 0.00/122830.47/76683.35) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 160 tps: 110179.29 qps: 110179.29 (r/w/o: 0.00/67687.83/42491.47) lat (ms,99%): 2.76 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 160 tps: 187479.04 qps: 187479.04 (r/w/o: 0.00/115042.85/72436.19) lat (ms,99%): 2.81 err/s: 0.00 reconn/s: 0.00 [ 35s ] thds: 160 tps: 193709.67 qps: 193709.67 (r/w/o: 0.00/119409.56/74300.11) lat (ms,99%): 2.86 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 160 tps: 151101.11 qps: 151100.91 (r/w/o: 0.00/93587.64/57513.27) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 45s ] thds: 160 tps: 185328.45 qps: 185328.65 (r/w/o: 0.00/114413.57/70915.09) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 160 tps: 217201.06 qps: 217201.06 (r/w/o: 0.00/134651.06/82550.00) lat (ms,99%): 2.61 err/s: 0.00 reconn/s: 0.00 [ 55s ] thds: 160 tps: 134043.12 qps: 134042.92 (r/w/o: 0.00/82944.90/51098.02) lat (ms,99%): 2.91 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 160 tps: 134087.44 qps: 134087.64 (r/w/o: 0.00/83102.28/50985.36) lat (ms,99%): 2.91 err/s: 0.00 reconn/s: 0.00 [ 65s ] thds: 160 tps: 177276.91 qps: 177276.91 (r/w/o: 0.00/110404.32/66872.59) lat (ms,99%): 2.91 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 160 tps: 163321.91 qps: 163321.91 (r/w/o: 0.00/101981.23/61340.68) lat (ms,99%): 2.71 err/s: 0.00 reconn/s: 0.00 [ 75s ] thds: 160 tps: 160708.25 qps: 160708.25 (r/w/o: 0.00/100112.56/60595.69) lat (ms,99%): 2.86 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 160 tps: 214649.46 qps: 214649.46 (r/w/o: 0.00/134704.11/79945.36) lat (ms,99%): 2.81 err/s: 0.00 reconn/s: 0.00 [ 85s ] thds: 160 tps: 111217.55 qps: 111217.55 (r/w/o: 0.00/69651.82/41565.73) lat (ms,99%): 2.91 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 160 tps: 191868.20 qps: 191868.20 (r/w/o: 0.00/120383.31/71484.88) lat (ms,99%): 2.71 err/s: 0.00 reconn/s: 0.00 [ 95s ] thds: 160 tps: 136202.72 qps: 136202.72 (r/w/o: 0.00/85716.81/50485.91) lat (ms,99%): 2.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 160 tps: 129014.09 qps: 129014.09 (r/w/o: 0.00/79848.25/49165.84) lat (ms,99%): 2.71 err/s: 0.00 reconn/s: 0.00 [ 105s ] thds: 160 tps: 198451.81 qps: 198451.81 (r/w/o: 0.00/124923.12/73528.69) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 160 tps: 146125.56 qps: 146125.56 (r/w/o: 0.00/92325.92/53799.64) lat (ms,99%): 2.71 err/s: 0.00 reconn/s: 0.00 [ 115s ] thds: 160 tps: 189156.12 qps: 189156.12 (r/w/o: 0.00/119313.56/69842.56) lat (ms,99%): 2.97 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 160 tps: 209495.89 qps: 209495.89 (r/w/o: 0.00/132404.44/77091.45) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 125s ] thds: 160 tps: 107217.72 qps: 107217.72 (r/w/o: 0.00/67948.92/39268.80) lat (ms,99%): 2.71 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 160 tps: 150452.58 qps: 150452.58 (r/w/o: 0.00/95489.89/54962.69) lat (ms,99%): 2.81 err/s: 0.00 reconn/s: 0.00 [ 135s ] thds: 160 tps: 204198.45 qps: 204198.25 (r/w/o: 0.00/129897.54/74300.71) lat (ms,99%): 3.13 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 160 tps: 141710.29 qps: 141710.49 (r/w/o: 0.00/90152.40/51558.09) lat (ms,99%): 2.66 err/s: 0.00 reconn/s: 0.00 [ 145s ] thds: 160 tps: 155413.88 qps: 155413.88 (r/w/o: 0.00/98765.07/56648.81) lat (ms,99%): 2.86 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 160 tps: 188739.96 qps: 188739.96 (r/w/o: 0.00/120367.61/68372.34) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 155s ] thds: 160 tps: 159998.54 qps: 159998.34 (r/w/o: 0.00/100994.64/59003.69) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 160 tps: 161685.87 qps: 161686.07 (r/w/o: 0.00/103405.71/58280.36) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 165s ] thds: 160 tps: 193879.77 qps: 193879.57 (r/w/o: 0.00/124147.38/69732.19) lat (ms,99%): 3.13 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 160 tps: 148097.53 qps: 148097.73 (r/w/o: 0.00/94583.68/53514.05) lat (ms,99%): 3.43 err/s: 0.00 reconn/s: 0.00 [ 175s ] thds: 160 tps: 148328.37 qps: 148328.37 (r/w/o: 0.00/95370.39/52957.98) lat (ms,99%): 2.91 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 160 tps: 204794.22 qps: 204794.22 (r/w/o: 0.00/130548.36/74245.86) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 185s ] thds: 160 tps: 113854.78 qps: 113854.58 (r/w/o: 0.00/73283.39/40571.19) lat (ms,99%): 2.86 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 160 tps: 192174.05 qps: 192174.25 (r/w/o: 0.00/122793.24/69381.01) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 195s ] thds: 160 tps: 161848.76 qps: 161848.76 (r/w/o: 0.00/103672.00/58176.76) lat (ms,99%): 3.13 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 160 tps: 110950.24 qps: 110950.44 (r/w/o: 0.00/71620.59/39329.86) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 205s ] thds: 160 tps: 221888.07 qps: 221887.87 (r/w/o: 0.00/143559.01/78328.85) lat (ms,99%): 2.76 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 160 tps: 116240.49 qps: 116240.49 (r/w/o: 0.00/75468.09/40772.41) lat (ms,99%): 2.86 err/s: 0.00 reconn/s: 0.00 [ 215s ] thds: 160 tps: 131362.71 qps: 131362.71 (r/w/o: 0.00/85181.64/46181.06) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 160 tps: 207752.04 qps: 207752.04 (r/w/o: 0.00/135120.35/72631.69) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 225s ] thds: 160 tps: 146681.73 qps: 146681.73 (r/w/o: 0.00/93928.40/52753.34) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 160 tps: 151116.76 qps: 151116.96 (r/w/o: 0.00/98330.31/52786.66) lat (ms,99%): 2.91 err/s: 0.00 reconn/s: 0.00 [ 235s ] thds: 160 tps: 207714.69 qps: 207714.49 (r/w/o: 0.00/134068.91/73645.57) lat (ms,99%): 3.13 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 160 tps: 178950.82 qps: 178950.82 (r/w/o: 0.00/116868.48/62082.34) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 245s ] thds: 160 tps: 157089.24 qps: 157089.04 (r/w/o: 0.00/102545.30/54543.75) lat (ms,99%): 3.55 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 160 tps: 177563.41 qps: 177563.61 (r/w/o: 0.00/115637.01/61926.60) lat (ms,99%): 3.07 err/s: 0.00 reconn/s: 0.00 [ 255s ] thds: 160 tps: 186514.95 qps: 186514.95 (r/w/o: 0.00/121742.86/64772.09) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 160 tps: 118572.22 qps: 118572.22 (r/w/o: 0.00/77322.60/41249.62) lat (ms,99%): 3.68 err/s: 0.00 reconn/s: 0.00 [ 265s ] thds: 160 tps: 184651.75 qps: 184651.75 (r/w/o: 0.00/121684.64/62967.11) lat (ms,99%): 2.81 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 160 tps: 180211.77 qps: 180211.77 (r/w/o: 0.00/118554.57/61657.20) lat (ms,99%): 2.97 err/s: 0.00 reconn/s: 0.00 [ 275s ] thds: 160 tps: 144321.01 qps: 144321.01 (r/w/o: 0.00/95076.67/49244.33) lat (ms,99%): 3.13 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 160 tps: 160915.22 qps: 160915.22 (r/w/o: 0.00/106249.79/54665.42) lat (ms,99%): 3.02 err/s: 0.00 reconn/s: 0.00 [ 285s ] thds: 160 tps: 178035.06 qps: 178035.06 (r/w/o: 0.00/117952.41/60082.65) lat (ms,99%): 3.13 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 160 tps: 162549.83 qps: 162549.83 (r/w/o: 0.00/107368.89/55180.93) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 [ 295s ] thds: 160 tps: 144718.99 qps: 144718.99 (r/w/o: 0.00/95977.82/48741.17) lat (ms,99%): 3.19 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 160 tps: 197974.77 qps: 197974.77 (r/w/o: 0.00/131442.90/66531.87) lat (ms,99%): 3.30 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 31718163 other: 18097058 total: 49815221 transactions: 49815221 (166016.55 per sec.) queries: 49815221 (166016.55 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0597s total number of events: 49815221 Latency (ms): min: 0.05 avg: 0.96 max: 2818.55 99th percentile: 2.97 sum: 47969315.92 Threads fairness: events (avg/stddev): 311345.1312/22318.46 execution time (avg/stddev): 299.8082/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'...