MySQL Need Optimizing? Or Need more RAM? Server Load is High.
I'm in need of some advice here.
I'm running a P4 2.4ghz with 512mb Ram.
I have a very database intensive website that receives about 15,000 unique visits daily and can have as many as 300 users online at one time.
For the past 48 hours or so the system load has been floating between 1.0 - 4.0 during peak periods. I have some cron jobs that must run in order for the site to remain updated, they run every 20 minutes in a staggered fashion so that they don't all run at the same time and bring the system to a crawl. (All of the cron jobs are using the database to do table updates and are dealing with hundreds of thousands of rows of data).
This morning I had a scare when I saw my system load hanging around 12 - 14 for about 15 minutes..
So my question.
Would optimizing MySQL be my best bet? (if so, any mysql optimization wizards care to help?)
Would adding an additional 512mb ram help me out a lot?
Should I just switch servers to a multi-processor server?
Thanks, any sound advice would be much appreciated.
Regards,
Kurt
