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: High CPU usage  (Read 4434 times)

0 Members and 1 Guest are viewing this topic.

chagnee

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
High CPU usage
« on: August 21, 2007, 12:08:57 am »
Hello, my Coppermine gallery is hosted at Resellerspanel where we have a daily limit of 4.5% CPU usage. I've been receiving notifications constantly saying that I'm using too much CPU (11%, 23% and so on). They told me to "optimize my database" but I honestly have no idea what they mean by that.

So far, I figured out that it's best to resize my HQ images myself and upload them as normal_Picturename.jpg in order to save some CPU usage. But that's about it. Can anyone explain to me how I can optimize the database itself and avoid such high CPU usage? Thanks a bunch!!
« Last Edit: August 22, 2007, 10:24:33 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: High CPU usage
« Reply #1 on: August 21, 2007, 08:10:46 am »
Post a link to your gallery for a start.
Logged

chagnee

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: High CPU usage
« Reply #2 on: August 21, 2007, 09:41:17 am »
Oh darn, I thought I had done that... Stupid me. This is the link: http://track-back.com/gallery/
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: High CPU usage
« Reply #3 on: August 21, 2007, 10:16:49 am »
1) You're running cpg1.4.10, while the most recent stable release is cpg1.4.12 - upgrade!
2) Turn "most recent" off
3) Disable stats - see http://forum.coppermine-gallery.net/index.php?topic=44378.0 and various other threads.

Side-note: your text is barely readable on my notebook - I suggest reviewing your stylesheet.
Logged

chagnee

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: High CPU usage
« Reply #4 on: August 21, 2007, 11:54:26 am »
GauGau, thanks for your reply. I know about the hard-to-read text. A new layout is being designed as we speak...  :)

In the meantime, I have turned "most recent" off. Regarding number 3 --> I think I've already disabled those. I mean, when you open a category, none of the albums list the number of files, date last added etc. Or do you mean something else?

I'l now try to upgrade to cpg1.4.12. Fingers crossed!
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: High CPU usage
« Reply #5 on: August 21, 2007, 12:29:51 pm »
Quote from: chagnee on August 21, 2007, 11:54:26 am
Regarding number 3 --> I think I've already disabled those. I mean, when you open a category, none of the albums list the number of files, date last added etc. Or do you mean something else?

GauGau means the stats which are shown on index page (6773 files in 357 albums and 89 categories with 2 comments viewed 98241 times).
Logged
Chief Geek at Ranium Systems

chagnee

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: High CPU usage
« Reply #6 on: August 21, 2007, 09:04:05 pm »
Thanks, Abbas Ali. I'll look into this as soon as possible, hoping that it helps solving my problem. Thanks for your advice, both of you.  :)
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.02 seconds with 20 queries.