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