Changing a table with a hundred million rows used to mean locking it for hours. Modern MySQL can often make the same change in milliseconds, or while the app keeps reading and writing. The trick is knowing which kind of change you are about to run.