These are unfortunately frequent for me:
Could not connect: Too many connections
Please stand-by for a while and retry.
I suggested a solution
here, but it seems to have been missed. The mysql_pconnect() function.
(Also, moving from PHP to some other language and FastCGI should improve the site's performance, may require a bit too much of effort to accomplish though.)
I also experience problems with the site not reacting for a few minutes sometimes. I never get an error message though.
For other improvements on performance, if the gzip/deflate thing is in use, I'd suggest using compression level 2 over anything higher. The system resources needed to accomplish anything higher go way over the benefits in compression ratio.
I did a lot of optimizations, for example caching the most common (or the heaviest) results, reducing dramatically the overall number of queries.
Sadly the reason for these problems is different.
The real problem is that the web server is hosting another site that has
seven times the activity of UVL.
What's worse, it isn't a finely coded site, but a
junk made using Php-Nuke CMS, so that "seven" should multiplied by 4 at least..
Junk ... I'm playing Wii Scarface these days so my dictionary is full of Tony Montana words-style, I'm doing my best to be polite ;-)
The obvious "next step" should be to find a better hosting solution, but the server and "that" site is maintained by a my colleague, and he is finely rewriting it from scratch, using another database engine (I designed the new graphics too, and this pays the UVL hosting) so when ready, I'm quite sure this choppiness will end.
I would love to have a my own server, but I've no idea how to properly configure a web server, and right now the bandwidth used is 40 gigabyte / month (and growing).
I've not yet found a good hosting solution with so much bandwidth and a "we'll configure and manage it for you" at an accessible price...
I'm sorry for these inconveniences.
I've just (insanely) signed for a MY OWN web account at
www.hostmonster.com PHP5, FastCGI and a ton of features... Can't wait to see how it behaves.