pt-online-change-ddl（在线ddl）

发布时间：2020-06-26 16:49:52 作者：Love轩轩
来源：网络阅读：453

mysql> desc online_ddl;

+---------+--------------+------+-----+-------------------+----------------+

+---------+--------------+------+-----+-------------------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

+---------+--------------+------+-----+-------------------+----------------+

3 rows in set (0.00 sec)

mysql> desc online_ddl_f;

+---------+-------------+------+-----+---------+----------------+

+---------+-------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

+---------+-------------+------+-----+---------+----------------+

2 rows in set (0.00 sec)

mysql> show create table online_ddl_f;

+--------------+----------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------

| Table | Create Table

+--------------+----------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------

| online_ddl_f | CREATE TABLE `online_ddl_f` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`orderid` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `orderid` (`orderid`),

CONSTRAINT `online_ddl_f_ibfk_1` FOREIGN KEY (`orderid`) REFERENCES `online_ddl` (`name`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci |

+--------------+----------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------

root@ljd-python:~# pt-online-schema-change --user=root --password=123456 --host=192.168.0.3 --port=3306 --charset=utf8 --nodrop-old-table --alter="add column uuid varchar(60) null default null after id " D=test,t=online_ddl --exec

No slaves found. See --recursion-method if host ljd-PC has slaves.

Not checking slave lag because no slaves were found and --check-slave-lag was not specified.

Operation, tries, wait:

analyze_table, 10, 1

copy_rows, 10, 0.25

create_triggers, 10, 1

drop_triggers, 10, 1

swap_tables, 10, 1

update_foreign_keys, 10, 1

Child tables:

`test`.`online_ddl_f` (approx. 3 rows)

You did not specify --alter-foreign-keys-method, but there are foreign keys that reference the table. Please read the tool's documentation carefully.

发现报错，提示有个表：online_ddl_log有外键参照表online_ddl，需要使用--alter-foreign-keys-method参数指明对外键的操作。

--alter-foreign-keys-method 的值可以为：auto、rebuild_constraints、drop_swap、none 四种

1、当业务量较大时，修改操作会等待没有数据修改后，执行最后的rename操作。因此，在修改表结构时，应该尽量选择在业务相对空闲时，至少修改表上的数据操作较低时，执行较为妥当。

2、如果对外键表操作时，四种外键操作类型需要根据表的数据量和可靠程度，进行选择。处于可靠性的原因，尽量使用rebuild_constraints类型，如果没有可靠性要求，可以使用auto类型。

3、当--alter-foreign-keys-method=none时，外键索引将失效，需要重建外键索引，方可再次使用

4、由于可能存在一定的风险，在操作之前，建议对数据表进行备份，可以使得操作更安全、可靠。

加上--alter-foreign-keys-method 参数，再次执行：

No slaves found. See --recursion-method if host ljd-PC has slaves.

Not checking slave lag because no slaves were found and --check-slave-lag was not specified.

Operation, tries, wait:

analyze_table, 10, 1

copy_rows, 10, 0.25

create_triggers, 10, 1

drop_triggers, 10, 1

swap_tables, 10, 1

update_foreign_keys, 10, 1

Child tables:

`test`.`online_ddl_f` (approx. 3 rows)

Will use the rebuild_constraints method to update foreign keys.

Altering `test`.`online_ddl`...

Creating new table...

Created new table test._online_ddl_new OK.

Altering new table...

Altered `test`.`_online_ddl_new` OK.

2017-05-21T22:10:42 Creating triggers...

2017-05-21T22:10:43 Created triggers OK.

2017-05-21T22:10:43 Copying approximately 127391 rows...

2017-05-21T22:11:08 Copied rows OK.

2017-05-21T22:11:08 Analyzing new table...

2017-05-21T22:11:08 Swapping tables...

2017-05-21T22:11:10 Swapped original and new tables OK.

2017-05-21T22:11:10 Rebuilding foreign key constraints...

2017-05-21T22:11:12 Rebuilt foreign key constraints OK.

Not dropping old table because --no-drop-old-table was specified.

2017-05-21T22:11:12 Dropping triggers...

2017-05-21T22:11:12 Dropped triggers OK.

Successfully altered `test`.`online_ddl`.

root@ljd-python:~#

过程：

2017-05-21T14:10:39.708253Z 56 Connect root@192.168.0.12 on test using TCP/IP

2017-05-21T14:10:39.709253Z 56 Query SELECT @@SQL_MODE

2017-05-21T14:10:39.713254Z 56 Query /*!40101 SET NAMES "utf8"*/

2017-05-21T14:10:39.714254Z 56 Query SHOW VARIABLES LIKE 'innodb\_lock_wait_timeout'

2017-05-21T14:10:39.720254Z 56 Query SET SESSION innodb_lock_wait_timeout=1

2017-05-21T14:10:39.722254Z 56 Query SHOW VARIABLES LIKE 'lock\_wait_timeout'

2017-05-21T14:10:39.726254Z 56 Query SET SESSION lock_wait_timeout=60

2017-05-21T14:10:39.727254Z 56 Query SHOW VARIABLES LIKE 'wait\_timeout'

2017-05-21T14:10:39.731255Z 56 Query SET SESSION wait_timeout=10000

2017-05-21T14:10:39.732255Z 56 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/

2017-05-21T14:10:39.733255Z 56 Query SELECT @@server_id /*!50038 , @@hostname*/

2017-05-21T14:10:39.737255Z 57 Connect root@192.168.0.12 on test using TCP/IP

2017-05-21T14:10:39.738255Z 57 Query SELECT @@SQL_MODE

2017-05-21T14:10:39.739255Z 57 Query /*!40101 SET NAMES "utf8"*/

2017-05-21T14:10:39.740255Z 57 Query SHOW VARIABLES LIKE 'innodb\_lock_wait_timeout'

2017-05-21T14:10:39.744255Z 57 Query SET SESSION innodb_lock_wait_timeout=1

2017-05-21T14:10:39.745255Z 57 Query SHOW VARIABLES LIKE 'lock\_wait_timeout'

2017-05-21T14:10:39.748256Z 57 Query SET SESSION lock_wait_timeout=60

2017-05-21T14:10:39.749256Z 57 Query SHOW VARIABLES LIKE 'wait\_timeout'

2017-05-21T14:10:39.753256Z 57 Query SET SESSION wait_timeout=10000

2017-05-21T14:10:39.754256Z 57 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/

2017-05-21T14:10:39.755256Z 57 Query SELECT @@server_id /*!50038 , @@hostname*/

2017-05-21T14:10:39.756256Z 56 Query SHOW VARIABLES LIKE 'wsrep_on'

2017-05-21T14:10:39.759256Z 56 Query SHOW VARIABLES LIKE 'version%'

2017-05-21T14:10:39.764256Z 56 Query SHOW ENGINES

2017-05-21T14:10:39.766257Z 56 Query SHOW VARIABLES LIKE 'innodb_version'

2017-05-21T14:10:39.772257Z 56 Query SHOW VARIABLES LIKE 'innodb_stats_persistent'

2017-05-21T14:10:39.775257Z 56 Query SELECT @@SERVER_ID

2017-05-21T14:10:39.777257Z 56 Query SHOW GRANTS FOR CURRENT_USER()

2017-05-21T14:10:39.778257Z 56 Query SHOW PROCESSLIST

2017-05-21T14:10:39.779257Z 56 Query SHOW SLAVE HOSTS

2017-05-21T14:10:39.781257Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:39.784258Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:39.788258Z 56 Query SELECT CONCAT(@@hostname, @@port)

2017-05-21T14:10:39.790258Z 56 Query SHOW TABLES FROM `test` LIKE 'online\_ddl'

2017-05-21T14:10:39.792258Z 56 Query SHOW TRIGGERS FROM `test` LIKE 'online\_ddl'

2017-05-21T14:10:39.793258Z 56 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */

2017-05-21T14:10:39.794258Z 56 Query USE `test`

2017-05-21T14:10:39.795258Z 56 Query SHOW CREATE TABLE `test`.`online_ddl`

2017-05-21T14:10:39.797258Z 56 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */

2017-05-21T14:10:39.799258Z 56 Query EXPLAIN SELECT * FROM `test`.`online_ddl` WHERE 1=1

2017-05-21T14:10:39.800259Z 56 Query SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE referenced_table_schema='test' AND referenced_table_name='online_ddl'

2017-05-21T14:10:39.928266Z 56 Query EXPLAIN SELECT * FROM `test`.`online_ddl_f` WHERE 1=1

2017-05-21T14:10:39.931266Z 56 Query SHOW VARIABLES LIKE 'wsrep_on'

2017-05-21T14:10:39.935266Z 56 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */

2017-05-21T14:10:39.936266Z 56 Query USE `test`

2017-05-21T14:10:39.938266Z 56 Query SHOW CREATE TABLE `test`.`online_ddl`

2017-05-21T14:10:39.939266Z 56 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */

2017-05-21T14:10:39.941267Z 56 Query CREATE TABLE `test`.`_online_ddl_new` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(500) COLLATE latin1_general_ci DEFAULT NULL,

`regdate` datetime DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

UNIQUE KEY `idx_name` (`name`),

KEY `idxname` (`name`)

) ENGINE=InnoDB AUTO_INCREMENT=226161 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

2017-05-21T14:10:40.434295Z 56 Query ALTER TABLE `test`.`_online_ddl_new` add column uuid varchar(60) null default null after id

2017-05-21T14:10:41.170337Z 56 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */

2017-05-21T14:10:41.171337Z 56 Query USE `test`

2017-05-21T14:10:41.172337Z 56 Query SHOW CREATE TABLE `test`.`_online_ddl_new`

2017-05-21T14:10:41.174337Z 56 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */

2017-05-21T14:10:41.178337Z 56 Query CREATE TRIGGER `pt_osc_test_online_ddl_del` AFTER DELETE ON `test`.`online_ddl` FOR EACH ROW DELETE IGNORE FROM `test`.`_online_ddl_new` WHERE `test`.`_online_ddl_new`.`id` <=> OLD.`id`

2017-05-21T14:10:41.581360Z 56 Query CREATE TRIGGER `pt_osc_test_online_ddl_upd` AFTER UPDATE ON `test`.`online_ddl` FOR EACH ROW REPLACE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) VALUES (NEW.`id`, NEW.`name`, NEW.`regdate`)

2017-05-21T14:10:41.780372Z 56 Query CREATE TRIGGER `pt_osc_test_online_ddl_ins` AFTER INSERT ON `test`.`online_ddl` FOR EACH ROW REPLACE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) VALUES (NEW.`id`, NEW.`name`, NEW.`regdate`)

2017-05-21T14:10:41.934381Z 56 Query EXPLAIN SELECT * FROM `test`.`online_ddl` WHERE 1=1

2017-05-21T14:10:41.940381Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) ORDER BY `id` LIMIT 1 /*first lower boundary*/

2017-05-21T14:10:41.943381Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX (`PRIMARY`) WHERE `id` IS NOT NULL ORDER BY `id` LIMIT 1 /*key_len*/

2017-05-21T14:10:41.945381Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ * FROM `test`.`online_ddl` FORCE INDEX (`PRIMARY`) WHERE `id` >= '11995' /*key_len*/

2017-05-21T14:10:41.960382Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '11995')) ORDER BY `id` LIMIT 999, 2 /*next chunk boundary*/

2017-05-21T14:10:41.962382Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '11995')) ORDER BY `id` LIMIT 999, 2 /*next chunk boundary*/

2017-05-21T14:10:41.972383Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '11995')) AND ((`id` <= '12994')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:41.974383Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '11995')) AND ((`id` <= '12994')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:42.714425Z 56 Query SHOW WARNINGS

2017-05-21T14:10:42.715425Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:42.718425Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '12995')) ORDER BY `id` LIMIT 674, 2 /*next chunk boundary*/

2017-05-21T14:10:42.720426Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '12995')) ORDER BY `id` LIMIT 674, 2 /*next chunk boundary*/

2017-05-21T14:10:42.721426Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '12995')) AND ((`id` <= '13669')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:42.723426Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '12995')) AND ((`id` <= '13669')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:42.990441Z 56 Query SHOW WARNINGS

2017-05-21T14:10:42.991441Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:42.995441Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '13670')) ORDER BY `id` LIMIT 866, 2 /*next chunk boundary*/

2017-05-21T14:10:42.998441Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '13670')) ORDER BY `id` LIMIT 866, 2 /*next chunk boundary*/

2017-05-21T14:10:43.000442Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '13670')) AND ((`id` <= '14552')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:43.001442Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '13670')) AND ((`id` <= '14552')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:43.269457Z 56 Query SHOW WARNINGS

2017-05-21T14:10:43.271457Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:43.274457Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '14553')) ORDER BY `id` LIMIT 1093, 2 /*next chunk boundary*/

2017-05-21T14:10:43.276457Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '14553')) ORDER BY `id` LIMIT 1093, 2 /*next chunk boundary*/

2017-05-21T14:10:43.278457Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '14553')) AND ((`id` <= '15646')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:43.279458Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '14553')) AND ((`id` <= '15646')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:43.890492Z 56 Query SHOW WARNINGS

2017-05-21T14:10:43.892493Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:43.894493Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '15647')) ORDER BY `id` LIMIT 998, 2 /*next chunk boundary*/

2017-05-21T14:10:43.896493Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '15647')) ORDER BY `id` LIMIT 998, 2 /*next chunk boundary*/

2017-05-21T14:10:43.897493Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '15647')) AND ((`id` <= '16645')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:43.899493Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '15647')) AND ((`id` <= '16645')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:44.277515Z 56 Query SHOW WARNINGS

2017-05-21T14:10:44.278515Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:44.282515Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '16646')) ORDER BY `id` LIMIT 1089, 2 /*next chunk boundary*/

2017-05-21T14:10:44.283515Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '16646')) ORDER BY `id` LIMIT 1089, 2 /*next chunk boundary*/

2017-05-21T14:10:44.285515Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '16646')) AND ((`id` <= '17735')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:44.286515Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '16646')) AND ((`id` <= '17735')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:46.116620Z 56 Query SHOW WARNINGS

2017-05-21T14:10:46.118620Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:46.122620Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '17736')) ORDER BY `id` LIMIT 576, 2 /*next chunk boundary*/

2017-05-21T14:10:46.123620Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '17736')) ORDER BY `id` LIMIT 576, 2 /*next chunk boundary*/

2017-05-21T14:10:46.125620Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '17736')) AND ((`id` <= '18312')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:46.127620Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '17736')) AND ((`id` <= '18312')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:46.303631Z 56 Query SHOW WARNINGS

2017-05-21T14:10:46.306631Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:46.309631Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18313')) ORDER BY `id` LIMIT 658, 2 /*next chunk boundary*/

2017-05-21T14:10:46.310631Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18313')) ORDER BY `id` LIMIT 658, 2 /*next chunk boundary*/

2017-05-21T14:10:46.312631Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18313')) AND ((`id` <= '18971')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:46.314631Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18313')) AND ((`id` <= '18971')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:47.710711Z 56 Query SHOW WARNINGS

2017-05-21T14:10:47.713711Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:47.717711Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18972')) ORDER BY `id` LIMIT 468, 2 /*next chunk boundary*/

2017-05-21T14:10:47.719712Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18972')) ORDER BY `id` LIMIT 468, 2 /*next chunk boundary*/

2017-05-21T14:10:47.721712Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18972')) AND ((`id` <= '19440')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:47.723712Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '18972')) AND ((`id` <= '19440')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.796773Z 56 Query SHOW WARNINGS

2017-05-21T14:10:48.798773Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:48.812774Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19441')) ORDER BY `id` LIMIT 389, 2 /*next chunk boundary*/

2017-05-21T14:10:48.822775Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19441')) ORDER BY `id` LIMIT 389, 2 /*next chunk boundary*/

2017-05-21T14:10:48.826775Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19441')) AND ((`id` <= '19830')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.829775Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19441')) AND ((`id` <= '19830')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.840776Z 56 Query SHOW WARNINGS

2017-05-21T14:10:48.841776Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:48.845776Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19831')) ORDER BY `id` LIMIT 463, 2 /*next chunk boundary*/

2017-05-21T14:10:48.846776Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19831')) ORDER BY `id` LIMIT 463, 2 /*next chunk boundary*/

2017-05-21T14:10:48.848776Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19831')) AND ((`id` <= '20294')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.850776Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '19831')) AND ((`id` <= '20294')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.862777Z 56 Query SHOW WARNINGS

2017-05-21T14:10:48.863777Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:48.867777Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20295')) ORDER BY `id` LIMIT 580, 2 /*next chunk boundary*/

2017-05-21T14:10:48.868777Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20295')) ORDER BY `id` LIMIT 580, 2 /*next chunk boundary*/

2017-05-21T14:10:48.870777Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20295')) AND ((`id` <= '20875')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.871777Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20295')) AND ((`id` <= '20875')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.886778Z 56 Query SHOW WARNINGS

2017-05-21T14:10:48.887778Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:48.891779Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20876')) ORDER BY `id` LIMIT 772, 2 /*next chunk boundary*/

2017-05-21T14:10:48.892779Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20876')) ORDER BY `id` LIMIT 772, 2 /*next chunk boundary*/

2017-05-21T14:10:48.894779Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20876')) AND ((`id` <= '21648')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:48.896779Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '20876')) AND ((`id` <= '21648')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.055788Z 56 Query SHOW WARNINGS

2017-05-21T14:10:49.056788Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:49.059788Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '21649')) ORDER BY `id` LIMIT 981, 2 /*next chunk boundary*/

2017-05-21T14:10:49.061788Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '21649')) ORDER BY `id` LIMIT 981, 2 /*next chunk boundary*/

2017-05-21T14:10:49.062788Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '21649')) AND ((`id` <= '22630')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.064788Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '21649')) AND ((`id` <= '22630')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.101791Z 56 Query SHOW WARNINGS

2017-05-21T14:10:49.102791Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:49.105791Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '22631')) ORDER BY `id` LIMIT 1444, 2 /*next chunk boundary*/

2017-05-21T14:10:49.107791Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '22631')) ORDER BY `id` LIMIT 1444, 2 /*next chunk boundary*/

2017-05-21T14:10:49.108791Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '22631')) AND ((`id` <= '24075')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.110791Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '22631')) AND ((`id` <= '24075')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.167794Z 56 Query SHOW WARNINGS

2017-05-21T14:10:49.169794Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:49.172795Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '24076')) ORDER BY `id` LIMIT 2249, 2 /*next chunk boundary*/

2017-05-21T14:10:49.175795Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '24076')) ORDER BY `id` LIMIT 2249, 2 /*next chunk boundary*/

2017-05-21T14:10:49.178795Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '24076')) AND ((`id` <= '26325')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.179795Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '24076')) AND ((`id` <= '26325')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.249799Z 56 Query SHOW WARNINGS

2017-05-21T14:10:49.250799Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:49.253799Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '26326')) ORDER BY `id` LIMIT 3705, 2 /*next chunk boundary*/

2017-05-21T14:10:49.255799Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '26326')) ORDER BY `id` LIMIT 3705, 2 /*next chunk boundary*/

2017-05-21T14:10:49.257799Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '26326')) AND ((`id` <= '30031')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:49.259800Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '26326')) AND ((`id` <= '30031')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:51.979955Z 56 Query SHOW WARNINGS

2017-05-21T14:10:51.980955Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:51.983955Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '30032')) ORDER BY `id` LIMIT 1149, 2 /*next chunk boundary*/

2017-05-21T14:10:51.984955Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '30032')) ORDER BY `id` LIMIT 1149, 2 /*next chunk boundary*/

2017-05-21T14:10:51.986956Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '30032')) AND ((`id` <= '31181')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:51.988956Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '30032')) AND ((`id` <= '31181')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.019957Z 56 Query SHOW WARNINGS

2017-05-21T14:10:52.021958Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:52.024958Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '31182')) ORDER BY `id` LIMIT 1369, 2 /*next chunk boundary*/

2017-05-21T14:10:52.025958Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '31182')) ORDER BY `id` LIMIT 1369, 2 /*next chunk boundary*/

2017-05-21T14:10:52.027958Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '31182')) AND ((`id` <= '50482')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.028958Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '31182')) AND ((`id` <= '50482')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.063960Z 56 Query SHOW WARNINGS

2017-05-21T14:10:52.065960Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:52.068960Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '50483')) ORDER BY `id` LIMIT 1710, 2 /*next chunk boundary*/

2017-05-21T14:10:52.070960Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '50483')) ORDER BY `id` LIMIT 1710, 2 /*next chunk boundary*/

2017-05-21T14:10:52.072960Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '50483')) AND ((`id` <= '52193')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.073961Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '50483')) AND ((`id` <= '52193')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.113963Z 56 Query SHOW WARNINGS

2017-05-21T14:10:52.114963Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:52.118963Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '52194')) ORDER BY `id` LIMIT 2256, 2 /*next chunk boundary*/

2017-05-21T14:10:52.119963Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '52194')) ORDER BY `id` LIMIT 2256, 2 /*next chunk boundary*/

2017-05-21T14:10:52.122963Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '52194')) AND ((`id` <= '54450')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.124963Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '52194')) AND ((`id` <= '54450')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.184967Z 56 Query SHOW WARNINGS

2017-05-21T14:10:52.186967Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:52.189967Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '54451')) ORDER BY `id` LIMIT 3126, 2 /*next chunk boundary*/

2017-05-21T14:10:52.191967Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '54451')) ORDER BY `id` LIMIT 3126, 2 /*next chunk boundary*/

2017-05-21T14:10:52.193967Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '54451')) AND ((`id` <= '57577')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.195968Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '54451')) AND ((`id` <= '57577')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.280972Z 56 Query SHOW WARNINGS

2017-05-21T14:10:52.281972Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:52.285973Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '57578')) ORDER BY `id` LIMIT 4504, 2 /*next chunk boundary*/

2017-05-21T14:10:52.286973Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '57578')) ORDER BY `id` LIMIT 4504, 2 /*next chunk boundary*/

2017-05-21T14:10:52.289973Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '57578')) AND ((`id` <= '62082')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.291973Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '57578')) AND ((`id` <= '62082')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.657994Z 56 Query SHOW WARNINGS

2017-05-21T14:10:52.659994Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:52.663994Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '62083')) ORDER BY `id` LIMIT 5067, 2 /*next chunk boundary*/

2017-05-21T14:10:52.664994Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '62083')) ORDER BY `id` LIMIT 5067, 2 /*next chunk boundary*/

2017-05-21T14:10:52.667995Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '62083')) AND ((`id` <= '67150')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:52.670995Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '62083')) AND ((`id` <= '67150')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:53.562046Z 56 Query SHOW WARNINGS

2017-05-21T14:10:53.564046Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:53.567046Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '67151')) ORDER BY `id` LIMIT 3897, 2 /*next chunk boundary*/

2017-05-21T14:10:53.568046Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '67151')) ORDER BY `id` LIMIT 3897, 2 /*next chunk boundary*/

2017-05-21T14:10:53.571046Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '67151')) AND ((`id` <= '71048')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:53.573046Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '67151')) AND ((`id` <= '71048')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:55.908180Z 56 Query SHOW WARNINGS

2017-05-21T14:10:55.909180Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:55.912180Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '71049')) ORDER BY `id` LIMIT 1913, 2 /*next chunk boundary*/

2017-05-21T14:10:55.914180Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '71049')) ORDER BY `id` LIMIT 1913, 2 /*next chunk boundary*/

2017-05-21T14:10:55.916180Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '71049')) AND ((`id` <= '72962')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:55.918180Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '71049')) AND ((`id` <= '72962')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:55.986184Z 56 Query SHOW WARNINGS

2017-05-21T14:10:55.987184Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:55.990185Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '72963')) ORDER BY `id` LIMIT 2212, 2 /*next chunk boundary*/

2017-05-21T14:10:55.992185Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '72963')) ORDER BY `id` LIMIT 2212, 2 /*next chunk boundary*/

2017-05-21T14:10:55.994185Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '72963')) AND ((`id` <= '75175')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:55.996185Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '72963')) AND ((`id` <= '75175')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:56.969241Z 56 Query SHOW WARNINGS

2017-05-21T14:10:56.972241Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:56.977241Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '75176')) ORDER BY `id` LIMIT 1869, 2 /*next chunk boundary*/

2017-05-21T14:10:56.978241Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '75176')) ORDER BY `id` LIMIT 1869, 2 /*next chunk boundary*/

2017-05-21T14:10:56.980241Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '75176')) AND ((`id` <= '77045')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:56.981241Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '75176')) AND ((`id` <= '77045')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.119249Z 56 Query SHOW WARNINGS

2017-05-21T14:10:57.121249Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:57.124249Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '77046')) ORDER BY `id` LIMIT 2148, 2 /*next chunk boundary*/

2017-05-21T14:10:57.125249Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '77046')) ORDER BY `id` LIMIT 2148, 2 /*next chunk boundary*/

2017-05-21T14:10:57.127250Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '77046')) AND ((`id` <= '79194')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.128250Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '77046')) AND ((`id` <= '79194')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.184253Z 56 Query SHOW WARNINGS

2017-05-21T14:10:57.186253Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:57.189253Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '79195')) ORDER BY `id` LIMIT 2658, 2 /*next chunk boundary*/

2017-05-21T14:10:57.190253Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '79195')) ORDER BY `id` LIMIT 2658, 2 /*next chunk boundary*/

2017-05-21T14:10:57.193253Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '79195')) AND ((`id` <= '81853')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.195253Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '79195')) AND ((`id` <= '81853')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.262257Z 56 Query SHOW WARNINGS

2017-05-21T14:10:57.264257Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:57.269258Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '81854')) ORDER BY `id` LIMIT 3439, 2 /*next chunk boundary*/

2017-05-21T14:10:57.273258Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '81854')) ORDER BY `id` LIMIT 3439, 2 /*next chunk boundary*/

2017-05-21T14:10:57.277258Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '81854')) AND ((`id` <= '85293')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.280258Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '81854')) AND ((`id` <= '85293')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.467269Z 56 Query SHOW WARNINGS

2017-05-21T14:10:57.468269Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:57.472269Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '85294')) ORDER BY `id` LIMIT 4269, 2 /*next chunk boundary*/

2017-05-21T14:10:57.473269Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '85294')) ORDER BY `id` LIMIT 4269, 2 /*next chunk boundary*/

2017-05-21T14:10:57.476270Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '85294')) AND ((`id` <= '89563')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.479270Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '85294')) AND ((`id` <= '89563')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.579275Z 56 Query SHOW WARNINGS

2017-05-21T14:10:57.580275Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:57.584276Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '89564')) ORDER BY `id` LIMIT 5865, 2 /*next chunk boundary*/

2017-05-21T14:10:57.585276Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '89564')) ORDER BY `id` LIMIT 5865, 2 /*next chunk boundary*/

2017-05-21T14:10:57.588276Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '89564')) AND ((`id` <= '95429')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:57.590276Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '89564')) AND ((`id` <= '95429')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:59.927410Z 56 Query SHOW WARNINGS

2017-05-21T14:10:59.929410Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:10:59.933410Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '95430')) ORDER BY `id` LIMIT 2432, 2 /*next chunk boundary*/

2017-05-21T14:10:59.935410Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '95430')) ORDER BY `id` LIMIT 2432, 2 /*next chunk boundary*/

2017-05-21T14:10:59.938410Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '95430')) AND ((`id` <= '97862')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:10:59.940410Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '95430')) AND ((`id` <= '97862')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:00.795459Z 56 Query SHOW WARNINGS

2017-05-21T14:11:00.797460Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:00.800460Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '97863')) ORDER BY `id` LIMIT 2162, 2 /*next chunk boundary*/

2017-05-21T14:11:00.802460Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '97863')) ORDER BY `id` LIMIT 2162, 2 /*next chunk boundary*/

2017-05-21T14:11:00.804460Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '97863')) AND ((`id` <= '100025')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:00.805460Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '97863')) AND ((`id` <= '100025')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:00.865463Z 56 Query SHOW WARNINGS

2017-05-21T14:11:00.867464Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:00.870464Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '100026')) ORDER BY `id` LIMIT 2548, 2 /*next chunk boundary*/

2017-05-21T14:11:00.871464Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '100026')) ORDER BY `id` LIMIT 2548, 2 /*next chunk boundary*/

2017-05-21T14:11:00.873464Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '100026')) AND ((`id` <= '102574')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:00.875464Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '100026')) AND ((`id` <= '102574')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:00.935467Z 56 Query SHOW WARNINGS

2017-05-21T14:11:00.937468Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:00.939468Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '102575')) ORDER BY `id` LIMIT 3135, 2 /*next chunk boundary*/

2017-05-21T14:11:00.941468Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '102575')) ORDER BY `id` LIMIT 3135, 2 /*next chunk boundary*/

2017-05-21T14:11:00.943468Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '102575')) AND ((`id` <= '105710')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:00.945468Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '102575')) AND ((`id` <= '105710')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:01.302488Z 56 Query SHOW WARNINGS

2017-05-21T14:11:01.303488Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:01.307489Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '105711')) ORDER BY `id` LIMIT 3385, 2 /*next chunk boundary*/

2017-05-21T14:11:01.308489Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '105711')) ORDER BY `id` LIMIT 3385, 2 /*next chunk boundary*/

2017-05-21T14:11:01.311489Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '105711')) AND ((`id` <= '182997')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:01.313489Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '105711')) AND ((`id` <= '182997')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:01.396494Z 56 Query SHOW WARNINGS

2017-05-21T14:11:01.398494Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:01.401494Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '182998')) ORDER BY `id` LIMIT 4374, 2 /*next chunk boundary*/

2017-05-21T14:11:01.402494Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '182998')) ORDER BY `id` LIMIT 4374, 2 /*next chunk boundary*/

2017-05-21T14:11:01.404494Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '182998')) AND ((`id` <= '187372')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:01.407494Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '182998')) AND ((`id` <= '187372')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:01.608506Z 56 Query SHOW WARNINGS

2017-05-21T14:11:01.611506Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:01.614506Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '187373')) ORDER BY `id` LIMIT 5404, 2 /*next chunk boundary*/

2017-05-21T14:11:01.616506Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '187373')) ORDER BY `id` LIMIT 5404, 2 /*next chunk boundary*/

2017-05-21T14:11:01.619507Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '187373')) AND ((`id` <= '192777')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:01.621507Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '187373')) AND ((`id` <= '192777')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:02.552560Z 56 Query SHOW WARNINGS

2017-05-21T14:11:02.554560Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:02.557560Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '192778')) ORDER BY `id` LIMIT 4166, 2 /*next chunk boundary*/

2017-05-21T14:11:02.559560Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '192778')) ORDER BY `id` LIMIT 4166, 2 /*next chunk boundary*/

2017-05-21T14:11:02.562560Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '192778')) AND ((`id` <= '196944')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:02.563561Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '192778')) AND ((`id` <= '196944')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:03.868635Z 56 Query SHOW WARNINGS

2017-05-21T14:11:03.869635Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:03.873635Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '196945')) ORDER BY `id` LIMIT 2933, 2 /*next chunk boundary*/

2017-05-21T14:11:03.874636Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '196945')) ORDER BY `id` LIMIT 2933, 2 /*next chunk boundary*/

2017-05-21T14:11:03.877636Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '196945')) AND ((`id` <= '199878')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:03.878636Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '196945')) AND ((`id` <= '199878')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:03.951640Z 56 Query SHOW WARNINGS

2017-05-21T14:11:03.953640Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:03.955640Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '199879')) ORDER BY `id` LIMIT 3526, 2 /*next chunk boundary*/

2017-05-21T14:11:03.957640Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '199879')) ORDER BY `id` LIMIT 3526, 2 /*next chunk boundary*/

2017-05-21T14:11:03.959640Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '199879')) AND ((`id` <= '203405')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:03.961640Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '199879')) AND ((`id` <= '203405')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:04.049646Z 56 Query SHOW WARNINGS

2017-05-21T14:11:04.050646Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:04.053646Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '203406')) ORDER BY `id` LIMIT 4396, 2 /*next chunk boundary*/

2017-05-21T14:11:04.054646Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '203406')) ORDER BY `id` LIMIT 4396, 2 /*next chunk boundary*/

2017-05-21T14:11:04.057646Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '203406')) AND ((`id` <= '207802')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:04.059646Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '203406')) AND ((`id` <= '207802')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:04.237656Z 56 Query SHOW WARNINGS

2017-05-21T14:11:04.240656Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:04.243657Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '207803')) ORDER BY `id` LIMIT 5405, 2 /*next chunk boundary*/

2017-05-21T14:11:04.245657Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '207803')) ORDER BY `id` LIMIT 5405, 2 /*next chunk boundary*/

2017-05-21T14:11:04.248657Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '207803')) AND ((`id` <= '213208')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:04.250657Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '207803')) AND ((`id` <= '213208')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:04.749686Z 56 Query SHOW WARNINGS

2017-05-21T14:11:04.751686Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:04.755686Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '213209')) ORDER BY `id` LIMIT 5407, 2 /*next chunk boundary*/

2017-05-21T14:11:04.756686Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '213209')) ORDER BY `id` LIMIT 5407, 2 /*next chunk boundary*/

2017-05-21T14:11:04.759686Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '213209')) AND ((`id` <= '218616')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:04.761686Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '213209')) AND ((`id` <= '218616')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:07.003814Z 56 Query SHOW WARNINGS

2017-05-21T14:11:07.004815Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:07.008815Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '218617')) ORDER BY `id` LIMIT 2651, 2 /*next chunk boundary*/

2017-05-21T14:11:07.010815Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '218617')) ORDER BY `id` LIMIT 2651, 2 /*next chunk boundary*/

2017-05-21T14:11:07.012815Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '218617')) AND ((`id` <= '221268')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:07.014815Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '218617')) AND ((`id` <= '221268')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:07.077819Z 56 Query SHOW WARNINGS

2017-05-21T14:11:07.078819Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:07.081819Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '221269')) ORDER BY `id` LIMIT 3092, 2 /*next chunk boundary*/

2017-05-21T14:11:07.083819Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '221269')) ORDER BY `id` LIMIT 3092, 2 /*next chunk boundary*/

2017-05-21T14:11:07.085819Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '221269')) AND ((`id` <= '224361')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:07.087819Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '221269')) AND ((`id` <= '224361')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:07.166824Z 56 Query SHOW WARNINGS

2017-05-21T14:11:07.168824Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:07.170824Z 56 Query EXPLAIN SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '224362')) ORDER BY `id` LIMIT 3727, 2 /*next chunk boundary*/

2017-05-21T14:11:07.172824Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '224362')) ORDER BY `id` LIMIT 3727, 2 /*next chunk boundary*/

2017-05-21T14:11:07.173824Z 56 Query SELECT /*!40001 SQL_NO_CACHE */ `id` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) ORDER BY `id` DESC LIMIT 1 /*last upper boundary*/

2017-05-21T14:11:07.175824Z 56 Query EXPLAIN SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '224362')) AND ((`id` <= '225744')) LOCK IN SHARE MODE /*explain pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:07.177824Z 56 Query INSERT LOW_PRIORITY IGNORE INTO `test`.`_online_ddl_new` (`id`, `name`, `regdate`) SELECT `id`, `name`, `regdate` FROM `test`.`online_ddl` FORCE INDEX(`PRIMARY`) WHERE ((`id` >= '224362')) AND ((`id` <= '225744')) LOCK IN SHARE MODE /*pt-online-schema-change 39742 copy nibble*/

2017-05-21T14:11:07.331833Z 56 Query SHOW WARNINGS

2017-05-21T14:11:07.332833Z 56 Query SHOW GLOBAL STATUS LIKE 'Threads_running'

2017-05-21T14:11:07.336834Z 56 Query ANALYZE TABLE `test`.`_online_ddl_new` /* pt-online-schema-change */

2017-05-21T14:11:07.363835Z 56 Query RENAME TABLE `test`.`online_ddl` TO `test`.`_online_ddl_old`, `test`.`_online_ddl_new` TO `test`.`online_ddl`

2017-05-21T14:11:09.556961Z 56 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */

2017-05-21T14:11:09.557961Z 56 Query USE `test`

2017-05-21T14:11:09.558961Z 56 Query SHOW CREATE TABLE `test`.`online_ddl_f`

2017-05-21T14:11:09.559961Z 56 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */

2017-05-21T14:11:09.561961Z 56 Query ALTER TABLE `test`.`online_ddl_f` DROP FOREIGN KEY `online_ddl_f_ibfk_1`, ADD CONSTRAINT `_online_ddl_f_ibfk_1` FOREIGN KEY (`orderid`) REFERENCES `test`.`online_ddl` (`name`)

2017-05-21T14:11:10.804032Z 56 Query DROP TRIGGER IF EXISTS `test`.`pt_osc_test_online_ddl_del`

2017-05-21T14:11:10.899037Z 56 Query DROP TRIGGER IF EXISTS `test`.`pt_osc_test_online_ddl_upd`

2017-05-21T14:11:10.958041Z 56 Query DROP TRIGGER IF EXISTS `test`.`pt_osc_test_online_ddl_ins`

2017-05-21T14:11:10.962041Z 56 Query SHOW TABLES FROM `test` LIKE '\_online\_ddl\_new'

2017-05-21T14:11:10.965041Z 57 Quit

2017-05-21T14:11:10.966041Z 56 Quit

pt-online-change-ddl（在线ddl）

相关阅读