• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Issue mysql High CPU usage

riadshout

New Pleskian
Hi everyone recently facing a big issue with the MySQL service, MySQL service use more than 11 cores. Anyone please how can I resolve the issue?
 

Attachments

  • Screenshot_108 crop.png
    Screenshot_108 crop.png
    91 KB · Views: 117
Slow MySQL queries generate high CPU usage on the server.

1. Identify the slowest queries. For example:

# plesk db "SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY TIME ASC \G"

Id: 444047
User: johndoe
Host: localhost
db: ExampleDB
Command: Query
Time: 300
State: Sending data

2. Log in to Plesk and go to Tools & Settings > Database servers > click on the number of databases.
3. Identify the subscription associated with the database from step 1
4. Kill the slow queries by their ID from step 1:

# plesk db "kill ID"

5. Suspend the subscription where the identified database is registered to decrease CPU load.
6. Contact website developers to review slow SQL queries and fix the issue.
 
Back
Top