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: Coppermine overloading mysql server  (Read 4034 times)

0 Members and 1 Guest are viewing this topic.

mephit

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Coppermine overloading mysql server
« on: October 23, 2007, 06:56:57 am »
I am having an issue now. My gallery is overloading my hosts mysql server, this is the first time in 3 months.
I am told that I had 200 connections to my gallery which caused a 90% cpu capacity.
I am not sure what to do, unless I follow what they say and get a VPS which is not in the budget.
If more info is needed them please let me know. I would like to resolve this.

My Gallery
http://render-spot.com/gallery/index.php
« Last Edit: October 26, 2007, 09:34:07 am by GauGau »
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: Coppermine overloading mysql server
« Reply #1 on: October 23, 2007, 07:22:29 am »
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

mephit

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Coppermine overloading mysql server
« Reply #2 on: October 23, 2007, 07:50:59 am »
That one did not show up in my search. Thank you for the point out.
I will read and see if it will help.
Thank you.
Logged

mephit

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Coppermine overloading mysql server
« Reply #3 on: October 23, 2007, 07:53:19 am »
All it says its to disable random meta albums. I would need more info on this before doing anything.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Coppermine overloading mysql server
« Reply #4 on: October 23, 2007, 08:25:25 am »
Logged

mephit

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Coppermine overloading mysql server
« Reply #5 on: October 23, 2007, 09:28:31 pm »
Stramm what does that have to do with this case?
I know how to remove the random images and last upload.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Coppermine overloading mysql server
« Reply #6 on: October 23, 2007, 09:52:52 pm »
That's how to disable the random images

Quote
All it says its to disable random meta albums. I would need more info on this before doing anything.
Logged

mephit

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Coppermine overloading mysql server
« Reply #7 on: October 24, 2007, 02:08:20 am »
OK, I understand that. Will this lower the number of open mysql inquiries?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Coppermine overloading mysql server
« Reply #8 on: October 25, 2007, 12:35:02 pm »
Yes, this will reduce the number of database queries.
Logged

mephit

  • Coppermine newbie
  • Offline Offline
  • Posts: 9
Re: Coppermine overloading mysql server
« Reply #9 on: October 26, 2007, 12:16:53 am »
ok thank you. I guess I will see how this goes for now.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.02 seconds with 20 queries.