ram: 1 gig or 2 ?

[matthew mcglynn]

I'm building a quad-xeon server that will be dedicated to
MySQL. Basic specs:
 - 4x 500 MHz Xeon processors, 512k cache per CPU
 - Mylex extremeRaid card, configured for RAID 0+1 (stripe + mirror)
 - 1 gig of RAM
 - Linux, 2.2.X kernel

The open question at this point is: is it worth spending
another $2000 (approx) on a second gig of RAM ? The cost
isn't really all that important, although if the OS or
the database can't make use of it, there's no point in
wasting the money.

The total database size is over 1 gig, spread out across
20-30 tables, but we project growth to 3 gigs of data and
30-40 tables in the mid-term. The database will see 3-5
million SQL transactions per day, mixed insert/update/delete.

Any other comments on this architecture ?

Thanks.

Oh, BTW, we do have a support ID, although I cannot find
it at the moment. (Not sure it was ever sent to me, actually.)

--
matt.