High MySQL Usage

  • We’re using the latest disqus plugin with wordpress 5.7.2.

    We are currently facing high MySQL CPU usage when auto sync in the plugin is enabled. There are no REST API errors and plugin looks to be working fine however causing extreme high CPU which in result gets the site too low.

    The plugin autosync feature is consuming about 1000% CPU (12 cores processor) with Auto-Sync feature enabled. Once we stop the autosync, the CPU is back to normal and site gets stable.

    We are seeing alot proceseses like these:

    | 982 | dummy | localhost | dummy | Sleep | 3 | | NULL | 0.000 |
| 983 | dummy | localhost | dummy | Query | 2 | Sending data | SELECT wp_site_comments.comment_ID FROM wp_site_comments INNER JOIN wp_site_commentmet | 0.000 |
| 984 | dummy | localhost | dummy | Sleep | 2 | | NULL | 0.000 |
| 985 | dummy | localhost | dummy | Query | 2 | Sending data | SELECT wp_site_comments.comment_ID FROM wp_site_comments INNER JOIN wp_site_commentmet | 0.000 |
| 986 | dummy | localhost | dummy | Sleep | 2 | | NULL | 0.000 |
| 987 | dummy | localhost | dummy | Query | 2 | Sending data | SELECT wp_site_comments.comment_ID FROM wp_site_comments INNER JOIN wp_site_commentmet | 0.000

    Is there anything that we need to check to resolve this issue?

    • This topic was modified 3 years, 3 months ago by bkkhanny.
  • The topic ‘High MySQL Usage’ is closed to new replies.