Error "mysql: said too many connections"

[kingspice]

Sometimes at busy times i get the error

"Coppermine Critical Error

mysql: said too many connections"

My provider "claims" there is no mysql limit on the server. Does coppermine have a certain limit to the amount of connections?

Thanks
Gareth

[Joachim Müller]

afaik there's no limit for mySQL connections on coppermine - maybe your webhost isn't actually lying, but doesn't know either (I would if I were in his place :wink: ).
Please post a link to your site and some estimated average traffic...

GauGau

[kingspice]

bump,
http://www.britneyzone.com/coppermine

Think maybe 75,000 views of pics a day

[Joachim Müller]

There's too much stuff on your start page. Try reducing the detail level of your start page - there are way too many queries necessary to generate that page!

GauGau

[kingspice]

Are there any specific queries i should reduce/remove, which use up the most resources?

[Casper]

Hi,
you have 9 categories, each showing 8 album thumbs, as well as last up (8), random (4), last additions(8) and top rated (4).

I would start by reducing each category, and each meta album, to 4.

[Pycckuu]

Can you please look at my page, since i have the same problem over there:

http://covers.kinoman.org/index.php

Any suggestions - in fact i have tons of albums and a lot of categories showing on main page!

I have Coppermine Photo Gallery 1.4.19 (stable) there!

[Joachim Müller]

I have Coppermine Photo Gallery 1.4.19 (stable) there!

Then why on earth did you reply to a thread that referes to an old version of coppermine for which the support has run out. Review board rules and do as suggested there. Locking.