Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Error "mysql: said too many connections"  (Read 17871 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.031 seconds with 18 queries.