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

优化在线改表的使用时机 #590

Closed
hjweddie opened this issue Jul 20, 2023 · 3 comments
Closed

优化在线改表的使用时机 #590

hjweddie opened this issue Jul 20, 2023 · 3 comments
Labels
enhancement New feature or request

Comments

@hjweddie
Copy link
Contributor

描述您想要的功能:
MySQL已有原生支持Online DDL。 希望能判断SQL是否能符合 Only Modifies Metadata, 符合的话,直接提交到MySQL执行。

现实中可能有数据量较大的表,需要删除其中一个索引的时候,走pt-osc等在线改表工具,会重建整张大表,时间和性能消耗较大,这消耗也不必要。如果直接提交MySQL的话,能接近马上完成,对数据库的消耗会低非常多

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

可参考文档,资料,引用等:
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html

@kimiliang123
Copy link

#258
参考这个呗,可以自己设置的

@hjweddie
Copy link
Contributor Author

@hjweddie
Copy link
Contributor Author

这个issue看起来可以关了

@hanchuanchuan hanchuanchuan added the enhancement New feature or request label Jul 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants