“Sending Data” in MySQL shoots CUP to 600% Site Craches [URGENT]

  • Hi Guys,

    I am using WP 2.7.1. Like every day i was approving comments but this time I tried approving multiple comments in one go in different tabs.

    Site crashed and when I looked into the problem, mysql was hitting 600% of CPU usage and when I look into MySQL processes I see this the following query at least 40-50 times ..

    “SELECT c . * , p . * FROM wp_comments c INNER JOIN wp_posts p ON p. ” with the query status “Sending Data”. This happens even when there are no users on the site.

    I tried “Flush Tables” and also restarted the database several times.. nothing helped ??

    FYI – I have WP-Supercache installed

    My site is currently down.. plz help.

Viewing 1 replies (of 1 total)
  • Thread Starter syedabbas

    (@syedabbas)

    One of the plugins was causing the issue, “Comment Relish” to be specific.

    Removed the plugin and issue is solved now.

Viewing 1 replies (of 1 total)
  • The topic ‘“Sending Data” in MySQL shoots CUP to 600% Site Craches [URGENT]’ is closed to new replies.