Buy Percona ServicesBuy Now!

Unexpected slow ALTER TABLE in MySQL 5.7

and  | April 23, 2020 |  Posted In: Intermediate Level, MySQL, Percona Server for MySQL

Usually one would expect that ALTER TABLE with ALGORITHM=COPY will be slower than the default ALGORITHM=INPLACE. In this blog post we describe the case when this is not so. One of the reasons for such behavior is the lesser known limitation of ALTER TABLE (with default ALGORITHM=INPLACE) that avoids REDO operations. As a result, all […]

Read More