## Build used

cat docs/INFO_SRC
commit: 1e7cb2a9af423dae8db534e323a69333cec7779d
date: 2017-03-18 07:41:21 +0100
build-date: 2017-03-18 07:43:21 +0100
short: 1e7cb2a
branch: mysql-5.6.36-release

MySQL source 5.6.36

## Start up, conf(from report) used for tests

rm -rf 85910/
scripts/mysql_install_db --defaults-file=./85910.cnf --basedir=$PWD --datadir=$PWD/85910 -v
bin/mysqld --defaults-file=./85910.cnf --basedir=$PWD --datadir=$PWD/85910 --socket=/tmp/mysql_ushastry.sock --log-error=$PWD/85910/log.err 2>&1 &

[umshastr@vilma56]~/mysql-5.6.36: cat 85910.cnf
[mysqld]
innodb_buffer_pool_size = 6G
innodb_log_file_size = 2G
innodb_flush_log_at_trx_commit = 2
innodb_flush_neighbors = 0
innodb_flush_method = O_DIRECT
innodb_file_format = Barracuda
innodb_buffer_pool_instances = 1
performance_schema = 0

##
create database if not exists test;
use test;
create table ps (id int unsigned not null auto_increment primary key, a char(5) not null, key (a)) engine=innodb;
insert into ps (a) values ('aaaaa');
insert into ps (a) select a from ps;
.
.

root@localhost [test]> insert into ps (a) select a from ps;
Query OK, 2097152 rows affected (16.15 sec)
Records: 2097152  Duplicates: 0  Warnings: 0


-- Ubuntu 14.04.2 LTS
### P_S enabled 
update performance_schema.setup_instruments set enabled='yes';
update performance_schema.setup_consumers set enabled='yes';

[umshastr@vilma56]~/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m1.443s
user    0m0.392s
sys     0m0.053s
[umshastr@vilma56]~/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m1.492s
user    0m0.400s
sys     0m0.038s
[umshastr@vilma56]~/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m1.143s
user    0m0.400s
sys     0m0.041s

## P_S disabled
[umshastr@vilma56]~/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m1.065s
user    0m0.399s
sys     0m0.035s
[umshastr@vilma56]~/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m1.074s
user    0m0.397s
sys     0m0.051s

## Oracle Linux Server 7.1

### P_S enabled 
update performance_schema.setup_instruments set enabled='yes';
update performance_schema.setup_consumers set enabled='yes';


[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m1.346s
user    0m0.329s
sys     0m0.069s

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m1.349s
user    0m0.320s
sys     0m0.068s

## P_S disabled

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m0.906s
user    0m0.323s
sys     0m0.060s
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m0.907s
user    0m0.323s
sys     0m0.059s
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock test  -e 'select a from ps where id between 1 and 2000000' > /dev/null

real    0m0.906s
user    0m0.315s
sys     0m0.067s