Waldo JaquithI'm trying to add a new column to a large table in MariaDB, but it keeps timing out, and now I think I have to increase the size of my RDS instance, add the row, and decrease my RDS instance again. 🙄
Scott Frazer@waldoj on the plus side, that’s possible 😄 imagine where you be with a physical server (some of the longest nights of my life involved physical MySQL servers)
Ian Dees@waldoj I remember having to write some code that created a new version of the table with the column, incrementally copied the data to the new table w/ column, and then swapped the table name. This was 14 years ago and MySQL. I would hope they improved it...
jeff cornejo@waldoj back in the day I used Percona tools to modify schema w/o locking the table.