i currently have 1 pretty large site...
www.ratemybottom.com i'm running my-huge.cnf I'm not having to many problems but at night things become slow and its not uncommon to have a mysql too many connections error.
My question is should I get more ram (go from 2gig to 3gig) or should I consider getting another dedicated server for mysql only? If so, what should the specs of that server be?
Should I
A)
- Dual Xeon 2.4Ghz
- 2 x 120GB Drives
- 2048MB RAM
- 20Mbps Unmetered Bandwidth
dual processor being the improvement
B) keep current server and increase to 3gigs
- 2.8GHz Pentium 4
- 2 x 120GB Drives
- 2048MB RAM
- 20Mbps Unmetered Bandwidth
C) get a second server for Mysql only with following specs... (please list)
I also have about 15 other small sites on the server as well. And the server load is showing Server Load 6.27 (2 cpus) (flashing red).
thanks in advance