-- 5.7.17 rm -rf 85808 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/85808 -v bin/mysqld --basedir=$PWD --datadir=$PWD/85808 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/85808/log.err 2>&1 & DELIMITER // DROP PROCEDURE IF EXISTS ct// CREATE PROCEDURE ct() BEGIN DECLARE v1 INT DEFAULT 191061; WHILE v1 > 0 DO SET @s = CONCAT('DROP TABLE IF EXISTS ', 't',v1); PREPARE stm FROM @s; EXECUTE stm; SET @s = CONCAT('CREATE TABLE ','t',v1,' (id int not null, name varchar(100), name1 varchar(100), name2 varchar(100), name3 varchar(100), name4 varchar(100), name5 varchar(100))engine=myisam PARTITION BY RANGE (id) (PARTITION p0 VALUES LESS THAN (500000),PARTITION p1 VALUES LESS THAN MAXVALUE)'); PREPARE stm FROM @s; EXECUTE stm; SET v1 = v1 - 1; END WHILE; END // DELIMITER ; call ct; root@localhost [db1]> DELIMITER // root@localhost [db1]> DROP PROCEDURE IF EXISTS ct// Query OK, 0 rows affected (0.00 sec) root@localhost [db1]> root@localhost [db1]> CREATE PROCEDURE ct() -> BEGIN -> -> DECLARE v1 INT DEFAULT 191061; -> WHILE v1 > 0 DO -> -> SET @s = CONCAT('DROP TABLE IF EXISTS ', 't',v1); -> PREPARE stm FROM @s; -> EXECUTE stm; -> -> SET @s = CONCAT('CREATE TABLE ','t',v1,' (id int not null, name varchar(100), '> name1 varchar(100), '> name2 varchar(100), '> name3 varchar(100), '> name4 varchar(100), '> name5 varchar(100))engine=myisam PARTITION BY RANGE (id) (PARTITION p0 VALUES LESS THAN (500000),PARTITION p1 VALUES LESS THAN MAXVALUE)'); -> PREPARE stm FROM @s; -> EXECUTE stm; -> -> SET v1 = v1 - 1; -> END WHILE; -> -> -> END // Query OK, 0 rows affected (0.00 sec) root@localhost [db1]> root@localhost [db1]> DELIMITER ; root@localhost [db1]> call ct; Query OK, 0 rows affected (6 min 3.46 sec) root@localhost [db1]> SELECT count(*) FROM INFORMATION_SCHEMA.TABLES; +----------+ | count(*) | +----------+ | 191341 | +----------+ 1 row in set (2.55 sec) root@localhost [db1]> \q Bye -- restart [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17: [1]+ Done bin/mysqld --basedir=$PWD --datadir=$PWD/85808 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/85808/log.err 2>&1 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17: bin/mysqld --basedir=$PWD --datadir=$PWD/85808 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/85808/log.err 2>&1 & [1] 28470 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17: cat $PWD/85808/log.err|grep 'Beginning of list of non-natively partitioned tables' 2017-04-06T13:06:18.207550Z 0 [Note] Beginning of list of non-natively partitioned tables [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17: cat $PWD/85808/log.err|grep 'End of list of non-natively partitioned tables' 2017-04-06T13:06:38.710435Z 0 [Note] End of list of non-natively partitioned tables ~20min