At a particular point in the day, the CPU load just hits the roof making the site super slow. Pages that usually open in 1 or 2 seconds take approximately 1 minute to 5 minutes to load. Can someone help?
Unless you have a real storm of connections coming in at that time during the day, my guess is that the server starts to swap due to that the memory is out and when it does everything goes to almost a standstill since the cpu will basically just move around a lot of data trying to execute all processes.
But without seeing some output from “top” or the like during this peak it’s hard to say.
As for MySQL output from these commands can also help to see how well tuned your database is:
show global status like ‘handler%’;show global status like ‘queries’;show global status like ‘select%’;show global status like ‘sort%’;show global status like ‘table%’;