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.
--all-databases --fast --silent
. Use InnoDB which is fault tolerant. Ensure to give it a decent innodb_buffer_pool_size, defaults are usually too small.SHOW GLOBAL STATUS LIKE 'innodb_buffer_pool%
and see how much is used and how much churn there is. At 100% used with a small amount of churn is ideal.innodb_buffer_pool_size
should be set to 70% of available RAM when using only InnoDB.