Comment Query

  • Hi,

    If anyone could aid with this problem we’d greatly appreciate it. Our site (https://gearpatrol.com) just implemented a new custom theme and it appears that we are pegging our MySQL server at over 80% utilization during most of the day, and at time 100%.

    Evidently, it’s due to a plugin or code that’s generating the following query:

    SELECT * FROM wp_comments WHERE  ( comment_approved = '0' OR
comment_approved = '1' ) ORDER BY comment_date_gmt DESC

    The problem being that there is no limit clause to limit the amount
    of data it returns and the WHERE is too generic as the query is returning
    about 95% of our comment table.

    Does anyone know if any of the following plugins might be causing this or can help us resolve? We would greatly appreciate it and would be glad to send over a piece of gear (we review lots of gadgets and gear) for your help. Thank you, in advance!

    Plugins:

    After The Deadline
    Akismet
    All in One SEO Pack
    Amazon Auto Link
    Cimy User Extra Fiields
    Custom Field Template
    Feedburner FeedSmith
    Google XML Sitemaps
    Login Lockdown
    My Category Order
    NextGen Gallery
    Outbrain
    PollDaddy
    Post Template
    ShareThis
    TweetMeme Retweet Button
    Ultimate Google Analytics
    Wordpress.com Stats
    Wp-Email
    Wp-Memory-Usage
    Wp-Optimize
    Wp-Postratings
    Wp-JS
    WP-Security Scan
    Wp-Super Cache

Viewing 1 replies (of 1 total)

  • Have you tried:

    – deactivating all plugins to see if this resolves the problem? If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the default theme to rule out any theme-specific problems?

Viewing 1 replies (of 1 total)
  • The topic ‘Comment Query’ is closed to new replies.