Re: Lost connection to MySQL server during query
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.
Subject
Written By
Posted
November 12, 2017 08:21PM
November 12, 2017 08:39PM
November 12, 2017 10:46PM
November 13, 2017 04:52AM
November 13, 2017 12:06PM
November 13, 2017 09:25PM
November 13, 2017 09:59PM
November 13, 2017 10:43PM
November 14, 2017 09:58AM
November 14, 2017 10:49AM
Re: Lost connection to MySQL server during query
November 14, 2017 11:25AM
November 14, 2017 11:51AM
November 14, 2017 12:13PM
November 14, 2017 12:24PM
November 14, 2017 12:30PM
November 14, 2017 01:11PM
November 14, 2017 01:16PM
November 14, 2017 01:40PM
November 14, 2017 02:11PM
November 14, 2017 02:13PM
November 14, 2017 02:22PM
November 14, 2017 03:50PM
November 14, 2017 04:41PM
November 14, 2017 04:08PM
November 14, 2017 05:11PM
November 14, 2017 06:53PM
November 14, 2017 06:56PM
November 14, 2017 06:59PM
November 14, 2017 07:00PM
November 14, 2017 09:47PM
November 19, 2017 06:50AM
November 14, 2017 12:21PM