Question SQL Server

[UHolthausen]

Hello

Yesterday Plesk was very slow in building pages and I found this in Myysql log:
2020-03-01 7:41:45 139776344763776 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired
2020-03-01 7:41:45 139776344763776 [Warning] Checking table: './mysql/user'
2020-03-01 7:41:45 139776344763776 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly
2020-03-01 7:41:46 139776344763776 [ERROR] mysqld: Table './mysql/db' is marked as crashed and should be repaired
First I checked the system by diagnosis&repair, everything ok (green)
To be on the safe side also by Ppmyadmin then the affected database checked.
No errors were displayed, also per cli everything ok.
Nevertheless I stopped the SQL Server and restarted it. Result: still long loading times.
The loading time was long the whole day. In the evening the same error message appeared in the mysql log.
I let it go for now, this morning everything was ok again.
What could be the reason? The server was online for 21 days.
System:
Operating system: Debian 9.12
Plesk: 17.8.11 incl. last update
mysql Ver 15.1 Distrib 10.1.44-MariaDB

 

[IgorG]

Try to repair this table at least with something like

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Ne 'REPAIR TABLE example_db.corrupted_table'

I hope it will help.

 

[UHolthausen]

Hello


Thanks, i check it today.