3 ms·
MySQL schema changes and pt-online-schema-change
- elbac 14y agoI've been using pt-online-schema-change for a few months ago. It is a godsend, you have to make sure however that your server can handle the load of copying all the data, IO and memory. Specifically that you have enough buffers to handle duplicating the table. It's great for rebuilding / reindexing tables.
- nupark2 14y agoOr, switch to PostgreSQL for new projects and stop throwing good money in after the bad.
- Gigablah 14y agoSo you're saying that PostgreSQL doesn't lock the table when changing the schema?