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 Perfomance  (Read 10487 times)

0 Members and 1 Guest are viewing this topic.

red_blood

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Coppermine Perfomance
« on: December 01, 2004, 06:23:04 pm »

Has anyone done any benchmarking and what-not to see what Coppermine can handle? what's the CPU usage, how many connections an hour can it handle, etc etc.
« Last Edit: December 10, 2004, 01:21:51 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Coppermine Perfomance
« Reply #1 on: December 03, 2004, 06:44:08 pm »

There has been no explicit benchmarking, but in fact coppermine is not the bottleneck, but you mySQL database is. There are installs with 100,000+ in the database.

Joachim
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Coppermine Perfomance
« Reply #2 on: December 03, 2004, 06:47:26 pm »

Currently still reuploading pics but when the gallery was/is fully loaded once again its about 7000 pics
on a dual blade server, a 2500 if iirc.

I asked the server admin once what the load was after a camp took place and it was negliable according to him.
The gallery stores pics from various camps and events for ScoutLink, irc network for scouts, and normally
after a event or camp everybody goes looking at the pics.

All reports that i got back from users are good. Speedy delivery of all pics at all times. Same goes on cpu load which
is not majorly higer all of a sudden.

Only way i could know that there were many viewers was that my ftp connection slowed down a bit ;) but that's
also not worth mentioning really.

CPG is imho a very well coded gallery. But that's just my own opinion ofcourse. Depends on what kind of server your
being hosted on etc..
Logged

sinus

  • Contributor
  • Coppermine newbie
  • ***
  • Offline Offline
  • Posts: 16
Re: Coppermine Perfomance
« Reply #3 on: December 06, 2004, 06:58:23 pm »

There has been no explicit benchmarking, but in fact coppermine is not the bottleneck, but you mySQL database is. There are installs with 100,000+ in the database.

Joachim
Hi Joachim,
I tried to search for cgp-examples with such a lot of images for a long time. Until now without sucess, I found allways "only"  a fraction of 100.000 images. I would be great, if you could give some examples or a thread or a url.
I did really search, maybe wrong.
Best wishes from Switzerland
Markus
Logged

Hein Traag

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: nl
  • Offline Offline
  • Gender: Male
  • Posts: 2166
  • A, B, Cpg
    • Personal website - Spintires.nl
Re: Coppermine Perfomance
« Reply #4 on: December 07, 2004, 02:33:51 pm »

As Joachim pointed out it is not cpg which is the bottleneck but the MySql database which stores and serves the
pictures to the visitors.

So I think your better of at a MySql support board to ask what the maximum load is that a MySql database can handle at any given time.
Logged

sinus

  • Contributor
  • Coppermine newbie
  • ***
  • Offline Offline
  • Posts: 16
Re: Coppermine Perfomance
« Reply #5 on: December 09, 2004, 07:59:52 am »

As Joachim pointed out it is not cpg which is the bottleneck but the MySql database which stores and serves the
pictures to the visitors.

So I think your better of at a MySql support board to ask what the maximum load is that a MySql database can handle at any given time.

Yes, I have understand this. But I would wonder to see some of such large cpg-systems. Not only related to the performance. I tried to search and search and search ... and found maximum some cpg-galleries with under 10'000 images, far away from the 100'000, what Gaugau spoke.

I must be a very bad searcher, I guess ...
Markus
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Coppermine Perfomance
« Reply #6 on: December 09, 2004, 12:50:00 pm »

We did have one with 400,000, which was a university students union site in Taiwan, which was done by Oasis.
They eventually changed their setup so much it was no longer coppermine, and it became a commercial outfit.  But if you search for oasis's profile, you should find a link to the site.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

sinus

  • Contributor
  • Coppermine newbie
  • ***
  • Offline Offline
  • Posts: 16
Re: Coppermine Perfomance
« Reply #7 on: December 09, 2004, 02:15:19 pm »

We did have one with 400,000, which was a university students union site in Taiwan, which was done by Oasis.
They eventually changed their setup so much it was no longer coppermine, and it became a commercial outfit.  But if you search for oasis's profile, you should find a link to the site.

Hey, thanks a lot.
Though it is in chinese letters, it seems interesting.
They seem to have about 40'000 images - roughly.
Markus
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Coppermine Perfomance
« Reply #8 on: December 09, 2004, 04:01:40 pm »

that's because they started over from scratch afaik. They used to have at least 200,000+ pics (that's the highest number I can remember) and ten thousands of members (causing huge traffic). With numbers that high you need to make up your mind on clustering and load balancing, just because a single server setup isn't capable of handling such high numbers. Coppermine hasn't explicitely been developed nor tested for such setups, but can be modified to work in such environment (at least that's what Oasis said). I'm sorry, that's all I can say.

Joachim
Logged

sinus

  • Contributor
  • Coppermine newbie
  • ***
  • Offline Offline
  • Posts: 16
Re: Coppermine Perfomance
« Reply #9 on: December 09, 2004, 08:24:44 pm »

... Coppermine hasn't explicitely been developed nor tested for such setups, but can be modified to work in such environment (at least that's what Oasis said). I'm sorry, that's all I can say.

Joachim
Hi Joachim,
That is enough information for me, thanks a lot for your answer.
I have just started to use cpg and I am to explore all the possibilities. I had a lot of help from a cpg-user (Klaus, ks), I guess, without him I would have had (sorry for my English) much more troubles to get a fine running cpg.
As soon as it is in a better shape, I will give here on the forum the url.
Thanks for a great product!

Markus / Switzerland

PS: just now first I try to find a new provider/hoster with more webspace (about 10 GB)
Logged

made

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Coppermine Perfomance
« Reply #10 on: January 10, 2005, 07:11:50 am »

We are running CPG with about 38000 pics. No performance probs!!! Only a little bit with random pics, but not really dramatic !!
http://www.owl-go.de

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Coppermine Perfomance
« Reply #11 on: January 10, 2005, 09:08:05 am »

Thanks for your report. The random pics generate a high strain on the server if your database becomes that large, that's why we recommend turning random pics off for galleries the size of your page. Could you post a link for reference as well please?

Joachim

[edit]
oops, the link is already there :-[ - sorry for being thick, I guess I just had a blonde moment.
[/edit]
« Last Edit: January 10, 2005, 09:47:59 am by GauGau »
Logged

sinus

  • Contributor
  • Coppermine newbie
  • ***
  • Offline Offline
  • Posts: 16
Re: Coppermine Perfomance
« Reply #12 on: January 10, 2005, 09:46:24 am »

We are running CPG with about 38000 pics. No performance probs!!! Only a little bit with random pics, but not really dramatic !!
http://www.owl-go.de


Hi,
Thanks for that link, very interesting!
Markus

Logged

Nibbler

  • Guest
Re: Coppermine Perfomance
« Reply #13 on: January 10, 2005, 02:51:19 pm »

I'm sure hiding the powered by coppermine footer made it a lot faster too.
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: Coppermine Perfomance
« Reply #14 on: January 10, 2005, 09:01:52 pm »

Man, that's really rude, made. >:(
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Coppermine Perfomance
« Reply #15 on: January 10, 2005, 10:23:45 pm »

And no claim of accidental colour clash here, the actual link, when you can find it is very small, the words powered by are small, and the coppermine is totally unreadable.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 19 queries.