Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Error "mysql: said too many connections"  (Read 17870 times)

0 Members and 1 Guest are viewing this topic.

kingspice

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 61
Error "mysql: said too many connections"
« 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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Error "mysql: said too many connections"
« Reply #1 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
Logged

kingspice

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 61
Error "mysql: said too many connections"
« Reply #2 on: February 20, 2004, 03:46:05 am »

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

Think maybe 75,000 views of pics a day
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Error "mysql: said too many connections"
« Reply #3 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
Logged

kingspice

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 61
Error "mysql: said too many connections"
« Reply #4 on: February 20, 2004, 03:29:31 pm »

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

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Error "mysql: said too many connections"
« Reply #5 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.
Logged
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

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Error "mysql: said too many connections"
« Reply #6 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!
« Last Edit: November 05, 2008, 10:51:10 am by Pycckuu »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error "mysql: said too many connections"
« Reply #7 on: November 05, 2008, 10:56:37 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.