Mark Maggelet <[EMAIL PROTECTED]> wrote on 02/03/2004 19:08:02:
>
> > Scanning a PC manufacturer's website, it seems easy to get 4x2.5GHz
> > Xeon, 1Mb L3, 8Gb ram, dual 15000 rpm Scsi with Raid 1 (for
> > performance as well as reliability).
> >
> > Does this sound balanced for a MySQL engine? Or what would other
> > people advise?
>
> I think you're better off with 4hd's and 2cpu's then the other way
> around since that's where your bottleneck will probably be, double the
> hd's should cut read times in half (but maybe add to write times)
I had assumed that, since the ram was of the same order as the database
size, most of the database would be cached.
Number of threads is of concern - the system will have many lightweight
queries, which I would like answered fast, and a few heavy joins. As I
understand it, if the data is in memory and no lock collisions occur, a
heavyweight query will hog a CPU until completed. Many CPUs (or virtual
CPUs, with hyperthreading) allow many opportunities for simple queries to
overlap complex ones.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
