####################################### Src build with default cmake options -- 5.5.47 source build cmake . -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/bugs/82524/mysql-5.5.47 -DCOMPILATION_COMMENT="`date +"%d %B %Y"`" make -j32 make install rm -rf 82524 scripts/mysql_install_db --defaults-file=./my.cnf --basedir=/export/umesh/server/source/bugs/82524/mysql-5.5.47 --datadir=/export/umesh/server/source/bugs/82524/mysql-5.5.47/82524 bin/mysqld --defaults-file=./my.cnf --basedir=/export/umesh/server/source/bugs/82524/mysql-5.5.47 --datadir=/export/umesh/server/source/bugs/82524/mysql-5.5.47/82524 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/source/bugs/82524/mysql-5.5.47/82524/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/source/bugs/82524/mysql-5.5.47: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.47 17 August 2016 Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Database changed mysql> CREATE TABLE `accounts` ( -> `aid` int(11) NOT NULL, -> `bid` int(11) DEFAULT NULL, -> `abalance` int(11) DEFAULT NULL, -> `filler` char(84) DEFAULT NULL -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.00 sec) mysql> LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ','; Query OK, 10000000 rows affected (45.61 sec) Records: 10000000 Deleted: 0 Skipped: 0 Warnings: 0 mysql> truncate accounts; Query OK, 0 rows affected (0.30 sec) mysql> SET profiling = 1; Query OK, 0 rows affected (0.00 sec) -- in 5 attempts reached ~45 sec mysql> LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ','; Query OK, 10000000 rows affected (45.54 sec) Records: 10000000 Deleted: 0 Skipped: 0 Warnings: 0 mysql> SHOW PROFILES; +----------+-------------+-----------------------------------------------------------------------------------+ | Query_ID | Duration | Query | +----------+-------------+-----------------------------------------------------------------------------------+ | 1 | 45.53857675 | LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ',' | +----------+-------------+-----------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SHOW PROFILE FOR QUERY 1; +------------------------------+-----------+ | Status | Duration | +------------------------------+-----------+ | starting | 0.000043 | | checking permissions | 0.000007 | | Opening tables | 0.000019 | | System lock | 45.522664 | | Waiting for query cache lock | 0.000076 | | query end | 0.015722 | | closing tables | 0.000017 | | freeing items | 0.000022 | | logging slow query | 0.000002 | | logging slow query | 0.000003 | | cleaning up | 0.000003 | +------------------------------+-----------+ 11 rows in set (0.00 sec) mysql> -- 5.5.51 source build cmake . -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/bugs/82524/mysql-5.5.51 -DCOMPILATION_COMMENT="`date +"%d %B %Y"`" make -j32 make install rm -rf 82524 scripts/mysql_install_db --defaults-file=./my.cnf --basedir=/export/umesh/server/source/bugs/82524/mysql-5.5.51 --datadir=/export/umesh/server/source/bugs/82524/mysql-5.5.51/82524 bin/mysqld --defaults-file=./my.cnf --basedir=/export/umesh/server/source/bugs/82524/mysql-5.5.51 --datadir=/export/umesh/server/source/bugs/82524/mysql-5.5.51/82524 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/source/bugs/82524/mysql-5.5.51/82524/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/source/bugs/82524/mysql-5.5.51: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.51 17 August 2016 Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Database changed mysql> CREATE TABLE `accounts` ( -> `aid` int(11) NOT NULL, -> `bid` int(11) DEFAULT NULL, -> `abalance` int(11) DEFAULT NULL, -> `filler` char(84) DEFAULT NULL -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.00 sec) mysql> SET profiling = 1; Query OK, 0 rows affected (0.00 sec) -- in 5 attempts reached ~45 sec mysql> LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ','; Query OK, 10000000 rows affected (45.54 sec) Records: 10000000 Deleted: 0 Skipped: 0 Warnings: 0 mysql> SHOW PROFILES; +----------+-------------+-----------------------------------------------------------------------------------+ | Query_ID | Duration | Query | +----------+-------------+-----------------------------------------------------------------------------------+ | 1 | 45.53785175 | LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ',' | +----------+-------------+-----------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SHOW PROFILE FOR QUERY 1; +------------------------------+-----------+ | Status | Duration | +------------------------------+-----------+ | starting | 0.000050 | | checking permissions | 0.000008 | | Opening tables | 0.000020 | | System lock | 0.000008 | | executing | 45.518240 | | Waiting for query cache lock | 0.000009 | | executing | 0.000051 | | query end | 0.019415 | | closing tables | 0.000018 | | freeing items | 0.000027 | | logging slow query | 0.000003 | | logging slow query | 0.000003 | | cleaning up | 0.000003 | +------------------------------+-----------+ 13 rows in set (0.00 sec) -- 5.6.32 source build (5.7 conf file taken from report - P_S is disabled) cmake . -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/bugs/82524/mysql-5.6.32 -DCOMPILATION_COMMENT="`date +"%d %B %Y"`" make -j32 make install rm -rf 82524 scripts/mysql_install_db --defaults-file=./my.cnf --basedir=/export/umesh/server/source/bugs/82524/mysql-5.6.32 --datadir=/export/umesh/server/source/bugs/82524/mysql-5.6.32/82524 -v bin/mysqld --defaults-file=./my.cnf --basedir=/export/umesh/server/source/bugs/82524/mysql-5.6.32 --datadir=/export/umesh/server/source/bugs/82524/mysql-5.6.32/82524 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/source/bugs/82524/mysql-5.6.32/82524/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/source/bugs/82524/mysql-5.6.32: bin/mysql -uroot -S /tmp/mysql_ushastry.sock --prompt='5.6.32>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.32 17 August 2016 Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 5.6.32>use test Database changed 5.6.32>CREATE TABLE `accounts` ( -> `aid` int(11) NOT NULL, -> `bid` int(11) DEFAULT NULL, -> `abalance` int(11) DEFAULT NULL, -> `filler` char(84) DEFAULT NULL -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -> ; Query OK, 0 rows affected (0.00 sec) 5.6.32>SET profiling = 1; Query OK, 0 rows affected, 1 warning (0.00 sec) 5.6.32>LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ','; Query OK, 10000000 rows affected (48.32 sec) Records: 10000000 Deleted: 0 Skipped: 0 Warnings: 0 5.6.32>SHOW PROFILES; +----------+-------------+-----------------------------------------------------------------------------------+ | Query_ID | Duration | Query | +----------+-------------+-----------------------------------------------------------------------------------+ | 1 | 48.31781550 | LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ',' | +----------+-------------+-----------------------------------------------------------------------------------+ 1 row in set, 1 warning (0.01 sec) 5.6.32>SHOW PROFILE FOR QUERY 1; +----------------------+-----------+ | Status | Duration | +----------------------+-----------+ | starting | 0.000048 | | checking permissions | 0.000010 | | Opening tables | 0.000162 | | System lock | 0.000012 | | executing | 48.305917 | | query end | 0.011614 | | closing tables | 0.000022 | | freeing items | 0.000024 | | logging slow query | 0.000003 | | cleaning up | 0.000004 | +----------------------+-----------+ 10 rows in set, 1 warning (0.00 sec) -- 5.7.14 source build (conf file taken from report - P_S is disabled) cmake . -DDOWNLOAD_BOOST=1 -DWITH_BOOST ../../boost/ -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/bugs/82524/mysql-5.7.14 make -j32 make install rm -rf 82524 bin/mysqld --defaults-file=./my_new.cnf --initialize-insecure --basedir=/export/umesh/server/source/bugs/82524/mysql-5.7.14 --datadir=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/82524 -v bin/mysqld --defaults-file=./my_new.cnf --basedir=/export/umesh/server/source/bugs/82524/mysql-5.7.14 --datadir=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/82524 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/82524/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/source/bugs/82524/mysql-5.7.14: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.14 Source distribution Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> truncate accounts; Query OK, 0 rows affected (0.25 sec) mysql> SET profiling = 1; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ','; Query OK, 10000000 rows affected (59.96 sec) Records: 10000000 Deleted: 0 Skipped: 0 Warnings: 0 mysql> SHOW PROFILES; +----------+-------------+-----------------------------------------------------------------------------------+ | Query_ID | Duration | Query | +----------+-------------+-----------------------------------------------------------------------------------+ | 1 | 59.95701100 | LOAD DATA INFILE '/tmp/accounts.dat' INTO TABLE accounts FIELDS TERMINATED BY ',' | +----------+-------------+-----------------------------------------------------------------------------------+ 1 row in set, 1 warning (0.00 sec) mysql> SHOW PROFILE FOR QUERY 1; +----------------------+-----------+ | Status | Duration | +----------------------+-----------+ | starting | 0.000067 | | checking permissions | 0.000012 | | Opening tables | 0.000019 | | System lock | 0.000006 | | executing | 59.950024 | | query end | 0.006829 | | closing tables | 0.000020 | | freeing items | 0.000031 | | cleaning up | 0.000004 | +----------------------+-----------+ 9 rows in set, 1 warning (0.00 sec)