Is there anything more nerve wracking than running a database operation that you expect might be slow and that blocks all other access to the database until it’s complete, particularly when the database in question is in production? In this case, the command was alter table my_big_table type = innodb. I guess the good news is you only ever have to do it once.
Taking it slow
Is there anything more nerve wracking than running a database operation that you expect might be slow and that blocks all other access to the database until it’s complete, particularly when the database in question is in production? In this case, the command was
alter table my_big_table type = innodb
. I guess the good news is you only ever have to do it once.Commentary
Previous post
The state of the unionNext post
Improving MySQL performance on case-insensitve searches