Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: slow mysql queries  (Read 2488 times)

0 Members and 1 Guest are viewing this topic.

aftab1003

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 67
    • PictureRating Site for Teens
slow mysql queries
« 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...
Logged

floridaflatlander

  • Coppermine newbie
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 14
    • OutdoorUpdate.com
Re: slow mysql queries
« Reply #1 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.
Logged

aftab1003

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 67
    • PictureRating Site for Teens
Re: slow mysql queries
« Reply #2 on: November 03, 2010, 11:52:18 pm »

Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: slow mysql queries
« Reply #3 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.

aftab1003

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 67
    • PictureRating Site for Teens
Re: slow mysql queries
« Reply #4 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.