AWS Lightsail Wordpress website becoming unresponsive due to heavy ( 150 to 200% ) CPU and high memory usage

Keywords: WordPress - AWS - Technical issue - Other
bnsupport ID: 1d44ba42-ca11-ce55-4574-81049182a8c0
Description:
Hello There,

I’m looking to find a solution to this pretty frustrating problem.
This wordpress website was working fine for over 2 years on an AWS Lightsail instance with 2 VCPU Core and 4GB Ram, and then this started happening.

It has seen traffic of upto 7000 views per day, with no issues. These days the traffic is a bit lesser, but still having these frequent issues.

To combat the issue, I upgraded the instance to a 16GB Ram and 4VCPUs on AWS Lightsail, but the issue returned back within a few weeks.

I tried finding the reason and checked if it’s being attacked. But the top IPs are all from Sucuri.net ( firewall, I’m using ).

I really need your help and support in fixing this as I’m having to restart the server every few hours now.

Thank you in advance. Please let me know if I need to provide any inputs.

I’ve also followed this, but that din’t help.
https://community.bitnami.com/t/mysqld-bin-cpu-usage-between-150-200-with-bitnami-wordpress-lamp-on-aws-lightsail/69323

Hi @deepak,

The Bitnami support tool couldn’t get the list of plugins you have installed in the machine but probably one or more plugins are using the database intensively and that’s why the CPU usage is that high. Did you install any plugin recently? I also saw that you have many cron jobs configured, can you confirm those cronjobs are using the database correctly?

There is one plugin to optimize the database connections in WordPress that might fix this problem

https://wordpress.org/plugins/wp-optimize/

I can also see these errors in the database’s log (/opt/bitnami/mysql/data/mysqld.log)

PHP Warning:  PHP Startup: Unable to load dynamic library '/opt/bitnami/php/lib/php/extensions/imagick.so' - libMagickWand-6.Q16.so.4: cannot open shared object file: No such file or directory in Unknown on line 0
Connecting to server: ws.consultease.com.
2020-09-15T09:23:46.052888Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200915  9:23:46
PHP Warning:  stream_socket_client(): unable to connect to ws.consultease.com:8000 (Connection timed out) in /opt/bitnami/apps/wordpress/htdocs/course-admin/websocket_client.php on line 68
Failed to connect to server

It seems there is a PHP code that is trying to create a connection and it’s not successful, do you recognize that?

Thanks for your reply Jota.

I will try to get you the list of plugin shortly. And also look into wp-optimize.

Yes, we’ve some PHP code for additional functionality ( not covered by plugins ).
There is no new plugin or code installed in recent weeks.

Thanks,
Deepak

Hi Jota,

Per your suggestion, I’ve installed wp-optimized and used it to optimized the tables. It optimized successfully. Also cleared the post revisions ( had 1100 + post revisions ).

However, CPU is continuing to trigger like earlier. As this is not the peak hour, it’s a little reduced.

I do see the dynamic library error related to imagick, will try to resolve that and also the web socket.

Also, do you think this error has some connection with the problem we’ve …
"2020-09-15T09:23:46.052888Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200915 9:23:46"

I need a little more help in identifying and resolving this issue quickly for good.

Here is the list of plugins…


Plugin Description
Select Activity Hashtags
Activity Hashtags
Deactivate
Plugin for Activity Hashtags.

Version 1.0.2 | By Sumit yadav | Visit plugin site
Select Ad Inserter
Ad Inserter
Settings | Deactivate | Edit
Ad management plugin with advanced advertising options to automatically insert ad codes on your website

Version 2.3.12 | By Igor Funa | View details
Select Advanced Custom Fields
Advanced Custom Fields
Deactivate | Edit
Customise WordPress with powerful, professional and intuitive fields

Version 4.4.11 | By Elliot Condon | View details
Select Animate It!
Animate It!
Deactivate | Edit
Add cool CSS3 animations to your content.

Version 2.1.6 | By eLEOPARD Design Studios | View details
Select Animated Headline
Animated Headline
Detail | Deactivate | Edit
A simple wordpress plugin for animated headlines using shortcode. [animated-headline title=“Hello my friend” animated_text=“Anshul,Harshali,Asha,Rahul” animation=“rotate-1”]

Version 3.5 | By Anshul Labs | View details
There is a new version of Animated Headline available. View version 4.0 details or update now.
Select BP Payu Money
BP Payu Money
Deactivate | Edit
This plugin payu money for bodypress registration for pay registration fee expert user also setting in admin section merchent key ,SALT key and amount.

Version 1.0.2 | By Manish Kumar | Visit plugin site
Select BP Profile Search
BP Profile Search
Settings | Deactivate | Edit
Search your BuddyPress Members Directory.

Version 4.5.2 | By Andrea Tarantini | View details
Select BP Registration Options
BP Registration Options
Deactivate | Edit
This BuddyPress extension allows you to enable user moderation for new members, as well as help create a private network for your users. If moderation is enabled, any new members will be denied access to your BuddyPress and bbPress areas on your site, with the exception of their own user profile. They will be allowed to edit and configure that much. They will also not be listed in the members lists on the frontend until approved. Custom messages are available so you can tailor them to the tone of your website and community. When an admin approves or denies a user, email notifications will be sent to let them know of the decision.

Version 4.2.11 | By Michael Beckwith and Brian Messenlehner of WebDevStudios | View details
There is a new version of BP Registration Options available. View version 4.3.9 details or update now.
Select BP Simple Front End Post
BP Simple Front End Post
Deactivate | Edit
provides the ability to create unlimited post forms and allow users to save the post from front end.It is much powerful than it looks.

Version 1.1.4 | By Brajesh Singh | Visit plugin site
Select BuddyPress
BuddyPress
Deactivate | Edit | Settings | About
BuddyPress helps you build any type of community website using WordPress, with member profiles, activity streams, user groups, messaging, and more.

Version 2.6.1.1 | By The BuddyPress Community | View details
Select BuddyPress Captcha
BuddyPress Captcha
Deactivate | Edit
This plugin adds a reCAPTCHA form to BuddyPress registration form to keep your community spam free.

Version 1.2 | By Hardeep Asrani | View details
Select Buddypress Conditional Profile Field
Buddypress Conditional Profile Field
Deactivate | Edit
Buddypress conditional profile field

Version 2.0 | By BigBrother | View details
Select BuddyPress cover
BuddyPress cover
Deactivate | Edit
Adds cover image in profile page and groups buddypress.

Version 2.1.4.2 | By asghar hatampoor | View details
Select BuddyPress Featured Members
BuddyPress Featured Members
Deactivate | Edit
BuddyPress Featured members plugin allows you to make fetured members in you BuddyPress community and show them using shortcodes

Version 1.0 | By Rimon_Habib | View details
Select BuddyPress Follow
BuddyPress Follow
Deactivate | Edit
Follow members on your BuddyPress site with this nifty plugin.

Version 1.2.2 | By Andy Peatling, r-a-y | View details
Select BuddyPress Json API
BuddyPress Json API
Deactivate | Edit
JSON API additional features to be used with Buddypress of profile and profile photo update.

Version 1.0.56 | By Aheadzen Team | Visit plugin site
Select Buddypress Upload Avatar Ajax
Buddypress Upload Avatar Ajax
Deactivate | Edit
Allow you add upload avatar function with ajax in register page

Version 1.0.1 | By Huu Ha | View details
Select BuddyPress user account type PRO
BuddyPress user account type PRO
Deactivate | Edit
Categories you buddypress users and manage

Version 1.1.3 | By wp.bp.shop | Visit plugin site
Select BuddyPress Xprofile Custom Fields Type
BuddyPress Xprofile Custom Fields Type
Deactivate | Edit
BuddyPress installation required!! This plugin add custom field types to BuddyPress Xprofile extension. Field types are: Birthdate, Email, Url, Datepicker, …

Version 2.4.8 | By donmik | Visit plugin site
Select Calling Schedule
Calling Schedule
Deactivate
Plugin for Calling Schedule Management.

Version 1.0.2 | By Rakesh sharma | Visit plugin site
Select CE Leads Mined
CE Leads Mined
Deactivate | Edit
Summary of leads mined by Python Engine and other sources

Version 1.0 | By Deepak Chauhan/VOCSO Technologies Pvt Ltd | Visit plugin site
Select CE Plans
CE Plans
Deactivate | Edit
Take consultant user to plans page after registration form submit

Version 1.0 | By Deepak Chauhan / VOCSO Technologies Pvt Ltd | Visit plugin site
Select CM Answers
CM Answers
Deactivate | Edit | Settings
Allow users to post questions and answers (Q&A) in a stackoverflow style forum which is easy to use and install. Easy social integration & Customization

Version 2.9.14 | By CreativeMindsSolutions | View details
There is a new version of CM Answers available. View version 3.1.0 details or update now.
Select Consultant Packages
Consultant Packages
Deactivate
This is new plugin used for add Consultant Packages.

Version 1.0.2 | By Rakhi tyagi | Visit plugin site
Select Consultease App
Consultease App
Deactivate
This is new plugin used for consultease customers who want to consult with us any type of query of GST.

Version 1.0.2 | By Rakesh Kumar | Visit plugin site
Select Consultease Plans/Packages
Consultease Plans/Packages
Deactivate | Edit
Consultease Plans/Packages

Version 1.0 | By Deepak Chauhan/VOCSO Technologies Pvt Ltd | Visit plugin site
Select Contact Form 7
Contact Form 7
Settings | Deactivate | Edit
Just another contact form plugin. Simple but flexible.

Version 4.5.1 | By Takayuki Miyoshi | View details
Select Contact Form 7 - Success Page Redirects
Contact Form 7 - Success Page Redirects
Deactivate | Edit
An add-on for Contact Form 7 that provides a straightforward method to redirect visitors to success pages or thank you pages.

Version 1.2.0 | By Ryan Nevius | View details
Select Contact Form 7 Modules: Hidden Fields
Contact Form 7 Modules: Hidden Fields
Deactivate | Edit
Add hidden fields to the popular Contact Form 7 plugin.

Version 2.0.2 | By Katz Web Services, Inc. | View details
Select Contact Form DB
Contact Form DB
Deactivate | Edit
Save form submissions to the database from Contact Form 7, Fast Secure Contact Form, JetPack Contact Form and Gravity Forms. Includes exports and short codes. | Data | Short Codes | Settings | Reference

Version 2.10.20 | By Michael Simpson | Visit plugin site
Select ContestHopper for WordPress
ContestHopper for WordPress
Deactivate | Edit
Create your own contests and sweepstakes in seconds with customizable designs and multitude of features ranging from referrals, automatic random winner pick to integration with your favorite mailing list service like MailChimp, AWeber, CampaignMonitor and GetResponse.

Version 0.9.5 | By Webikon (Matúš Čerman) | Visit plugin site
Select Country State City
Country State City
Deactivate | Edit
Country State City wordpress plugn.

Version 1.0.0 | By ntech-technologies | Visit plugin site
Select Credits Organiser
Credits Organiser
Deactivate
This plugin is being created for our custom requirment of Credit’s Management.

Version 1.0.2 | By Rakhi tyagi | Visit plugin site
Select Custom Login Page Customizer
Custom Login Page Customizer
Deactivate | Edit
Custom Login Customizer plugin allows you to easily customize your login page straight from your WordPress Customizer! Awesome, right?

Version 1.0.7 | By Hardeep Asrani | View details
Select Custom Post Type Attachment ( PDF )
Custom Post Type Attachment ( PDF )
Deactivate | Edit
This plugin will allow you to upload pdf files to your post or pages or any other custom post types. You can either use shortcodes or functions to display attachments. You can upload at most 10 PDF files as attachments. :slight_smile:

Version 3.2.4 | By aviplugins.com | View details
There is a new version of Custom Post Type Attachment ( PDF ) available. View version 3.4.1 details or update now.
Select Custom Post Type UI
Custom Post Type UI
About | Help | Deactivate
Admin panel for creating custom post types and custom taxonomies in WordPress

Version 1.4.1 | By WebDevStudios | View details
Select Disqus Comment System
Disqus Comment System
Settings | Deactivate | Edit
The Disqus comment system replaces your WordPress comment system with your comments hosted and powered by Disqus. Head over to the Comments admin page to set up your Disqus Comment System.

Version 2.85 | By Disqus | View details
There is a new version of Disqus Comment System available. View version 3.0.17 details or update now.
Select DW Question Answer
DW Question Answer
Go Pro! | Deactivate | Edit
A WordPress plugin was make by DesignWall.com to build an Question Answer system for support, asking and comunitcate with your customer

Version 1.4.4 | By DesignWall | View details | Extensions
There is a new version of DW Question Answer available. View version 1.5.7 details or update now.
Select Easy Table of Contents
Easy Table of Contents
Settings | Deactivate | Edit
Adds a user friendly and fully automatic way to create and display a table of contents generated from the page content.

Version 1.7 | By Steven A. Zahm | View details
Select Email Login
Email Login
Deactivate | Edit
Allows you to log into WordPress (directly or via XML-RPC) using your email address instead of a(nother) username.

Version 4.6.4 | By Beau Lebens | View details
Select Fcm push notification
Fcm push notification
Deactivate
Plugin for consultease calling app notification management.

Version 1.0.2 | By Rakesh sharma | Visit plugin site
Select GC Testimonials
GC Testimonials
Deactivate | Edit
This plugin will help you to collect and show testimonials

Version 1.3.2 | By Erin Garscadden | View details
Select Google Analytics Dashboard for WP
Google Analytics Dashboard for WP
Settings | Deactivate | Edit
Displays Google Analytics Reports and Real-Time Statistics in your Dashboard. Automatically inserts the tracking code in every page of your website.

Version 4.9.3.1 | By Alin Marcu | View details
There is a new version of Google Analytics Dashboard for WP available. View version 6.2.2 details or update now.
Select Highlight and Share
Highlight and Share
Settings | Deactivate | Edit
Highlight text and share via Twitter or Facebook and many more

Version 3.0.9 | By Ronald Huereca | View details
Select HurryTimer
HurryTimer
Deactivate | Edit
A Scarcity Countdown Timer for WordPress & WooCommerce

Version 1.2.4 | By Nabil Lemsieh | View details
There is a new version of HurryTimer available. View version 2.2.27.1 details or update now.
Select Import Users from CSV
Import Users from CSV
Deactivate | Edit
Import Users data and metadata from a csv file.

Version 1.0.1 | By Andrew Lima | View details
Select IP2Location Country Blocker
IP2Location Country Blocker
Deactivate | Edit
Block visitors from accessing your website or admin area by their country.

Version 2.5.3 | By IP2Location | View details
There is a new version of IP2Location Country Blocker available. View version 2.22.1 details or update now.
Select iSoftware Blocks
iSoftware Blocks
Deactivate | Edit
This plugin lets you create your own reusable blocks of content.

Version 1.2.1 | By iSoftware | View details
Select JSON API
JSON API
Deactivate | Edit
A RESTful API for WordPress

Version 1.1.1 | By Dan Phiffer | Visit plugin site
Select JSON API User
JSON API User
Deactivate | Edit
Extends the JSON API for RESTful user registration, authentication, password reset, Facebook Login, user meta and BuddyPress Profile related functions. A Pro version is also available.

Version 2.6 | By Ali Qureshi | View details
There is a new version of JSON API User available. View version 3.5.0 details or update now.
Select Load next post
Load next post
Deactivate | Edit
Load next post ajax

Version 1.0 | By Shyam Jha | Visit plugin site
Select MailPoet 2
MailPoet 2
Deactivate | Edit
Create and send newsletters or automated emails. Capture subscribers with a widget. Import and manage your lists. This version is being replaced by MailPoet 3. Support offered to Premium customers only. Updates are limited to security issues.

Version 2.8.1 | By MailPoet | View details
There is a new version of MailPoet 2 available. View version 2.14 details or update now.
Select MailPoet 2 Premium
MailPoet 2 Premium
Deactivate | Edit
Extended functionalities to the free version.

Version 2.7.9 | By MailPoet | View details
There is a new version of MailPoet 2 Premium available. View version 2.7.10 details or update now.
Select MOJO Marketplace
MOJO Marketplace
Deactivate | Edit
This plugin adds shortcodes, widgets, and themes to your WordPress site.

Version 0.5.9 | By Mike Hansen
Select myCRED
myCRED
Settings | Deactivate | Edit
An adaptive points management system for WordPress powered websites.

Version 1.6.9 | By Gabriel S Merovingi | View details | About | Tutorials | Codex | Store
Select Newsletter
Newsletter
Deactivate | Edit
Newsletter is a cool plugin to create your own subscriber list, to send newsletters, to build your business. Before update give a look to this page to know what’s changed.

Version 5.4.4 | By Stefano Lissa & The Newsletter Team | View details
There is a new version of Newsletter available. View version 6.8.8 details or update now.
Select OneSignal Push Notifications
OneSignal Push Notifications
Deactivate | Edit
Free web push notifications.

Version 1.13.9 | By OneSignal | View details
There is a new version of OneSignal Push Notifications available. View version 2.1.4 details or update now.
Select Page Break
Page Break
Deactivate | Edit
Adds Page Break Button to Wordpress editor For easy insertion of Page Break “<!–nextpage” Tag in your Blog Posts.

Version 1.1.0 | By Espreson Media | View details
There is a new version of Page Break available. View version 1.1.1 details or update now.
Select PDF Auto Embed from Link
PDF Auto Embed from Link
Deactivate
Automatically embed PDF in the singular post when it detects a PDF anchor link.

Version 1.0 | By VOCSO Digital Product Agency | Visit plugin site
Select Query Monitor
Query Monitor
Settings | Add-ons | Deactivate | Edit
The Developer Tools Panel for WordPress.

Version 3.6.1 | By John Blackbourn | View details
There is a new version of Query Monitor available. View version 3.6.4 details or update now.
Select Really Simple SSL
Really Simple SSL
Premium Support | Docs | Settings | Deactivate (revert to http) | Edit
Lightweight plugin without any setup to make your site SSL proof

Version 3.0.2 | By Rogier Lankhorst | View details
Select Refferral Content Manager
Refferral Content Manager
Deactivate
Plugin for setting Refferral Contents for Email and Messages.

Version 1.0.2 | By Sumit Yadav | Visit plugin site
Select RegistrationMagic
RegistrationMagic
Settings | Support | Deactivate | Edit
A powerful system for customizing registration forms, setting up paid registrations, tracking submissions, managing users, assigning user roles, analyzing stats, and much more!!

Version 3.5.2.2 | By CMSHelplive | View details
There is a new version of RegistrationMagic available. View version 4.6.1.9 details or update now.
Select Rich Reviews
Rich Reviews
Settings | Deactivate | Edit
Rich Reviews empowers you to easily capture user reviews and display them on your wordpress page or post and in Google Search Results as a Google Rich Snippet.

Version 1.7.3 | By Nuanced Media | View details
There is a new version of Rich Reviews available. View version 1.9.1 details or update now.
Select Share Buttons by AddThis
Share Buttons by AddThis
Deactivate | Edit | Settings | Home
Set up sharing tools from AddThis right in WordPress. With AddThis you can see how your users are engaging with your content, provide a personalized experience for each user and encourage them to share your content in their social networks. Follow tools, recommended content, conversion tools and social analytics available to registered accounts at addthis.com.

Version 6.1.6 | By The AddThis Team | View details
There is a new version of Share Buttons by AddThis available. View version 6.2.6 details or update now.
Select Simple Event Planner
Simple Event Planner
Deactivate | Edit
A powerful & flexible plugin to create event listing and event calendar on your website in simple & elegant way.

Version 1.3.3 | By PressTigers | View details
There is a new version of Simple Event Planner available. View version 1.5.3 details or update now.
Important Upgrade Notice:

1.5.3 is a minor update with compatibility of WordPress 5.5


Select Social Articles
Social Articles
Settings | Deactivate | Edit
This is the first BuddyPress plugin that let you to create and manage posts from your profile. It supports all buddypres themes, so you don’t need to be an expert to use it!

Version 1.8 | By Broobe | View details | Donate
There is a new version of Social Articles available. View version 2.9.5 details or update now.
Select Stop Spammers Spam Control
Stop Spammers Spam Control
Deactivate | Edit
The Stop Spammers Plugin blocks spammers from leaving comments or logging in. Protects sites from robot registrations and malicious attacks.

Version 6.15 | By Keith P. Graham | View details
There is a new version of Stop Spammers Spam Control available. View version 2020.5 details or update now.
Select TinyMCE Advanced
TinyMCE Advanced
Settings | Deactivate | Edit
Enables advanced features and plugins in TinyMCE, the visual editor in WordPress.

Version 4.4.1 | By Andrew Ozz | View details
Select TinyMCE Custom Styles
TinyMCE Custom Styles
Settings | Deactivate | Edit
Add custom editor stylesheets to TinyMCE and Theme, and configure the TinyMCE styles dropdown to match.

Version 1.0.3 | By Tim Reeves (original author David Stöckl) | View details
There is a new version of TinyMCE Custom Styles available. View version 1.0.9 details or update now.
Select Trustify
Trustify
Deactivate | Edit
Help to create fake sales or real time WooCommerce sales notification as popup which will display in a certain time interval on the screen in all pages or selected pages from backend.

Version 2.1 | By Kaththemes | Visit plugin site
Select User Plan History
User Plan History
Deactivate | Edit
User Plan History

Version 1.0 | By Vishal Jangid | Visit plugin site
Select User Roles and Capabilities
User Roles and Capabilities
Deactivate | Edit
manage user roles and capabilities. Create new roles and delete existing roles. Using this plugin you will not be able to modify any capabilities for administrator user role. WordPress built in roles cant be deleted.

Version 1.2.1 | By mahabub | View details
There is a new version of User Roles and Capabilities available. View version 1.2.3 details or update now.
Select Verification Badge Requests
Verification Badge Requests
Deactivate
This is new plugin to be used for Verification Badge Requests.

Version 1.0.2 | By Sumit yadav | Visit plugin site
Select WCK - Custom Fields and Custom Post Types Creator
WCK - Custom Fields and Custom Post Types Creator
Deactivate | Edit
WordPress Creation Kit consists of three tools that can help you create and maintain custom post types, custom taxonomies and most importantly, custom fields and metaboxes for your posts, pages or CPT’s.

Version 2.0.2 | By Cozmoslabs, Madalin Ungureanu, Cristian Antohe | View details
There is a new version of WCK - Custom Fields and Custom Post Types Creator available. View version 2.2.6 details or update now.
Select Wordfence Security
Wordfence Security
Upgrade To Premium | Deactivate | Edit
Wordfence Security - Anti-virus, Firewall and Malware Scan

Version 6.2.8 | By Wordfence | View details
There is a new version of Wordfence Security available. View version 7.4.11 details or update now.
Select WordPress Popular Posts
WordPress Popular Posts
Deactivate | Edit | Settings
A highly customizable widget that displays the most popular posts on your blog.

Version 4.0.13 | By Hector Cabrera | View details
Select WordPress Responsive Thumbnail Slider
WordPress Responsive Thumbnail Slider
Deactivate | Edit
This is beautiful responsive thumbnail image slider plugin for WordPress.Add any number of images from admin panel.

Version 1.0.1 | By I Thirteen Web Solution | View details
There is a new version of WordPress Responsive Thumbnail Slider available. View version 1.1.5 details or update now.
Select WP Better Emails
WP Better Emails
Deactivate | Edit | Settings
Beautify the default text/plain WP mails into fully customizable HTML emails.

Version 0.3 | By Nicolas Lemoine | View details
Select WP Editor
WP Editor
Settings | Deactivate | Edit
This plugin modifies the default behavior of the WordPress plugin and theme editors.

Version 1.2.6.3 | By Benjamin Rojas | View details
Select WP Hide Post
WP Hide Post
Deactivate | Edit
Control the visibility of items on your blog by making posts/pages hidden on some parts , while still visible in other parts and search engines.

Version 2.0.10 | By scriptburn.com | View details
Select WP Trending Post Slider and Widget
WP Trending Post Slider and Widget
Deactivate | Edit
Show Popular post in page and sidebar with slider and different designs.

Version 1.1 | By WP Online Support | View details
There is a new version of WP Trending Post Slider and Widget available. View version 1.3.5 details or update now.
Select WP-Mail-SMTP
WP-Mail-SMTP
Settings | Deactivate | Edit
Reconfigures the wp_mail() function to use SMTP instead of mail() and creates an options page to manage the settings.

Version 0.10.1 | By Callum Macdonald | View details
Select WP-Optimize - Clean, Compress, Cache
WP-Optimize - Clean, Compress, Cache
Optimize | Settings | Premium | Deactivate | Edit
WP-Optimize makes your site fast and efficient. It cleans the database, compresses images and caches pages. Fast sites attract more traffic and users.

Version 3.1.4 | By David Anderson, Ruhani Rabin, Team Updraft | View details
Select Yoast SEO
Yoast SEO
FAQ | Premium Support | Settings | Deactivate | Edit
The first true all-in-one SEO solution for WordPress, including on-page content analysis, XML sitemaps and much more.

Version 3.7.1 | By Team Yoast | View details
Select YouTube
YouTube
Deactivate | Edit | Settings | Pro Version
YouTube Embed and YouTube Gallery WordPress Plugin. Embed a responsive video, YouTube channel, playlist gallery, or live stream

Version 11.8.1 | By EmbedPlus Team | View details
There is a new version of YouTube available. View version 13.4.1.1 details or update now.
Select Youtube Contributor Requests
Youtube Contributor Requests
Deactivate
This is new plugin to be used for checking and accepting Youtube Contributor Requests.

Version 1.0.2 | By Rakhi Tyagi | Visit plugin site


Thank you.

One more thing for your information. In the peak hours like this. I see CPU % for mysqld.bin even touching 400% :frowning:

Hi @deepak,

This is not an error, just a note from the database.

You have multiple plugins and do not know if any of them is making intensive use of the database. I suggest you ask in the official forums of WordPress to know more information about how to debug this. You can also disable all the plugins to confirm that there is a problem with them but do not know if that’s possible right now (I understand this is a live site). If you can disable all the plugins and the CPU usage decreases, then you can start enabling the plugins again to see what the problematic one is.

Thanks for your reply Jota. As you know it’s a live site, disabling all plugins doesn’t seem to be a viable solution.
Should there not be a way to analyze mysql log?

Also, how come this suddenly become an issue if it was working fine from over a year.

Is there a paid service, where I can have someone to look into it for us?

Hi @deepak,

There are no more details in the mysqld.log file. However, it seems you enabled the general log in MySQL

general_log_file=/opt/bitnami/mysql/data/mysqld-general.log

Can you take a look at that file to see if there is more information there?

I’m sorry but we do not provide that kind of support. We have this community forum in which we help the users to debug the issues and try to find more information. As I mentioned above, this seems to be a problem with WordPress (or its plugins) and the connections to the database. The WordPress support team should provide you ways to debug this on the WordPress’ side. If any change in the configuration is needed, we can help you apply those changes later.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.