I have been working with a rather large blog http://www.elephantjournal.com and on a very random basis we get the error "Error establishing database connection" but if you immediately hit refresh, the site appears. This happens both on the public facing site and the WordPress admin area.
I have read many other posts in the forum but none of them seem to be the same - they all seem to be that they couldn't connect at all, whilst I can connect, however get this random message.
I wonder if it could be anything to do with the number of database connections?
I ran the site through Xenu this morning (checks all links and images are there) and at the same time viewing the process list in MySQL, and noticed that on many occassions the process count gets to 5 or 6. This is very light usage, and with the number of people probably viewing it as well it's no more than 100 people at this time in the morning.
I have increased the number of max connections allowed to MySQL and hope this will solve it, but I posted here just to see if anyone else has had the same issue.
WordPress : 2.9.2
Host : media temple
MySQL Version : 5.0.77
Thanks if you have any other suggestions.