Mariadb check tables on startup

mariadb

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.