Есть VPS в облачном хостинге. Установлен обычный LAMP сервер (Ubuntu 18.04.4) без всяких GUI и панелей управления. Работают 3 сайта, все на WordPress.
Периодически возникает такая проблема:
Все сайты останавливаются, а Wordpress выдаёт сообщение о невозможности соединения с БД. Состояние MySQL отображается как inactive, а в логах появляются следующие строки (название БД скрыл, это имя домена):
2020-02-23T10:42:25.251717Z 2 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_posts' is marked as crashed and should be repaired
2020-02-23T10:42:25.251869Z 3 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_posts' is marked as crashed and should be repaired
2020-02-23T10:42:25.251968Z 17 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_posts' is marked as crashed and should be repaired
2020-02-23T10:42:25.260055Z 2 [Warning] Checking table: './%DATABASEMANE%/wp_posts'
2020-02-23T10:42:25.474721Z 13 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.474844Z 8 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.474928Z 9 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475004Z 10 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475079Z 12 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475152Z 4 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475230Z 5 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475342Z 7 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475421Z 16 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475499Z 20 [ERROR] /usr/sbin/mysqld: Table './%DATABASEMANE%/wp_options' is marked as crashed and should be repaired
2020-02-23T10:42:25.475699Z 13 [Warning] Checking table: './%DATABASEMANE%/wp_options'
Чаще всего проблема возникает в одной БД, хотя бывает, что и во всех трёх сразу. При этом в логах нет даже намёка, что вызывает сбой. Откуда стоит начинать поиски?