optimizing the mysql for coppermine

[djsoltan]

Hello guys, i have coppermine 1.2.1 installed on my dedicated server ( p4 2.4 with gig of ram ). i have about 2000 users and about 1000 pictures on this gallery.
my server is running extreamly slow now and the sql takes the cpu usage up to 99% sometimes. i have called their tech support and they say that i need to optimize mysql for this coppermine. does anyone know what that is and how i can optimize it?
thank you in advance

[Joachim Müller]

well, a link to your site might help a lot...

GauGau

[epsilon]

I have coppermine runing in my dedicate P 1.8 with 1 gb of ram, about 9000 unique vistors per day and 28.000 impressions, and the server is runing too slow, sometimes gets the error (too many connectiones to mysql) and i have it on 3500 / 4000 at sime time in apache, there a lot of conexions to mysql, sessions could be a good solution?

http://www.cremita.com (adult site) is my site. Thnks

[Tarique Sani]

CPG runs a whole lot of queries for every page - I had pointed that out some months ago and forgotten.

There are threads which point out how to turn off some features to improve speed.

Also the queries in config are being worked upon and will be put in sessions.

[epsilon]

This is a cool notice, the sessions will helps to the script, i have off the hits under thumbs, the film under photo, and the thumb in categories but the server cant do more,  :cry:  I wait for the sessions very happy, thnks...

[djsoltan]

Dear GauGau,
here is a link to my Gallery
http://69.56.234.116/thumbnails.php?album=3
right now i have 1989 visitors, visitors are able to write their own comments, delet the comments, send post card, rate picturs.
and as i am typing this message heres the info i have from the galery " 1022 pictures in 1 albums with 11537 comments viewed 3514842 times"
let me tell you about my server one more time, i have a redhat 9.0 system with a pentium 4 ( 2.4 ) chip and a gig of DDR ram, im on a 10 mb network.
thank you in advance

[DaveX]

Are you using ImageMagick?  I think that's quite server intensive...  Could try using GD instead maybe.

[djsoltan]

i am using GD version 2.0 not imagemagic. can someone help me please?

[Joachim Müller]

group your albums into categories and disable the display of thumbnails on the start page - your server has to run way too many queries when displaying this amount of thumbnails on every thumbnail page - reduce the number of thumbs to a value that makes sense (usually the initial values from coppermine install are fine).
To accomplish this, go to coppermine config and set "Number of columns on thumbnail page" to 4 (as it is now) and "Number of rows on thumbnail page" to "3" (you currently have "10").

That said, I have to point out that I don't like the idea of people running their own (dedicated) server at home unless they really, really know what they're doing (and you can trust me on this, I know what I'm talking about).

The use of GD vs IM doesn't make a great difference on displaying the page, as the image lib is only being used during upload, so I wouldn't be concerned about this.

GauGau

P.S. you (or at least the majority of your visitors) seem to speak a language that I don't know, but there doesn't seem to exist a translation to your language. How about volunteering for a coppermine translation to your language?