Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: slow mysql queries  (Read 2487 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.017 seconds with 19 queries.