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.
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
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:
- 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