Help with spec-ing new MySQL server

Hello, I have been asked to spec out a new computer that will act as a dedicated MySQL server for a research cluster (running under RH Linux). To do that, I am trying to find information on the performance trade-offs between multiple processors (2 vs 4), the disk system (IDE vs SCSI; single vs R

mysqld unexpectedly crashes

Hello, I am having trouble with Mysqld unexpectedly crashing. I am running mysqld in a situation where there is a nearly constant load on 6 databases, each with about 20 open connections (mostly inserts and selects, occasionally a delete). Once every 3-4 days, at seemingly random points (i.e. i