前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >pt-online-schema-change 使用基础5

pt-online-schema-change 使用基础5

作者头像
franket
发布2022-05-03 11:58:23
1240
发布2022-05-03 11:58:23
举报
文章被收录于专栏:技术杂记

添加主键成功

代码语言:javascript
复制
[root@h101 ~]# pt-online-schema-change -u root -h localhost  -pmysql  --alter='add column newid char(20)  ' --execute D=pt,t=forpttest  
No slaves found.  See --recursion-method if host h101.temp has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
  copy_rows, 10, 0.25
  create_triggers, 10, 1
  drop_triggers, 10, 1
  swap_tables, 10, 1
  update_foreign_keys, 10, 1
Altering `pt`.`forpttest`...
Creating new table...
Created new table pt._forpttest_new OK.
Altering new table...
Altered `pt`.`_forpttest_new` OK.
2015-10-23T13:53:01 Creating triggers...
2015-10-23T13:53:01 Created triggers OK.
2015-10-23T13:53:01 Copying approximately 41 rows...
2015-10-23T13:53:01 Copied rows OK.
2015-10-23T13:53:01 Swapping tables...
2015-10-23T13:53:01 Swapped original and new tables OK.
2015-10-23T13:53:01 Dropping old table...
2015-10-23T13:53:01 Dropped old table `pt`.`_forpttest_old` OK.
2015-10-23T13:53:01 Dropping triggers...
2015-10-23T13:53:01 Dropped triggers OK.
Successfully altered `pt`.`forpttest`.
[root@h101 ~]# echo $?
0
[root@h101 ~]# 

已经添加好新列

代码语言:javascript
复制
mysql> desc forpttest;
+---------+----------+------+-----+---------+-------+
| Field   | Type     | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| id      | int(6)   | NO   | PRI | 0       |       |
| name    | char(10) | YES  |     | NULL    |       |
| comment | char(10) | YES  |     | NULL    |       |
| abc     | char(10) | YES  |     | NULL    |       |
| newid   | char(20) | YES  |     | NULL    |       |
+---------+----------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> 

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文系转载前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 添加主键成功
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档