| Subject | MySql, MariaDb ; Add column | 
|---|---|
| Author | |
| Post date | 2019-02-20T01:04:36Z | 
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