I have a Wordpress site which contains 1600+ pages: The site is hosted on a VDS server, the host server has 2 x quad core xeon CPU (total of 8 cores)
Your VDS has access to 4 cores
3gb of memory and 45Gb of space
Operating System: Centos. Server panel: Plesk.
Problem: the site keeps crashing the server; I am told that 'sql spikes' are the cause, 'bad code' using php to process sql services and/or keeping sql services open too long, thereby building up more processes leading to the spike and the crash. They also say our sql queries are extremely inefficient.
I urgently need some one to analyze and solve this problem please.