I am having a problem with my Virtual Private Server at a hosting company with mySQL crashing. It will basically randomly crash usually once or twice a day and restarts 5 minutes later. I spoke to the hosting company several times after performing checks, repairs, optimization on the database which does not seem to stop the issue. They keep telling me it's because of the table but I am unsure.
I am receiving the following error on the database ( i have xxxxx the database name and domain references):
Log Messages
2020-02-27 20:07:51 38 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_ipautobanhistory' is marked as crashed and should be repaired
2020-02-27 20:07:41 22 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_log' is marked as crashed and should be repaired
2020-02-27 20:07:27 8 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 20:07:27 10 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 20:07:27 11 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 20:07:25 0 [Note] /usr/sbin/mysqld: ready for connections.
2020-02-27 19:21:47 9 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 19:21:33 0 [Note] /usr/sbin/mysqld: ready for connections.
2020-02-27 19:11:49 398 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_log' is marked as crashed and should be repaired
2020-02-27 18:29:27 0 [Note] /usr/sbin/mysqld: ready for connections.
Memory Information
Used
2.21 GB
Available
740 MB
Installed
1.5 GB
Load Information
3.52 3.76 2.68
Uptime
36 days, 6 hours, 52 minutes, and 37 seconds
IOStat Information
avg-cpu: %user %nice %system %iowait %steal %idle 1.43 0.00 0.30 0.21 0.00 98.06 Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
Top Processes
PID
Owner
CPU %
Memory %
Command
13762
mysql
53.95
21.73
/usr/sbin/mysqld
14056
xxxxxxx
30.95
2.96
php-fpm: pool xxxxxxxx
14100
xxxxxxxx
25.06
3.09
php-fpm: pool xxxxxxxxx
14045
d1ff695
17.03
3.45
php-fpm: pxxxxxxxxxx
14037
xxxxxxxx
3.52
3.74
I am receiving the following error on the database ( i have xxxxx the database name and domain references):
Log Messages
2020-02-27 20:07:51 38 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_ipautobanhistory' is marked as crashed and should be repaired
2020-02-27 20:07:41 22 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_log' is marked as crashed and should be repaired
2020-02-27 20:07:27 8 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 20:07:27 10 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 20:07:27 11 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 20:07:25 0 [Note] /usr/sbin/mysqld: ready for connections.
2020-02-27 19:21:47 9 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_storage' is marked as crashed and should be repaired
2020-02-27 19:21:33 0 [Note] /usr/sbin/mysqld: ready for connections.
2020-02-27 19:11:49 398 [ERROR] mysqld: Table './xxxxxxx_xxxxxxxxx/dbps_admintools_log' is marked as crashed and should be repaired
2020-02-27 18:29:27 0 [Note] /usr/sbin/mysqld: ready for connections.
Memory Information
Used
2.21 GB
Available
740 MB
Installed
1.5 GB
Load Information
3.52 3.76 2.68
Uptime
36 days, 6 hours, 52 minutes, and 37 seconds
IOStat Information
avg-cpu: %user %nice %system %iowait %steal %idle 1.43 0.00 0.30 0.21 0.00 98.06 Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
Top Processes
PID
Owner
CPU %
Memory %
Command
13762
mysql
53.95
21.73
/usr/sbin/mysqld
14056
xxxxxxx
30.95
2.96
php-fpm: pool xxxxxxxx
14100
xxxxxxxx
25.06
3.09
php-fpm: pool xxxxxxxxx
14045
d1ff695
17.03
3.45
php-fpm: pxxxxxxxxxx
14037
xxxxxxxx
3.52
3.74
