Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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:       
    1. wait_timeout - Ensure this is not too large.  Generally 120 seconds (a value of 3600 for the setting) is a good starting point.
    2. connect_timeout - Ensure this is not too large

...

  1. Run the following query and replace TABLE_NAME with the database table name that is corrupted.

    Code Block
    titleRepair Table Query
    REPAIR TABLE `pmd_search_log`


  2. 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.

    Code Block
    mysqlcheck -r -u mysqlusername -p databasename 


  3. If the SSH command in step #2 fails we suggest shutting down or stopping MySQL and then running this command:

    Code Block
    myisamchk -r -u root -p tablename