MySQL Forums
Forum List  »  Newbie

Re: Lost connection to MySQL server during query
Posted by: Peter Brawley
Date: November 14, 2017 11:25AM

If the simple queries I suggested crash MySQL, it's effectively unusable.

A thousand error log entries like ...

> InnoDB: Database page corruption on disk or a failed
> InnoDB: file read of page 1.
> InnoDB: You may have to recover from a backup.

... confirm that you system is not just unusable, the problems are creating more corruption the longer it runs. You have an emergency.

1, run free -m and post the result here (your system is very likely doing a lot of swapping).

2, stop all apps that are issuing queries.

3, run the diagnostic queries I suggested, post the results here.

4. Run Check Table on all tables, drop and re-use indexes for tables where Check Table reports ok, try to fix the bad tables (https://www.percona.com/blog/2008/07/04/recovering-innodb-table-corruption/
) or restore them from backups. While you are doing that, I'll run analysis on your diagnostic results and post the results.

Options: ReplyQuote


Subject
Written By
Posted
Re: Lost connection to MySQL server during query
November 14, 2017 11:25AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.