I wasn't sure whether to post this here or on stackoverflow, so apologies if its in the wrong place.
I have about 7 php scripts running on a centOS VPS. Each of these scripts contacts a game server and processes the logs, with the logs it either does some database queries or sends info back to the game server.
I am having an issue where some of the scripts will randomly become REALLY slow to respond and I don't know where to start with my debugging. Each script connects to its own database schema but on the same MySQL server. Each script will do about 4 inserts per second and twice as many select statements on their respective databases. I thought a database lockup may cause the issue but some console messages that are read from the database are sent to the game servers console without issue every 30 seconds, even when the script is slow to responding to other commands.
Non of the scripts are using a lot of memory or CPU power. About 0.1% each.
I know this information is really vague but I don't know linux very well at all (in fact, top is about my limit) and I really don't know where to start debugging this.