Facebook
Twitter-
We value your experience with Plesk during 2025
Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
Please take this short survey:
https://survey.webpros.com/
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.
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.
