MySQL> desc online_ddl;

成都创新互联公司服务项目包括德惠网站建设、德惠网站制作、德惠网页制作以及德惠网络营销策划等。多年来，我们专注于互联网行业，利用自身积累的技术优势、行业经验、深度合作伙伴关系等，向广大中小型企业、政府机构等提供互联网行业的解决方案，德惠网站推广取得了明显的社会效益与经济效益。目前，我们服务的客户以成都为中心已经辐射到德惠省份的部分城市，未来相信会继续扩大服务区域并继续获得客户的支持与信任！

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

| Field   | Type         | Null | Key | Default           | Extra          |

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

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

| name    | varchar(500) | YES  | UNI | NULL              |                |

| regdate | datetime     | YES  |     | CURRENT_TIMESTAMP |                |

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

3 rows in set (0.00 sec)

mysql> desc online_ddl_f;

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

| Field   | Type        | Null | Key | Default | Extra          |

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

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

| orderid | varchar(50) | YES  | MUL | NULL    |                |

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

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 参数，再次执行：

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 --alter-foreign-keys-method=rebuild_constraints

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 Connectroot@192.168.0.12 on test using TCP/IP

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

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

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

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

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

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

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

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

2017-05-21T14:10:39.732255Z   56 QuerySET @@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 QuerySELECT @@server_id /*!50038 , @@hostname*/

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

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

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

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

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

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

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

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

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

2017-05-21T14:10:39.754256Z   57 QuerySET @@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 QuerySELECT @@server_id /*!50038 , @@hostname*/

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

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

2017-05-21T14:10:39.764256Z   56 QuerySHOW ENGINES

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

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

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

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

2017-05-21T14:10:39.778257Z   56 QuerySHOW PROCESSLIST

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

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

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

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

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

2017-05-21T14:10:39.792258Z   56 QuerySHOW 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 QueryUSE `test`

2017-05-21T14:10:39.795258Z   56 QuerySHOW 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 QueryEXPLAIN SELECT * FROM `test`.`online_ddl` WHERE 1=1

2017-05-21T14:10:39.800259Z   56 QuerySELECT 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 QueryEXPLAIN SELECT * FROM `test`.`online_ddl_f` WHERE 1=1

2017-05-21T14:10:39.931266Z   56 QuerySHOW 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 QueryUSE `test`

2017-05-21T14:10:39.938266Z   56 QuerySHOW 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 QueryCREATE 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 QueryALTER 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 QueryUSE `test`

2017-05-21T14:10:41.172337Z   56 QuerySHOW 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 QueryCREATE 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 QueryCREATE 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 QueryCREATE 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 QueryEXPLAIN SELECT * FROM `test`.`online_ddl` WHERE 1=1

2017-05-21T14:10:41.940381Z   56 QuerySELECT /*!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 QuerySELECT /*!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 QueryEXPLAIN SELECT /*!40001 SQL_NO_CACHE */ * FROM `test`.`online_ddl` FORCE INDEX (`PRIMARY`) WHERE `id` >= '11995' /*key_len*/

2017-05-21T14:10:41.960382Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:42.718425Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:42.995441Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:43.274457Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:43.894493Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:44.282515Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:46.122620Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:46.309631Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:47.717711Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:48.812774Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:48.845776Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:48.867777Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:48.891779Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:49.059788Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:49.105791Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:49.172795Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:49.253799Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:51.983955Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:52.024958Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:52.068960Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:52.118963Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:52.189967Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:52.285973Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:52.663994Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:53.567046Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:55.912180Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:55.990185Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:56.977241Z   56 QueryEXPLAIN 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 QuerySELECT /*!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 QueryEXPLAIN 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 QueryINSERT 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 QuerySHOW WARNINGS

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

2017-05-21T14:10:57.124249Z   56 QueryEXPLAIN 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*/

当前题目：pt-online-change-ddl（在线ddl）
当前URL：http://csdahua.cn/article/pspecp.html