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 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://pwwzsj.com/article/pspecp.html