I have a few servers running WordPress. I am using IIS with MySQL. One keeps faulting; I reset the MySQL server and it works well for a few hours and after that I start getting "Error establishing a database connection".
The MySQL is up and I can log in to it as root or regular user, locally or remotely. I see nothing special in
SHOW PROCESSLIST;, but the aborted connections do increase.
I'm running on a Win2008R2; my other servers are MUCH busier - the one that is not working is my QA server. I copied the my.ini configuration from the working servers to make sure this server can handle as many connections (initially it was set much lower as it is not production; in the installation I also chose DEV server and not production server), but it doesn't help. Another thing that helps is
mysqladmin flush-hosts from the command line.
Where should I look? What should I do?...