mysql 删除分区很慢_mysql分区尾部添加分区非常慢？

最新推荐文章于 2021-11-21 15:40:13 发布

黑猫厨房

最新推荐文章于 2021-11-21 15:40:13 发布

阅读量473

点赞数

文章标签： mysql 删除分区很慢

本文链接：https://blog.csdn.net/weixin_29793473/article/details/113321493

版权

本文探讨了MySQL中ALTER TABLE操作的性能瓶颈，重点讲解COPY与INPLACE算法的区别。COPY方法虽然会复制数据，但适合副本已存在的场景；INPLACE则在原地操作，可能导致短暂的元数据锁定，通常支持并发DML。了解这些有助于排查和优化数据库操作速度。

摘要由CSDN通过智能技术生成

。。。建议看看show processlist 你就知道为啥慢了至于你说的后面几个快，副本已经复制了省去了这个步骤

Performance and Space Requirements

ALTER TABLE operations are processed using one of the following algorithms:

COPY: Operations are performed on a copy of the original table, and table data is copied from the original table to the new table row by row. Concurrent DML is not permitted.

INPLACE: Operations avoid copying table data but may rebuild the table in place. An exclusive metadata lock on the table may be taken briefly during preparation and execution phases of the operation. Typically, concurrent DML is supported.

The ALGORITHM clause is optional. If the ALGORITHM clause is omitted, MySQL uses ALGORITHM=INPLACE for storage engines andALTER TABLE clauses that support it. Otherwise, ALGORITHM=COPY is used.