forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started 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...
# 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'
# 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...
-
Do you have a link?
When my album started getting slow it turned out to be my server, not coppermine.
-
http://www.picturerating.us/picture-gallery/ [adult content warning]
-
1) Upgrade to cpg 1.5.8
2) Reduce the excessive amount of thumbs on your home page.
-
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.