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: Coppermine overloading mysql server  (Read 4035 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.031 seconds with 19 queries.