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

MySQL> desc online_ddl;

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

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

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

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

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

3 rows in set (0.00 sec)

mysql> desc online_ddl_f;

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

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

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

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

2 rows in set (0.00 sec)

mysql> show create table online_ddl_f;

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

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

| Table | Create Table

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

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

| online_ddl_f | CREATE TABLE `online_ddl_f` (

`id` int(11) NOT NULL AUTO_INCREMENT,

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

PRIMARY KEY (`id`),

KEY `orderid` (`orderid`),

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

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

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

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

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

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

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

Operation, tries, wait:

analyze_table, 10, 1

copy_rows, 10, 0.25

create_triggers, 10, 1

drop_triggers, 10, 1

swap_tables, 10, 1

update_foreign_keys, 10, 1

Child tables:

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

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

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

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

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

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

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

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

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

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

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

Operation, tries, wait:

analyze_table, 10, 1

copy_rows, 10, 0.25

create_triggers, 10, 1

drop_triggers, 10, 1

swap_tables, 10, 1

update_foreign_keys, 10, 1

Child tables:

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

Will use the rebuild_constraints method to update foreign keys.

Altering `test`.`online_ddl`...

Creating new table...

Created new table test._online_ddl_new OK.

Altering new table...

Altered `test`.`_online_ddl_new` OK.

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

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

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

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

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

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

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

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

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

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

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

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

Successfully altered `test`.`online_ddl`.

root@ljd-python:~#

过程：

2017-05-21T14:10:39.708253Z 56 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）
文章出自：http://cqcxhl.com/article/pspecp.html

重庆分公司，新征程启航

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

其他资讯