After optimization database query using a lot of resources, cpu

  • Resolved wpmhweb

    (@wppit)


    4 years, 7 months ago

    After running the Optimize Database after Deleting Revisions plugin, the CPU of the web server runs high almost all the time. I mean it goes up and dow, but stays in high utilization.

    I logged onto the server, I looked in to the MySQL using the “show processlist;” commands and I’m noticing this process that executes, terminates, and executes again over and over even after restarting the server.
    This is how it appears in the “Info” column:
    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.
    Sometimes I even see multiple of the same query running.

    How can i fix the problem?
    Thanks,

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter wpmhweb

    (@wppit)

    Actually, now I’m seeing many SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.

    Please help.

    Plugin Contributor cageehv

    (@cageehv)

    Hey wpmhweb,

    My plugin definitely doesn’t use the SQL-query you mention, so it must be another plugin that’s causing this issue.

    peace,
    Rolf

    Thread Starter wpmhweb

    (@wppit)

    Thanks for the response, I think I found part of the problem. I think is some code in theme. However, the problem appeared immediately after running Optimize Database after Deleting Revisions plugin.

    Thanks,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘After optimization database query using a lot of resources, cpu’ is closed to new replies.