ALGORITHM=INPLACE does not mean lock-free, and the operation that needed a table rebuild took a metadata lock at the end anyway. Specifying LOCK=NONE turns an unpleasant surprise into…
High-Performance Order Storage moves orders out of the posts table, and the compatibility mode that writes to both is the part to plan around. The four queries were…
Adding a nullable column is instant in 8.0; filling it for four million existing rows is not. Three steps instead of one — add nullable, backfill, tighten —…