C:\benchmark>set mysqld_exe=C:\mariadb-10.2.14-winx64\bin\mysqld.exe 

C:\benchmark>set datadir=D:\data 

C:\benchmark>set test=update_no_index.huge.bat 

C:\benchmark>set extra_mysqld_param= 

C:\benchmark>echo mysqld_exe=C:\mariadb-10.2.14-winx64\bin\mysqld.exe 
mysqld_exe=C:\mariadb-10.2.14-winx64\bin\mysqld.exe

C:\benchmark>echo datadir=D:\data 
datadir=D:\data

C:\benchmark>echo test=update_no_index.huge.bat 
test=update_no_index.huge.bat

C:\benchmark>taskkill /im mysqld.exe /f 
SUCCESS: The process "mysqld.exe" with PID 4504 has been terminated.

C:\benchmark>rd /s /q  D:\data 

C:\benchmark>timeout 1 

Waiting for 1 seconds, press a key to continue ...0

C:\benchmark>mkdir D:\data 

C:\benchmark>timeout 1 

Waiting for 1 seconds, press a key to continue ...0

C:\benchmark>C:\mariadb-10.2.14-winx64\bin\mysql_install_db --datadir=D:\data 
Running bootstrap
Removing default user
Creating my.ini file
Creation of the database was successfull
C:\benchmark>start /b C:\mariadb-10.2.14-winx64\bin\mysqld.exe --defaults-file=C:\benchmark\\sysbench.ini.huge --datadir=D:\data   

C:\benchmark>timeout 60  1>NUL 

C:\benchmark>mysql --defaults-file=C:\benchmark\\sysbench.ini -uroot -e "create database sbtest" 

C:\benchmark>call update_no_index.huge.bat prepare 1 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=1 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL prepare 
sysbench 0.4:  multi-threaded system evaluation benchmark

Creating table 'sbtest'...
Creating 50000000 records in table 'sbtest'...

C:\benchmark>rem FOR %A IN (1) DO ( 

C:\benchmark>FOR %A IN (1 2 4 8 16 32 64 128 256 512 1024 2048 4096) DO (
call update_no_index.huge.bat run %A  
 timeout  80  1>NUL 
) 

C:\benchmark>(
call update_no_index.huge.bat run 1  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=1 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           464976
        other:                           0
        total:                           464976
    transactions:                        464976 (1549.92 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 464976 (1549.92 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0007s
    total number of events:              464976
    total time taken by event execution: 298.2506
    response time:
         min:                                  0.35ms
         avg:                                  0.64ms
         max:                                 22.28ms
         approx.  95 percentile:               0.79ms

Threads fairness:
    events (avg/stddev):           464976.0000/0.00
    execution time (avg/stddev):   298.2506/0.00


C:\benchmark>(
call update_no_index.huge.bat run 2  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=2 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 2
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 1 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           712169
        other:                           0
        total:                           712169
    transactions:                        712169 (2373.89 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 712169 (2373.89 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0008s
    total number of events:              712169
    total time taken by event execution: 597.2124
    response time:
         min:                                  0.40ms
         avg:                                  0.84ms
         max:                                 29.78ms
         approx.  95 percentile:               1.02ms

Threads fairness:
    events (avg/stddev):           356084.5000/6.50
    execution time (avg/stddev):   298.6062/0.03


C:\benchmark>(
call update_no_index.huge.bat run 4  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=4 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 4
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 3 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           1339817
        other:                           0
        total:                           1339817
    transactions:                        1339817 (4466.03 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1339817 (4466.03 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0018s
    total number of events:              1339817
    total time taken by event execution: 1194.3551
    response time:
         min:                                  0.40ms
         avg:                                  0.89ms
         max:                                 34.78ms
         approx.  95 percentile:               1.14ms

Threads fairness:
    events (avg/stddev):           334954.2500/310.76
    execution time (avg/stddev):   298.5888/0.11


C:\benchmark>(
call update_no_index.huge.bat run 8  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=8 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 8
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 7 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           2720954
        other:                           0
        total:                           2720954
    transactions:                        2720954 (9069.82 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 2720954 (9069.82 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0010s
    total number of events:              2720954
    total time taken by event execution: 2389.7847
    response time:
         min:                                  0.41ms
         avg:                                  0.88ms
         max:                                 56.23ms
         approx.  95 percentile:               1.17ms

Threads fairness:
    events (avg/stddev):           340119.2500/298.45
    execution time (avg/stddev):   298.7231/0.20


C:\benchmark>(
call update_no_index.huge.bat run 16  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=16 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 16
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 15 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           4989450
        other:                           0
        total:                           4989450
    transactions:                        4989450 (16631.45 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 4989450 (16631.45 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0010s
    total number of events:              4989450
    total time taken by event execution: 4782.0840
    response time:
         min:                                  0.44ms
         avg:                                  0.96ms
         max:                                 39.98ms
         approx.  95 percentile:               1.23ms

Threads fairness:
    events (avg/stddev):           311840.6250/284.66
    execution time (avg/stddev):   298.8802/0.02


C:\benchmark>(
call update_no_index.huge.bat run 32  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=32 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 32
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 31 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           8696994
        other:                           0
        total:                           8696994
    transactions:                        8696994 (28989.79 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 8696994 (28989.79 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0020s
    total number of events:              8696994
    total time taken by event execution: 9569.9665
    response time:
         min:                                  0.47ms
         avg:                                  1.10ms
         max:                                139.49ms
         approx.  95 percentile:               1.42ms

Threads fairness:
    events (avg/stddev):           271781.0625/198.78
    execution time (avg/stddev):   299.0615/0.02


C:\benchmark>(
call update_no_index.huge.bat run 64  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=64 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 64
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 63 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           11098931
        other:                           0
        total:                           11098931
    transactions:                        11098931 (36996.12 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11098931 (36996.12 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0026s
    total number of events:              11098931
    total time taken by event execution: 19165.2776
    response time:
         min:                                  0.45ms
         avg:                                  1.73ms
         max:                                 57.02ms
         approx.  95 percentile:               2.29ms

Threads fairness:
    events (avg/stddev):           173420.7969/104.07
    execution time (avg/stddev):   299.4575/0.01


C:\benchmark>(
call update_no_index.huge.bat run 128  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=128 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 128
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 127 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           11186300
        other:                           0
        total:                           11186300
    transactions:                        11186300 (37287.05 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11186300 (37287.05 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0050s
    total number of events:              11186300
    total time taken by event execution: 38365.1241
    response time:
         min:                                  0.46ms
         avg:                                  3.43ms
         max:                                381.74ms
         approx.  95 percentile:               4.46ms

Threads fairness:
    events (avg/stddev):           87392.9688/109.56
    execution time (avg/stddev):   299.7275/0.01


C:\benchmark>(
call update_no_index.huge.bat run 256  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=256 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 256
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 255 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           11411751
        other:                           0
        total:                           11411751
    transactions:                        11411751 (38038.01 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11411751 (38038.01 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0091s
    total number of events:              11411751
    total time taken by event execution: 76763.4599
    response time:
         min:                                  0.93ms
         avg:                                  6.73ms
         max:                                 96.39ms
         approx.  95 percentile:               8.78ms

Threads fairness:
    events (avg/stddev):           44577.1523/80.17
    execution time (avg/stddev):   299.8573/0.01


C:\benchmark>(
call update_no_index.huge.bat run 512  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=512 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 512
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 511 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           11508916
        other:                           0
        total:                           11508916
    transactions:                        11508916 (38360.71 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11508916 (38360.71 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0183s
    total number of events:              11508916
    total time taken by event execution: 153560.3995
    response time:
         min:                                  1.61ms
         avg:                                 13.34ms
         max:                                126.49ms
         approx.  95 percentile:              17.82ms

Threads fairness:
    events (avg/stddev):           22478.3516/50.19
    execution time (avg/stddev):   299.9227/0.01


C:\benchmark>(
call update_no_index.huge.bat run 1024  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=1024 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1024
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 1023 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           11480999
        other:                           0
        total:                           11480999
    transactions:                        11480999 (38265.25 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11480999 (38265.25 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0372s
    total number of events:              11480999
    total time taken by event execution: 307157.6764
    response time:
         min:                                  0.77ms
         avg:                                 26.75ms
         max:                                150.97ms
         approx.  95 percentile:              40.16ms

Threads fairness:
    events (avg/stddev):           11211.9131/36.75
    execution time (avg/stddev):   299.9587/0.02


C:\benchmark>(
call update_no_index.huge.bat run 2048  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=2048 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 2048
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 2047 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           12000772
        other:                           0
        total:                           12000772
    transactions:                        12000772 (39990.85 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 12000772 (39990.85 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0879s
    total number of events:              12000772
    total time taken by event execution: 614334.0629
    response time:
         min:                                  3.35ms
         avg:                                 51.19ms
         max:                                234.54ms
         approx.  95 percentile:              81.17ms

Threads fairness:
    events (avg/stddev):           5859.7520/27.19
    execution time (avg/stddev):   299.9678/0.05


C:\benchmark>(
call update_no_index.huge.bat run 4096  
 timeout  80  1>NUL 
) 

C:\benchmark>sysbench --test=oltp --oltp-table-size=50000000 --mysql-host=localhost --mysql-db=sbtest --mysql-user=root --mysql-password= --db-driver=mysql --mysql-table-engine=innodb --max-time=300 --oltp-test-mode=complex --oltp-read-only=off --max-requests=0 --num-threads=4096 --oltp-point-selects=0 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=0 --oltp-delete-inserts=0 --oltp-non-index-updates=1  --oltp-skip-trx=on --oltp-dist-type=uniform --mysql-socket=MySQL run 
sysbench 0.4:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 4096
Random number generator seed is 0 and will be ignored


Doing OLTP test.
Running mixed OLTP test
Using Uniform distribution
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 4095 times)
Done.

OLTP test statistics:
    queries performed:
        read:                            0
        write:                           12602776
        other:                           0
        total:                           12602776
    transactions:                        12602776 (41988.71 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 12602776 (41988.71 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.1468s
    total number of events:              12602776
    total time taken by event execution: 1228700.2811
    response time:
         min:                                  1.03ms
         avg:                                 97.49ms
         max:                                310.52ms
         approx.  95 percentile:             165.80ms

Threads fairness:
    events (avg/stddev):           3076.8496/18.37
    execution time (avg/stddev):   299.9757/0.08