Results 1 to 8 of 8

Thread: MySQL query causing high CPU load

  1. #1
    Thread Starter
    Expired Customer gmanct's Avatar
    Join Date
    Jul 2015
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MySQL query causing high CPU load

    Hi guys

    The server running the Classipress template keeps getting overloaded and crashing, and my host tells me it is this query causing it:

    "SELECT postcount FROM wp_cp_ad_pop_daily WHERE postnum ="

    Any idea how I can fix this?

    G

  2. #2
    Senior Member krreddy's Avatar
    Join Date
    Mar 2011
    Location
    India
    Posts
    206
    Thanks
    15
    Thanked 1 Time in 1 Post
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. #3
    Expired Customer esaiasgr's Avatar
    Join Date
    Mar 2015
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    Expired Customer salujo70's Avatar
    Join Date
    May 2015
    Posts
    137
    Thanks
    11
    Thanked 8 Times in 6 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #5
    Expired Customer esaiasgr's Avatar
    Join Date
    Mar 2015
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. #6
    mckolt's Avatar
    Join Date
    Feb 2014
    Location
    Poland
    Posts
    183
    Thanks
    14
    Thanked 3 Times in 3 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  7. #7
    Thread Starter
    Expired Customer gmanct's Avatar
    Join Date
    Jul 2015
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  8. #8
    talent's Avatar
    Join Date
    Jul 2011
    Location
    London UK
    Posts
    3,497
    Thanks
    75
    Thanked 553 Times in 502 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    $function ('CUSTOMIZATION'); } else { .DESIGN { display: awesome; }
    If you require any additional functionality or design customization, just ask. Afterall... anything is possible! However, I may not know how to implement your particular request, but if you don't ask, you don't get

    If you build it, they will come...


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Jomark very high sql load - Site Down
    By zlaws in forum Report JobRoller Bugs
    Replies: 1
    Last Post: June 5th, 2014, 12:51 PM
  2. Jomark JobRoller - hosting high load (CPU usage)
    By vladko13 in forum Report JobRoller Bugs
    Replies: 6
    Last Post: May 17th, 2013, 04:24 AM
  3. JobRoller throwing MySQL query error
    By jason1178 in forum Report JobRoller Bugs
    Replies: 8
    Last Post: October 11th, 2012, 05:58 PM
  4. Theme Causing allot of mySQL DB Connections
    By altafshah in forum Report ClassiPress Bugs
    Replies: 5
    Last Post: July 18th, 2012, 05:45 AM
  5. Fields Updateable by Mysql Query
    By hyperion in forum ClassiPress General Discussion
    Replies: 6
    Last Post: September 28th, 2011, 03:34 AM