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: Heavy query which causes high server load  (Read 7257 times)

0 Members and 1 Guest are viewing this topic.

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
Heavy query which causes high server load
« on: October 14, 2007, 02:30:56 pm »
I have noticed using this tool: www.dpgr.gr/status.php that there is a very strange query in my coppermine gallery, which takes some seconds (at least 1-2 seconds) to execute.

The query is:

Code: [Select]
SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, keywords,title, caption, owner_id, owner_name, aid, hits FROM usercpg11d_pictures WHERE approved = 'YES' AND aid IN (5,8,9,10,12,13,14,16,17,18,19,20,21,24,25,26,29,30,31,32,33,35,36,38,39,40,41,42,43,45,46,48,49,50,51,52,53,54,55,56,57,58,59,61,62,63,65,66,67,68,69,71,72, ... , 13377)  ORDER BY pid DESC  LIMIT 785 ,10
« Last Edit: January 21, 2008, 09:23:17 am by Joachim Müller »
Logged

Nibbler

  • Guest
Re: Heavy query which causes high server load
« Reply #1 on: October 14, 2007, 04:12:45 pm »
Looks like a perfectly normal query from several pages into the lastup meta album. The list of albums is so long because you have a lot of albums below that category.
Logged

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
Re: Heavy query which causes high server load
« Reply #2 on: October 14, 2007, 04:22:13 pm »
Quote from: Nibbler on October 14, 2007, 04:12:45 pm
Looks like a perfectly normal query from several pages into the lastup meta album. The list of albums is so long because you have a lot of albums below that category.

There is one main category "user galleries" where every user can create his albums. What should I do to optimise it?
Logged

Nibbler

  • Guest
Re: Heavy query which causes high server load
« Reply #3 on: October 14, 2007, 05:44:23 pm »
Unless you want to dig through the code and optimize that special case,nothing.
Logged

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
Re: Heavy query which causes high server load
« Reply #4 on: October 14, 2007, 07:05:02 pm »
Quote from: Nibbler on October 14, 2007, 05:44:23 pm
Unless you want to dig through the code and optimize that special case,nothing.

That means its a disadvantage of coppermine since it cannot handle huge number of albums.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Heavy query which causes high server load
« Reply #5 on: October 15, 2007, 08:05:43 am »
It can handle an unlimited number of albums (at least theoretically). You will have to make sure that the server is powerfull enough.
Logged

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
Re: Heavy query which causes high server load
« Reply #6 on: October 15, 2007, 01:42:17 pm »
Quote from: GauGau on October 15, 2007, 08:05:43 am
It can handle an unlimited number of albums (at least theoretically). You will have to make sure that the server is powerfull enough.

Fair enough. In my gallery with 130.000 photos of 19.000 members, hosted in the above server:
Dedicated server with 2 Dual Xeon 3,2 GHz (4 CPUs), 2 GB RAM and SATA HD, I do face problem.
What would you consider as a "powerful" server for such demands?
Logged

Dr_Michael

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 56
    • LightHunt
Re: Heavy query which causes high server load
« Reply #7 on: October 22, 2007, 10:38:21 pm »
Quote from: Nibbler on October 14, 2007, 05:44:23 pm
Unless you want to dig through the code and optimize that special case,nothing.

Anyone interested to optimise the code and get paid?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Heavy query which causes high server load
« Reply #8 on: October 23, 2007, 01:39:29 pm »
Moving to paid help section then.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.02 seconds with 19 queries.