Support Wissensdatenbank

Repair Mysql / MariaDB databases

It may happen that MySQL server has unusually high load. Or when checking the tables you get the message: “Mysql going away…” and the MySQL server suddenly restarts. This indicates that there are technical problems with the databases.

Please make sure that there is no hardware damage (memory, hard drives, motherboard defective).

journalctl | grep “marked as crashed and should be repaired” | tail
Checks if there are defective databases.
mysqlcheck -u admin -p`cat /etc/psa/.psa.shadow` –auto-repair –all-databases

All tables will be repairedservice mysql stop
myisamchk -s /var/lib/mysql/*/*.MYI (Prüft ob es MyISAM Fehler gibt)
myisamchk -o /var/lib/mysql/*/*.MYI (Repariert mit HASH die MyISAM)
myisamchk -r /var/lib/mysql/*/*.MYI (Repariert ohne HASH die MyISAM)
myisamchk -s /var/lib/mysql/*/*.MYI (Kontrolle)
journalctl | grep “marked as crashed and should be repaired” | tail
Should be empty now, if not, write down table names and then
cd /var/lib/mysql
find . -name ‘tablename*’
(Then log into Plesk and open the corresponding table under Tools & Settings => Databases Server => select database number => search for database => open database as end customer and click on repair)