forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: aftab1003 on November 03, 2010, 11:04:19 pm

Title: slow mysql queries
Post by: aftab1003 on November 03, 2010, 11:04:19 pm
i am on hostmonster. facing very high cpu throttling issue.

on my slow my sql queries folder, cpg is also one of them...

Quote
# Wed Nov  3 15:28:39 2010
# Query_time: 1.337370  Lock_time: 0.000092 Rows_sent: 0  Rows_examined: 1
use eshoppin_cpg;
UPDATE `eshoppin_cpg`.cpg14x_sessions SET time = UNIX_TIMESTAMP() WHERE session_id = 'ca437036e2f98cb66423c09c5e531e35'

Quote
# Wed Nov  3 12:03:03 2010
# Query_time: 1.443269  Lock_time: 0.000096 Rows_sent: 0  Rows_examined: 1
use eshoppin_cpg;
DELETE FROM cpg14x_banned WHERE expiry < '2010-11-03 12:03:02'

i am running cpg 1.5.6 currently...

some one else facing this issue?
thanks in advance for help...
Title: Re: slow mysql queries
Post by: floridaflatlander on November 03, 2010, 11:44:47 pm
Do you have a link?

When my album started getting slow it turned out to be my server, not coppermine.
Title: Re: slow mysql queries
Post by: aftab1003 on November 03, 2010, 11:52:18 pm
http://www.picturerating.us/picture-gallery/   [adult content warning]
Title: Re: slow mysql queries
Post by: Joe Carver on November 04, 2010, 02:56:00 am
1) Upgrade to cpg 1.5.8

2) Reduce the excessive amount of thumbs on your home page.
Title: Re: slow mysql queries
Post by: aftab1003 on November 04, 2010, 11:58:49 pm
as per suggested, i have reduced the lastup to 3 from 5, and random 3 from 5...

i will upgrade to latest in short time.