Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: open
The problem is, the server has gone down twice. Each time, MySQL was probably the cause due to extremely high CPU usage. My stats won't even run because of the cpu load, so I can't even tell how much traffic I'm really getting.
The server is a linux based pentium 4 2.8ghz. I can upgrade, but pretty sure, I just need to do some db optimization.
My question is, where do I start? Is there a MySQL optimization checklist I could start going through? If not, can y'all post some suggestions?