Comment 1 for bug 1457459

Confirmed with PS 5.6.24.

nilnandan@desktop:~$ sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp-table-size=100000 --mysql-db=dbtest --mysql-user=root --mysql-password=root prepare
sysbench 0.5: multi-threaded system evaluation benchmark

Creating table 'sbtest1'...
Inserting 100000 records into 'sbtest1'
nilnandan@desktop:~$
nilnandan@desktop:~$ sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp-table-size=100000 --oltp-test-mode=complex --oltp-read-only=off --num-threads=32 --max-time=120 --max-requests=0 --mysql-db=dbtest --mysql-user=root --mysql-password=root run

mysql> set global innodb_thread_concurrency=0;
Query OK, 0 rows affected (0.00 sec)

mysql> show engine innodb status\G
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
32 read views open inside InnoDB
32 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
31 out of 1000 descriptors used
1 row in set (0.00 sec)

mysql> set global innodb_thread_concurrency=1;
Query OK, 0 rows affected (0.00 sec)

mysql> show engine innodb status\G
ROW OPERATIONS
--------------
0 queries inside InnoDB, 31 queries in queue
32 read views open inside InnoDB
32 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
32 out of 1000 descriptors used
1 row in set (0.00 sec)

mysql> set global innodb_thread_concurrency=0;
Query OK, 0 rows affected (0.00 sec)

mysql> show engine innodb status\G
ROW OPERATIONS
--------------
0 queries inside InnoDB, 31 queries in queue
32 read views open inside InnoDB
32 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
32 out of 1000 descriptors used
1 row in set (0.00 sec)