I have about 150 cron jobs running that process between 6 and 10 inserts every 3 seconds. There are LOTS of select statements happening every 3 seconds as well.
My problem is, things work very well for a while and then start messing up and just don't seem to respond. I have 16BG of memory and only 20% is used and my CPU usage is averaging about 2.0. This makes me think I have some options I can tweak somewhere.
I was trying to mess about with file descriptors on my other dedi box but ended up losing root access for some reason so only want to do this again if someone can point me to a VERY good tutorial.
MySQL's Opened_tables is at 15.6 million (that a a lot?)
I would just like some general advice on settings I should be tweaking and things I should be doing to make the server run well. I obviously have the resources available but I presume MySQL / Apache are limited in some way.
Server Spec: Linux CentOS 5 with Plesk 9.5.4 and MySQL 5.0.
I really appreciate any help in advance.