Unanswered: Communication link failure / mysqld.exe using 100% CPU
We have just starting using MySQL and have changed our site to using it rather than MS Access. It has been running fantastic, however on Friday morning at around 5am and then again on Sunday morning (today) at around 5am we started getting errors like:
java.sql.SQLException: Connection is closed
java.sql.SQLException: Connection.close() has already been called.
java.sql.SQLException: Communication link failure
The site became not accessible and when I checked the server mysqld.exe was using 100% CPU. As soon as I stop start MySQL - everything is back to running fine again. I have MySQL running as a NT Service - on Windows 2000 Server. I am using Tomcat 5.0.14, MySQL 4.0.18 and mysql-connector-java-3.0.11. I am also using connection pooling using Tomcat and JNDI. There are no errors in the MySQL logs.
Any advice would be much appreciated.
.... It just happened again!
I was using mysqld.exe and have just read about mysql-nt.exe mysql-max-nt.exe and have changed to using mysql-max-nt.exe. Any ideas if this will help or is better?