Extremely High MySQL CPU Usage

Keywords: WordPress - Microsoft Azure - Technical issue - Other
bnsupport ID: 721ffbac-36b7-d8d3-2dea-b8113b8d3148
Description:
The server seems to be running extremely slow and triggering CPU alerts from MS Azure for running over 85% utilisation.
We use an older Bitnami WordPress image which has MySQL CPU usage at over 450%+. When I run HTOP on the command line to view the processes running, it states Tasks: 101, Thr 1580, KThr 5.
With an uptime of 101 days. I have restarted the MySQL service. However, this doesn’t seem to have an affect on the uptime or flush out old processes.
Within the MySQL Conf file I have the below settings

  • expire_logs_days=0
  • binlog_expire_logs_seconds=360
  • max_allowed_packet=32M

My Apache access log is very large, but I’m not sure that this is a contributing factor.

Hello @PaulWilson,

Could you take a look at this previous answer?

I hope it helps

Hi @davidg,
We do have “wordpress-seo” installed like 85% of all wordpress websites. But it has always been there.
I have deactivated the plugin with no luck. I have since reactivated it, as it is vital to our business.
Any other suggestions?

Hello @PaulWilson,

From your support output, I can see this list of plugins and themes:

* PLUGINS
name,status,update,version
aam-plus-package,active,none,5.0.5
aardvark-plugin,active,none,2.4
activecampaign-subscription-forms,active,available,8.1.5
activecampaign-for-woocommerce,inactive,available,1.2.16
advanced-access-manager,active,available,6.7.4
advanced-custom-fields-table-field,active,available,1.3.12
advanced-custom-fields-pro,active,none,5.9.6
cci-crm-integration,active,none,1.0
cci-frontend-customisations,active,none,1.0
woo-checkout-field-editor-pro,active,available,1.4.6
facebook-for-woocommerce,inactive,available,2.3.5
filebird-pro,active,none,4.2
duracelltomi-google-tag-manager,active,available,1.11.5
gravityforms,active,none,2.4.23.1
gravityformszapier,active,none,4.0
gravitywp-css-selector,active,none,1.0.1
hide-my-site,inactive,none,2.1
better-wp-security,active,none,7.9.1
LayerSlider,active,none,6.11.8
addons-for-visual-composer,active,available,2.5.6
login-or-logout-menu-item,active,available,1.2.0
miniorange-wp-saml-idp-premium,active,"version higher than expected",13.0.5
mega-addons-for-visual-composer,active,available,4.0
memberpress-activecampaign,active,none,1.1.0
memberpress-corporate,active,none,1.5.18
memberpress-developer-tools,active,none,1.2.1
memberpress-downloads,active,none,1.1.2
memberpress,active,available,1.9.10
metorik-helper,active,none,1.5.0
popup-by-supsystic,active,available,1.10.3
quadmenu,active,available,2.0.7
really-simple-ssl,active,none,4.0.15
redirection,active,none,5.1.1
useresponse-sso,active,none,1.0
user-role-editor,active,none,4.59.1
user-switching,active,none,1.5.7
woocommerce,active,available,5.2.2
woocommerce-custom-thank-you-pages,active,none,1.0.2
woocommerce-google-analytics-integration,inactive,none,1.5.1
woocommerce-product-feeds,active,none,8.1.1
woocommerce-gateway-stripe,active,available,5.1.0
wordfence,inactive,available,7.5.3
wp-all-import,inactive,none,3.5.9
js_composer,active,none,6.6.0
wp-cli-login-server,active,none,1.2
wpdatatables,active,"version higher than expected",3.4.3
wp-mail-smtp,inactive,none,2.8.0
wp-mail-smtp-pro,active,none,2.8.0
yith-woocommerce-dynamic-pricing-and-discounts-premium,active,none,2.1.4
wordpress-seo,active,available,16.3

* THEMES
name,status,update,version
aardvark-child,active,none,1.0
aardvark,parent,none,4.16
twentytwenty,inactive,none,1.7
twentytwentyone,inactive,none,1.3

Regards