Error "mysql: said too many connections" Error "mysql: said too many connections"
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Error "mysql: said too many connections"

Started by kingspice, February 10, 2004, 12:28:49 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

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


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.
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

Pycckuu

#6
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

Quote from: Pycckuu on November 05, 2008, 10:43:45 AM
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.