forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: mephit on October 23, 2007, 06:56:57 am

Title: Coppermine overloading mysql server
Post by: mephit 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

Title: Re: Coppermine overloading mysql server
Post by: François Keller on October 23, 2007, 07:22:29 am

Hi have you read this ?
http://forum.coppermine-gallery.net/index.php?topic=45868.0 (http://forum.coppermine-gallery.net/index.php?topic=45868.0)

Title: Re: Coppermine overloading mysql server
Post by: mephit 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.

Title: Re: Coppermine overloading mysql server
Post by: mephit 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.

Title: Re: Coppermine overloading mysql server
Post by: Stramm on October 23, 2007, 08:25:25 am

http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#NoLastUploads

Title: Re: Coppermine overloading mysql server
Post by: mephit 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.

Title: Re: Coppermine overloading mysql server
Post by: Stramm 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.

Title: Re: Coppermine overloading mysql server
Post by: mephit on October 24, 2007, 02:08:20 am

OK, I understand that. Will this lower the number of open mysql inquiries?

Title: Re: Coppermine overloading mysql server
Post by: Joachim Müller on October 25, 2007, 12:35:02 pm

Yes, this will reduce the number of database queries.

Title: Re: Coppermine overloading mysql server
Post by: mephit on October 26, 2007, 12:16:53 am

ok thank you. I guess I will see how this goes for now.