Problems with SQL Queries

  • Hello! Since I updated the WordPress, I started to have some “high load” problems in my database. My server (mosso) said that this are the problematic queries:

    SELECT wp_posts.*, MAX(comment_date) AS max_comment_date FROM wp_comments, wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE wp_posts.post_date <= '2007-08-06 11:02:35' AND ( wp_posts.post_status = 'publish' OR wp_posts.post_status = 'sticky' ) AND wp_posts.post_password = '' AND wp_posts.ID = wp_comments.comment_post_ID AND wp_comments.comment_approved = '1' AND ( wp_post2cat.category_id = '20' OR wp_post2cat.category_id = '21' OR wp_post2cat.category_id = '22' OR wp_post2cat.category_id = '23' OR wp_post2cat.category_id = '24' OR wp_post2cat.category_id = '201' OR wp_post2cat.category_id = '202' OR wp_post2cat.category_id = '203' OR wp_post2cat.category_id = '25' OR wp_post2cat.category_id = '26' OR wp_post2cat.category_id = '27' OR wp_post2cat.category_id = '28' OR wp_post2cat.category_id = '29' OR wp_post2cat.category_id = '251' OR wp_post2cat.category_id = '30' OR wp_post2cat.category_id = '31' OR wp_post2cat.category_id = '32' OR wp_post2cat.category_id = '33' OR wp_post2cat.category_id = '34' OR wp_post2cat.category_id = '35' OR wp_post2cat.category_id = '301' OR wp_post2cat.category_id = '37' OR wp_post2cat.category_id = '38' OR wp_post2cat.category_id = '39' OR wp_post2cat.category_id = '40' OR wp_post2cat.category_id = '401' OR wp_post2cat.category_id = '402' OR wp_post2cat.category_id = '43' OR wp_post2cat.category_id = '44' OR wp_post2cat.category_id = '45' OR wp_post2cat.category_id = '46' OR wp_post2cat.category_id = '431' OR wp_post2cat.category_id = '432' OR wp_post2cat.category_id = '433' ) GROUP BY wp_posts.ID ORDER BY max_comment_date DESC LIMIT 0, 4 |

| 904 | 331538_v6_main | 172.16.12.206:41472                    | 331538_v6_main | Query       |    0 | Copying to tmp table                                           | SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE wp_posts.post_date <= '2007-08-06 11:02:36' AND ( wp_posts.post_status = 'publish' OR wp_posts.post_status = 'sticky' ) AND wp_posts.post_password = '' AND ( wp_post2cat.category_id = '21' OR wp_post2cat.category_id = '26' OR wp_post2cat.category_id = '31' OR wp_post2cat.category_id = '37' OR wp_post2cat.category_id = '44' OR wp_post2cat.category_id = '8' OR wp_post2cat.category_id = '52' OR wp_post2cat.category_id = '53' OR wp_post2cat.category_id = '54' OR wp_post2cat.category_id = '55' OR wp_post2cat.category_id = '56' ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 14

    What does it mean? How can I solve this problem? Please, help me! =]

Viewing 4 replies - 1 through 4 (of 4 total)

  • I’m not suprised. That’s not a nice query at all. On some RDBMs it wouldn’t even work at all because the components of the SELECT list are not either covered by the group by or involved in aggregates.

    As for what you can do about it, I’m not sure. The query can probably be optimised, but it depends how it’s generated from where to do what?

    Thread Starter borbs

    (@borbs)

    I don’t know where is this from. I’ll try to look in all my plugins and see if it works… But, if somebody knows anything, please, let me know. ??

    It doesn’t seem to be a WP query. Most likely it is a plugin.

    Thread Starter borbs

    (@borbs)

    The problem is the Customizable Post Listings plugin.
    I disabled part of it, but I really need this plugin… Does anybody know some other that works like this?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Problems with SQL Queries’ is closed to new replies.