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