Is there a way to have mariadb check tables in the background and not lock the tables after a crash? We have a number of fairly large databases and suffered a hardware failure that resulted in most of them checking tables on a restart which unfortunately blocked access to the databases for hours.
I get that a check is a good thing, however of all the databases, only one ended up needing to be fixed.
Ta.
Peter.
Best Answer
Avoid the problem by switching your table from MyISAM to InnoDB.