C:\benchmark>set mysqld_exe=C:\mariadb-10.3.7-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.3.7-winx64\bin\mysqld.exe 
mysqld_exe=C:\mariadb-10.3.7-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 1128 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.3.7-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.3.7-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:                           464325
        other:                           0
        total:                           464325
    transactions:                        464325 (1547.75 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 464325 (1547.75 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0005s
    total number of events:              464325
    total time taken by event execution: 298.2851
    response time:
         min:                                  0.35ms
         avg:                                  0.64ms
         max:                                123.83ms
         approx.  95 percentile:               0.83ms

Threads fairness:
    events (avg/stddev):           464325.0000/0.00
    execution time (avg/stddev):   298.2851/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:                           662717
        other:                           0
        total:                           662717
    transactions:                        662717 (2209.05 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 662717 (2209.05 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0008s
    total number of events:              662717
    total time taken by event execution: 597.1931
    response time:
         min:                                  0.38ms
         avg:                                  0.90ms
         max:                                205.41ms
         approx.  95 percentile:               1.08ms

Threads fairness:
    events (avg/stddev):           331358.5000/524.50
    execution time (avg/stddev):   298.5966/0.07


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:                           1282939
        other:                           0
        total:                           1282939
    transactions:                        1282939 (4276.46 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1282939 (4276.46 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0005s
    total number of events:              1282939
    total time taken by event execution: 1194.7800
    response time:
         min:                                  0.42ms
         avg:                                  0.93ms
         max:                                150.84ms
         approx.  95 percentile:               1.15ms

Threads fairness:
    events (avg/stddev):           320734.7500/293.35
    execution time (avg/stddev):   298.6950/0.03


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:                           2576283
        other:                           0
        total:                           2576283
    transactions:                        2576283 (8587.59 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 2576283 (8587.59 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0007s
    total number of events:              2576283
    total time taken by event execution: 2390.0930
    response time:
         min:                                  0.46ms
         avg:                                  0.93ms
         max:                                189.00ms
         approx.  95 percentile:               1.19ms

Threads fairness:
    events (avg/stddev):           322035.3750/145.23
    execution time (avg/stddev):   298.7616/0.06


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:                           4715923
        other:                           0
        total:                           4715923
    transactions:                        4715923 (15719.70 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 4715923 (15719.70 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0008s
    total number of events:              4715923
    total time taken by event execution: 4782.9070
    response time:
         min:                                  0.46ms
         avg:                                  1.01ms
         max:                                186.25ms
         approx.  95 percentile:               1.27ms

Threads fairness:
    events (avg/stddev):           294745.1875/253.09
    execution time (avg/stddev):   298.9317/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:                           8244760
        other:                           0
        total:                           8244760
    transactions:                        8244760 (27482.44 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 8244760 (27482.44 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0010s
    total number of events:              8244760
    total time taken by event execution: 9571.1939
    response time:
         min:                                  0.45ms
         avg:                                  1.16ms
         max:                                102.50ms
         approx.  95 percentile:               1.46ms

Threads fairness:
    events (avg/stddev):           257648.7500/204.57
    execution time (avg/stddev):   299.0998/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:                           10453044
        other:                           0
        total:                           10453044
    transactions:                        10453044 (34843.23 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 10453044 (34843.23 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0022s
    total number of events:              10453044
    total time taken by event execution: 19167.0846
    response time:
         min:                                  0.46ms
         avg:                                  1.83ms
         max:                                118.91ms
         approx.  95 percentile:               2.37ms

Threads fairness:
    events (avg/stddev):           163328.8125/86.49
    execution time (avg/stddev):   299.4857/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:                           10551901
        other:                           0
        total:                           10551901
    transactions:                        10551901 (35172.49 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 10551901 (35172.49 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0044s
    total number of events:              10551901
    total time taken by event execution: 38366.3488
    response time:
         min:                                  0.51ms
         avg:                                  3.64ms
         max:                                182.49ms
         approx.  95 percentile:               4.66ms

Threads fairness:
    events (avg/stddev):           82436.7266/184.59
    execution time (avg/stddev):   299.7371/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:                           10769296
        other:                           0
        total:                           10769296
    transactions:                        10769296 (35896.52 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 10769296 (35896.52 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0095s
    total number of events:              10769296
    total time taken by event execution: 76764.4232
    response time:
         min:                                  0.42ms
         avg:                                  7.13ms
         max:                                204.01ms
         approx.  95 percentile:               9.01ms

Threads fairness:
    events (avg/stddev):           42067.5625/65.82
    execution time (avg/stddev):   299.8610/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:                           10970757
        other:                           0
        total:                           10970757
    transactions:                        10970757 (36567.07 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 10970757 (36567.07 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0174s
    total number of events:              10970757
    total time taken by event execution: 153561.5360
    response time:
         min:                                  0.87ms
         avg:                                 14.00ms
         max:                                450.20ms
         approx.  95 percentile:              18.24ms

Threads fairness:
    events (avg/stddev):           21427.2598/44.48
    execution time (avg/stddev):   299.9249/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:                           10899957
        other:                           0
        total:                           10899957
    transactions:                        10899957 (36328.62 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 10899957 (36328.62 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0377s
    total number of events:              10899957
    total time taken by event execution: 307160.3874
    response time:
         min:                                  1.57ms
         avg:                                 28.18ms
         max:                                615.43ms
         approx.  95 percentile:              40.46ms

Threads fairness:
    events (avg/stddev):           10644.4893/35.60
    execution time (avg/stddev):   299.9613/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:                           11309052
        other:                           0
        total:                           11309052
    transactions:                        11309052 (37685.98 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11309052 (37685.98 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0865s
    total number of events:              11309052
    total time taken by event execution: 614345.7298
    response time:
         min:                                  0.88ms
         avg:                                 54.32ms
         max:                               1129.58ms
         approx.  95 percentile:              83.29ms

Threads fairness:
    events (avg/stddev):           5521.9980/26.29
    execution time (avg/stddev):   299.9735/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:                           11715623
        other:                           0
        total:                           11715623
    transactions:                        11715623 (39032.83 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11715623 (39032.83 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.1479s
    total number of events:              11715623
    total time taken by event execution: 1228734.3165
    response time:
         min:                                  1.21ms
         avg:                                104.88ms
         max:                                758.00ms
         approx.  95 percentile:             171.30ms

Threads fairness:
    events (avg/stddev):           2860.2595/17.78
    execution time (avg/stddev):   299.9840/0.08