One of our MysQL database sever memory and CPU utilization running at high

Question

MySQL Server RAM and CPU utilization is high

Answer 1

Hello ManuRamaswamy,

Thank you for your question and for reaching out with your question today.

Please work through the following suggestions:

1. Turn off persistent connections as they may be causing the high usage.
2. Turn on the MySQL Slow Query Log to keep an eye on any queries that are taking a long time, and use that to make sure you don't have any queries locking up key tables for too long.
3. You can use SHOW PROCESSLIST; to show you the cureently running queries and potentially identify any problems.
4. Keep an eye on the buffer sizes, table cache, query cache and innodb_buffer_pool_size (if you're using innodb tables) as all of these memory allocations can have an affect on query performance which can cause MySQL to use high CPU.

If the reply was helpful, please don’t forget to upvote or accept as answer.

Best regards.