Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

pt-online-schema-change 中 rename 操作设置超时时间 #214

Closed
jianhaiqing opened this issue May 16, 2020 · 5 comments
Closed

pt-online-schema-change 中 rename 操作设置超时时间 #214

jianhaiqing opened this issue May 16, 2020 · 5 comments

Comments

@jianhaiqing
Copy link
Contributor

描述您想要的功能:
在pt-osc 中加上 两个选项如下, 目标是获取meta lock,或 innodb lock 超时,避免默认的60s 超时,造成影响范围过大
--set-vars lock_wait_timeout=3,innodb_lock_wait_timeout=1

描述您考虑过的解决/替代方案:

--set-vars lock_wait_timeout=3,innodb_lock_wait_timeout=1

可参考文档,资料,引用等:
https://www.percona.com/doc/percona-toolkit/3.0/pt-online-schema-change.html

@hanchuanchuan
Copy link
Owner

感兴趣的话可以参考 #172 来添加一个pt-osc参数.

@jianhaiqing
Copy link
Contributor Author

好的,老板,我明天来加,谢谢老板指导

@hhyo
Copy link
Contributor

hhyo commented May 22, 2020

发现普通的ddl执行也可以考虑加一个这个配置,避免异常场景下受到某些未提交的事务影响

@jianhaiqing
Copy link
Contributor Author

发现普通的ddl执行也可以考虑加一个这个配置,避免异常场景下受到某些未提交的事务影响

嗯,说的对,我看怎么加一下

@bruse-peng
Copy link

工具是自动集成了pt-online-schema-change在实行sql的时候使用pt-online-schema-change吗?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants