We have a dedicated server with a virtual instance running the application server with Apache, PHP and a virtual instance with DB on it. We are running Magento 1.7.0 version on the application server and MySql as the DB. For some reason the site appears to go down atleast 3-4 times a day.
During the time Magento is down with an error of "Can't connect to Mysql server", Apache seems ok, with it not being overloaded. The mysql server also seems to be in good health with no overloading and not many procesess. If you try to connect from the Magento instance to the DB server via the mysql command it takes a while for the command to be executed. We have checked all the network parameters and all seem fine.
Kindly let me know if you have any suggestions.