有人使用pt-online-schema-change来改变一个包含1x百万条目的表吗？

I would like to get feedback experience on adding a column into a table with 1x million entries..

我希望获得有关将列添加到包含1x百万个条目的表中的反馈经验。

How long did it take ? was it truly without locking..

它花了多少时间 ?是真的没有锁定..

We are using mysql with innoDB..

我们正在使用mysql和innoDB ..

1 个解决方案

#1

Not with 1milion entries, but with 420k. Took something around 10 min. I believe it was without locking.

不是1milion条目,但有420k。大概10分钟左右。我相信它没有锁定。