Re: [dspam-users] dspam hardware requirements?

Brad Groshok wrote:
> We typically run Intel Dual Xeon (2.6Ghz) boxes with Ultra 160SCSI drives.
> Memory is typically 1 Gig, but of course can do whatever is required.
> Solaris X86 2.9 is our preferred OS. (use what you know and all)

Sounds appropriately beefy!

>
> Guess where I'm starting at is:
> I'm wondering if my dspam solution should all be on 1 box (with MySQL) or
> if I should be having DSPAM on a box all on its own making queries to
> another similar box just running MySQL.

The dspam queries can be very large, so making them locally is
preferable. dspam is very much a "database bound" application, so you
probably shouldn't run it on two boxes for best performance. Be sure
and tune MySQL for "large" operation (i.e. use the MySQL configuration
that assumes it is the only application on the box). If you really want
to maximize throughput, follow the normal database tuning rules (indexes
on a separate spindle from data, as much RAM as is possible, etc).
Using MySQL (5.0 or 4.1.x) with InnoDB is preferably (even though raw
performance-wise ISAM is still better) because you don't have to deal
with table locks during updates. Make sure you run optimize on your
tables after you get the training loaded and at least monthly afterwords.

HTH

John

-- 
John Peacock
Director of Information Research and Technology
Rowman & Littlefield Publishing Group
4501 Forbes Boulevard
Suite H
Lanham, MD  20706
301-459-3366 x.5010
fax 301-429-5748