Coppermine overloading mysql server

[mephit]

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

[François Keller]

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

[mephit]

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.

[mephit]

All it says its to disable random meta albums. I would need more info on this before doing anything.

[Stramm]

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

[mephit]

Stramm what does that have to do with this case?
I know how to remove the random images and last upload.

[Stramm]

That's how to disable the random images

All it says its to disable random meta albums. I would need more info on this before doing anything.

[mephit]

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

[Joachim Müller]

Yes, this will reduce the number of database queries.

[mephit]

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