Instant ADD COLUMN, Until a FULLTEXT Index Shows Up: A MariaDB Migration That Froze Writes
DEV Community
Instant ADD COLUMN, Until a FULLTEXT Index Shows Up: A MariaDB Migration That Froze Writes
Adding a column is usually instant in MariaDB and MySQL. With a FULLTEXT index on the table it becomes a full rebuild that blocks writes. A reproduction with timings, and two migration habits that prevent it.
0 comments
No comments yet.