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: MySQL optimisation  (Read 1860 times)

0 Members and 1 Guest are viewing this topic.

SpikeTheLobster

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
MySQL optimisation
« on: November 23, 2012, 05:59:10 pm »

Hello folks. I've hunted around for info on this but the response is always: search the board for "MySQL said: Too many connections"

I do that and it brings up the threads where the answer is search the board for "MySQL said: Too many connections"  :o

My problem is that I have a Coppermine board with user uploads that was working alright until my traffic went through the roof. Now the site hammers the MySQL server until it falls over, taking 30+ other sites with it (all on the same VPS).

Can someone point me at information to help me rein in the site, please? Assuming there is some. :)
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: MySQL optimisation
« Reply #1 on: November 23, 2012, 11:38:49 pm »

No well setup server should crash because of too many connections. Tell your host to look into it, they should be able to make the required adjustments. If not find a host or hosting package that can deal with your load.
Logged
It is a mistake to think you can solve any major problems just with potatoes.
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 19 queries.