High CPU Usage Mysql
Hi, I am browsing my websites. when I tried to browsing, CPU usage is more than 100%. ca you give me some assistance on this please and websites are getting very slow.
Looking forwards to hearing from you ASAP.
Guru
2 Replies
mjones
Linode Staff
Hi Guru! I'd recommend running the top command on your Linode to figure out which processes are using the most CPU time. We have a guide on top here:
Using top to Monitor Server Performance
From there, if you find that MySQL or Apache are using all available CPU time, consider resizing to a larger Linode plan. You may also want to try optimizing MySQL or Apache:
Hi
Try to:
- Find slow queries in slow log file.
- Use command "show processlist" to display MySQL current queries.
Also you could see some resources about MySQL Performance at https://github.com/Releem/awesome-mysql-performance