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'...