Aikesheng Open Source Community
Jun 24, 2025 · Databases
Why MySQL 8.0 Table Rebuilds Slow Down and How to Fix It
MySQL 8.0 (especially versions 8.0.20+) suffers a performance regression in table‑rebuilding operations like ALTER TABLE … FORCE, running up to three times slower than 5.7 due to the default innodb_doublewrite_pages setting, but the issue can be mitigated by adjusting the parameter or upgrading to 8.4+.
ALTER TABLEMySQLdatabase tuning
0 likes · 4 min read