Dear forum members,
I have the following problem:
since the upgrade of my website http://www.magicofword.com from Drupal 5.x to Drupal 7.x I frequently get the following error message when trying to access the website via my browser:
PDOException: SQLSTATE[HY000]  Can't connect to local MySQL
server through socket '/var/run/mysqld/mysqld.sock' (2) in
lock_may_be_available() (line 167 of /is/htdocs/wp1048090_8JCEI180MP/drupal7/
It seems like the connection to the database server is lost. After a while, without doing anything, the website does load again. The problem really is annoying as the visitors expect a reliable and stable website. Further, may the search engine not find my website with a detrimental effect to the SE rankings.
First, I have checked the access information in the file /drupal7/sites/default/settings.php. They are correct. However, sometimes I cannot login to my database through PHPMyAdmin with these login details. Sometimes, it takes a long time for the connection to establish. This is unusual.
I have already got in touch with my hosting company. According to them, there is no unusal activity and everything is deemed to work as it should.
Is there the possibility that the website generates too many database requests at a time and causes the connection to crash?
What can I do to solve the issue?
Thanks a lot for your feedback!! It is much appreciated.