C:\benchmark>set mysqld_exe=D:\10.3.pre-lockless\xxx\sql\RelWithDebInfo\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=D:\10.3.pre-lockless\xxx\sql\RelWithDebInfo\mysqld.exe 
mysqld_exe=D:\10.3.pre-lockless\xxx\sql\RelWithDebInfo\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 

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>D:\10.3.pre-lockless\xxx\sql\RelWithDebInfo\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 D:\10.3.pre-lockless\xxx\sql\RelWithDebInfo\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:                           465322
        other:                           0
        total:                           465322
    transactions:                        465322 (1551.07 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 465322 (1551.07 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0005s
    total number of events:              465322
    total time taken by event execution: 298.1904
    response time:
         min:                                  0.38ms
         avg:                                  0.64ms
         max:                                 31.22ms
         approx.  95 percentile:               0.85ms

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

General statistics:
    total time:                          300.0006s
    total number of events:              700440
    total time taken by event execution: 597.2737
    response time:
         min:                                  0.42ms
         avg:                                  0.85ms
         max:                                 24.05ms
         approx.  95 percentile:               1.04ms

Threads fairness:
    events (avg/stddev):           350220.0000/105.00
    execution time (avg/stddev):   298.6369/0.09


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

General statistics:
    total time:                          300.0005s
    total number of events:              1333993
    total time taken by event execution: 1194.3424
    response time:
         min:                                  0.44ms
         avg:                                  0.90ms
         max:                                 30.11ms
         approx.  95 percentile:               1.12ms

Threads fairness:
    events (avg/stddev):           333498.2500/115.71
    execution time (avg/stddev):   298.5856/0.02


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

General statistics:
    total time:                          300.0008s
    total number of events:              2729691
    total time taken by event execution: 2389.5488
    response time:
         min:                                  0.45ms
         avg:                                  0.88ms
         max:                                 44.48ms
         approx.  95 percentile:               1.12ms

Threads fairness:
    events (avg/stddev):           341211.3750/140.07
    execution time (avg/stddev):   298.6936/0.04


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

General statistics:
    total time:                          300.0010s
    total number of events:              4869433
    total time taken by event execution: 4781.5887
    response time:
         min:                                  0.46ms
         avg:                                  0.98ms
         max:                                 70.15ms
         approx.  95 percentile:               1.30ms

Threads fairness:
    events (avg/stddev):           304339.5625/343.96
    execution time (avg/stddev):   298.8493/0.03


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

General statistics:
    total time:                          300.0011s
    total number of events:              8335928
    total time taken by event execution: 9570.0997
    response time:
         min:                                  0.45ms
         avg:                                  1.15ms
         max:                                 59.71ms
         approx.  95 percentile:               1.51ms

Threads fairness:
    events (avg/stddev):           260497.7500/256.64
    execution time (avg/stddev):   299.0656/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:                           10526930
        other:                           0
        total:                           10526930
    transactions:                        10526930 (35089.44 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 10526930 (35089.44 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0028s
    total number of events:              10526930
    total time taken by event execution: 19165.1747
    response time:
         min:                                  0.44ms
         avg:                                  1.82ms
         max:                                103.55ms
         approx.  95 percentile:               2.43ms

Threads fairness:
    events (avg/stddev):           164483.2813/105.99
    execution time (avg/stddev):   299.4559/0.02


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

General statistics:
    total time:                          300.0043s
    total number of events:              10867257
    total time taken by event execution: 38363.2807
    response time:
         min:                                  0.47ms
         avg:                                  3.53ms
         max:                                 84.86ms
         approx.  95 percentile:               4.70ms

Threads fairness:
    events (avg/stddev):           84900.4453/99.82
    execution time (avg/stddev):   299.7131/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:                           11045848
        other:                           0
        total:                           11045848
    transactions:                        11045848 (36818.22 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11045848 (36818.22 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0104s
    total number of events:              11045848
    total time taken by event execution: 76762.6175
    response time:
         min:                                  0.60ms
         avg:                                  6.95ms
         max:                                199.48ms
         approx.  95 percentile:               9.18ms

Threads fairness:
    events (avg/stddev):           43147.8438/69.64
    execution time (avg/stddev):   299.8540/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:                           11159256
        other:                           0
        total:                           11159256
    transactions:                        11159256 (37195.47 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11159256 (37195.47 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0165s
    total number of events:              11159256
    total time taken by event execution: 153558.5762
    response time:
         min:                                  1.16ms
         avg:                                 13.76ms
         max:                                181.83ms
         approx.  95 percentile:              18.52ms

Threads fairness:
    events (avg/stddev):           21795.4219/50.42
    execution time (avg/stddev):   299.9191/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:                           11177612
        other:                           0
        total:                           11177612
    transactions:                        11177612 (37253.98 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11177612 (37253.98 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0381s
    total number of events:              11177612
    total time taken by event execution: 307155.7804
    response time:
         min:                                  1.21ms
         avg:                                 27.48ms
         max:                                224.83ms
         approx.  95 percentile:              40.50ms

Threads fairness:
    events (avg/stddev):           10915.6367/35.47
    execution time (avg/stddev):   299.9568/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:                           11575384
        other:                           0
        total:                           11575384
    transactions:                        11575384 (38572.81 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11575384 (38572.81 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.0918s
    total number of events:              11575384
    total time taken by event execution: 614353.3904
    response time:
         min:                                  1.09ms
         avg:                                 53.07ms
         max:                                305.86ms
         approx.  95 percentile:              82.82ms

Threads fairness:
    events (avg/stddev):           5652.0430/25.76
    execution time (avg/stddev):   299.9772/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:                           11888135
        other:                           0
        total:                           11888135
    transactions:                        11888135 (39606.38 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 11888135 (39606.38 per sec.)
    other operations:                    0      (0.00 per sec.)

General statistics:
    total time:                          300.1570s
    total number of events:              11888135
    total time taken by event execution: 1228688.9935
    response time:
         min:                                  1.18ms
         avg:                                103.35ms
         max:                                409.70ms
         approx.  95 percentile:             170.18ms

Threads fairness:
    events (avg/stddev):           2902.3767/18.27
    execution time (avg/stddev):   299.9729/0.10