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

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 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