Pt-online-change-ddl (online ddl) 03/26 Update SLTechnology News&Howtos

Pt-online-change-ddl (online ddl)

2025-03-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

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

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.

When you find an error, you are prompted to have a table: online_ddl_log has a foreign key reference table online_ddl, and you need to use the-- alter-foreign-keys-method parameter to indicate the operation of the foreign key.

-- the values of alter-foreign-keys-method can be: auto, rebuild_constraints, drop_swap, none

1. When the volume of business is large, the modification operation will wait for the final rename operation to be performed after no data modification. Therefore, when modifying the table structure, you should try to choose a more appropriate execution when the business is relatively idle, at least when the data operation on the table is relatively low.

2. If the foreign key table operation, the four foreign key operation types need to be selected according to the amount of data and reliability of the table. For reliability reasons, try to use the rebuild_constraints type, and if there is no reliability requirement, you can use the auto type.

3. When-- alter-foreign-keys-method=none, the foreign key index will fail, and the foreign key index needs to be rebuilt before it can be used again.

4. Because there may be some risks, it is recommended to back up the data table before the operation, which can make the operation more safe and reliable.

Add the-- alter-foreign-keys-method parameter, and execute again:

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:~#

Process:

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

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

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 `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 `test`.`online _ ddl` FOR EACH ROW REPLACE INTO `test`.` _ online_ddl_ new` (`id`, `name`, `regdate`) VALUES (NEW.`name`, NEW.`name`, NEW.`regdate`)

2017-05-21T14:10:41.934381Z 56 Query EXPLAIN SELECT * FROM `test`.`online _ ddl` WHERE 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` =' 11995') AND ((`id` = '12995')) ORDER BY `id` LIMIT 674,2 / *

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` =' 12995') AND ((`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` =' 13670') AND ((`id` = '14553')) ORDER BY `id` LIMIT 1093, 2 / *

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` =' 14553') AND ((`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` =' 15647') AND ((`id` = '16646')) ORDER BY `id` LIMIT 1089, 2 / *

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` = '16646') AND ((`id` = '17736')) ORDER BY `id` LIMIT 576,2 / *

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` =' 17736') AND ((`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` =' 18313') AND ((`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` =' 18972') AND ((`id` = '19441')) ORDER BY `id` LIMIT 389,2 / *

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` =' 19441') AND ((`id` = '19831')) ORDER BY `id`LIMIT 463,2 / *

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` =' 19831') AND ((`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` =' 20295') AND ((`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` = '20876') AND ((`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` =' 21649') AND ((`id` = '22631')) ORDER BY `id` LIMIT 1444, 2 / *

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` =' 22631') AND ((`id` = '24076')) ORDER BY `id` LIMIT 2249, 2 / *

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` =' 24076') AND ((`id` = '26326')) ORDER BY `id` LIMIT 3705, 2 / *

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` =' 26326') AND ((`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` =' 30032') AND ((`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` =' 31182') AND ((`id` = '50483')) ORDER BY `id` LIMIT 1710, 2 / *

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` =' 50483') AND ((`id` = '52194')) ORDER BY `id` LIMIT 2256, 2 / *

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` =' 52194') AND ((`id` = '54451')) ORDER BY `id` LIMIT 3126, 2 / *

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` =' 54451') AND ((`id` = '57578')) ORDER BY `id` LIMIT 4504, 2 / *

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` =' 57578') AND ((`id` = '62083')) ORDER BY `id` LIMIT 5067, 2 / *

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` =' 62083') AND ((`id` = '67151')) ORDER BY `id` LIMIT 3897, 2 / *

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` =' 67151') AND ((`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` =' 71049') AND ((`id` = '72963')) ORDER BY `id` LIMIT 2212, 2 / *

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` =' 72963') AND ((`id` = '75176')) ORDER BY `id` LIMIT 1869, 2 / *

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` =' 75176') AND ((`id` = '77046')) ORDER BY `id` LIMIT 2148, 2 / *

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` =' 77046') AND ((`id` = '79195')) ORDER BY `id` LIMIT 2658, 2 / *

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` =' 79195') AND ((`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` = '81854') AND ((`id` =' 85294')) ORDER BY `id` LIMIT 4269, 2 / *

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` =' 85294') AND ((`id` = '89564')) ORDER BY `id` LIMIT 5865, 2 / *

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` =' 89564') AND ((`id` = '95430')) ORDER BY `id` LIMIT 2432, 2 / *

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` =' 95430') AND ((`id` = '97863')) ORDER BY `id` LIMIT 2162, 2 / *

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` =' 97863') AND ((`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` =' 100026') AND ((`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` =' 102575') AND ((`id` = '105711')) ORDER BY `id` LIMIT 3385, 2 / *

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` =' 105711') AND ((`id` = '182998')) ORDER BY `id` LIMIT 4374, 2 / *

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` =' 182998') AND ((`id` = '187373')) ORDER BY `id` LIMIT 5404, 2 / *

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` =' 187373') AND ((`id` = '192778')) ORDER BY `id` LIMIT 4166, 2 / *

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` =' 192778') AND ((`id` = '196945')) ORDER BY `id` LIMIT 2933, 2 / *

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` =' 196945') AND ((`id` = '199879')) ORDER BY `id` LIMIT 3526, 2 / *

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` =' 199879') AND ((`id` = '203406')) ORDER BY `id` LIMIT 4396, 2 / *

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` =' 203406') AND ((`id` = '207803')) ORDER BY `id` LIMIT 5405, 2 / *

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` =' 207803') AND ((`id` = '213209')) ORDER BY `id` LIMIT 5407, 2 / *

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` =' 213209') AND ((`id` = '218617')) ORDER BY `id` LIMIT 2651, 2 / *

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` =' 218617') AND ((`id` = '221269')) ORDER BY `id` LIMIT 3092, 2 / *

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` =' 221269') AND ((`id` = '224362')) ORDER BY `id` LIMIT 3727, 2 / *

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` =' 224362') AND ((`id`)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.