I am experiencing issues with my vps due to high load but not sure how to start troubleshooting. any body?
Start with the process explorer and see what is using the resources. How you do that depends on the OS you are using. For Linux, the PS command with various flags. For Windows, the Task Manager.
thanks it is my linux server mysql , do you have any experience with mysqltunner ?
For linux I’d start with top to see which processes are using the most memory and CPU, iotop to see which processing are hitting the disk hard and iftop to see which processing are using the network the most.
What load do you have BTW? Is it just high, or too high? What VPS do you have? Maybe it just can’t handle the traffic it’s getting and you need to scale up?
I run a VPS with Ubuntu 18.04 and 1Gb. I had intermittent maximum memory limitations being reached and only clearing after a reboot. I think the frozen CPU was due to calling a series of MySqli commands. Calling PHP flush() after each MySqli operation has coincidentally cleared the frozen system problem.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.