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
