rm -rf 96475 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/96475 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96475 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/96475/log.err --log-error-verbosity=3 --secure-file-priv="" 2>&1 & - follow steps from report (sorry, don't have dbdeployer on this box) - terminal 1 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: bin/mysql -uroot -S /tmp/mysql_ushastry.sock <<< "CREATE DATABASE test_jfg" [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg <<< " > CREATE TABLE test_jfg.t(id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY); > ALTER TABLE test_jfg.t ADD COLUMN v VARCHAR(255);" [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: for i in $(seq 9); do > bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg <<< "ALTER TABLE test_jfg.t ADD COLUMN c$i CHAR(255) DEFAULT ''" > done [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: seq -f "INSERT INTO t(v) VALUES ('%f');" 1 1000000 | sed -e '1~1000s/^/COMMIT;BEGIN;/' | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg - terminal 2 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg <<< "FLUSH TABLE t FOR EXPORT; DO SLEEP(100)" & [1] 11582 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: sleep 2 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: for s in cfg ibd; do > cp $PWD/96475/test_jfg/t{,_}.$s > done [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: kill %1 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: [1]+ Terminated bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg <<< "FLUSH TABLE t FOR EXPORT; DO SLEEP(100)" - terminal 1 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg <<< "CREATE TABLE t2 LIKE t; ALTER TABLE t2 DISCARD TABLESPACE" [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: for s in cfg ibd; do > cp $PWD/96475/test_jfg/t{_,2}.$s > done [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg -N <<< "SELECT 'begin alter', now(); ALTER TABLE t2 IMPORT TABLESPACE; SELECT 'end alter', now()"& [2] 11923 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.27:bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg -N <<< "DO sleep(2); SELECT 'begin select', now(); SELECT * FROM INFORMATION_SCHEMA.tables; SELECT 'end select', now()" | grep select begin alter 2019-08-09 09:00:19 end alter 2019-08-09 09:00:28 begin select 2019-08-09 09:00:22 end select 2019-08-09 09:00:28 [2]+ Done bin/mysql -uroot -S /tmp/mysql_ushastry.sock test_jfg -N <<< "SELECT 'begin alter', now(); ALTER TABLE t2 IMPORT TABLESPACE; SELECT 'end alter', now()"