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