forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: kingspice on February 10, 2004, 12:28:49 am

Title: Error "mysql: said too many connections"
Post by: kingspice on February 10, 2004, 12:28:49 am

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

Title: Error "mysql: said too many connections"
Post by: Joachim Müller on February 11, 2004, 12:25:25 am

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

Title: Error "mysql: said too many connections"
Post by: kingspice on February 20, 2004, 03:46:05 am

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

Think maybe 75,000 views of pics a day

Title: Error "mysql: said too many connections"
Post by: Joachim Müller on February 20, 2004, 01:26:58 pm

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

Title: Error "mysql: said too many connections"
Post by: kingspice on February 20, 2004, 03:29:31 pm

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

Title: Error "mysql: said too many connections"
Post by: Casper on February 20, 2004, 03:52:27 pm

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.

Title: Re: Error "mysql: said too many connections"
Post by: Pycckuu on November 05, 2008, 10:43:45 am

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!

Title: Re: Error "mysql: said too many connections"
Post by: Joachim Müller on November 05, 2008, 10:56:37 am

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 (http://forum.coppermine-gallery.net/index.php/topic,55415.0.html) and do as suggested there. Locking.