Subject MySql, MariaDb ; Add column
Author

Hi Everyone, 


Today I wanted to add a column to a large MariaDb table and  the server died after 2 hours with a corrupt database file, which I could not repair. I was lucky(precautionary) so I the replication saved me.


I learned that Mariadb&MySql creates a new table with the new column and copies the original table to it when adding a column, in most cases. I think this is awful for huge tables.


How does Firebird do it internally?


Sincerely