- Turn on slow query logging and review queries in this log (submit ticket if necessary to have us review)
- Check the following MySQL configuration variables on the server:
- wait_timeout - Ensure this is not too large. Generally 120 seconds (a value of 3600 for the setting) is a good starting point.
- connect_timeout - Ensure this is not too large
Run the following query and replace TABLE_NAME with the database table name that is corrupted.
Code Block title Repair Table Query
REPAIR TABLE `pmd_search_log`
If the query in step #1 fails and you have SSH access you may try the following command. We suggest disabling all traffic to the website before doing so.
mysqlcheck -r -u mysqlusername -p databasename
If the SSH command in step #2 fails we suggest shutting down or stopping MySQL and then running this command:
myisamchk -r -u root -p tablename