[nflug] Server Specs - Need Some Comments

[Nate Byrnes]

Hi Frank,
    With databases it is as important to know the type of usage. Is the 
database more of a transaction processing box, or a data warehouse. If 
it is transaction processing, memory and CPU will be more important on a 
well tuned DB, as you will want to get your queries in and out as fast 
as possible. if a warehouse, your disk IO will tend to be your largest 
bottleneck as you will need to get through large amounts  of data as 
fast as possible.  Most of this comes down to what does the database 
look like. At 500K records you are starting to get into the area where 
DB design will possibly have more impact on performance than number of 
CPU's.
    So my question is what does this DB look like, how many tables, what 
is the rough size, etc?

    Regards,
    Nate

Frank Kumro wrote:
> I am working on a new contract and one priority is to set up a LAMP
> server. I have set up many before however this one will have 500,000
> records that are searchable in the MySQL database. Since I have never
> worked with this much data I was wondering if the LUG can give me some
> specs for the server. PHP4 will be used for searching unless the
> performance is horrible, but I will deal with that when I begin
> testing. What I was thinking for hardware is
> 1) SCSI drives
> 2) 2GB of ram (maybe more maybe less??)
> 3) 2 processors (Xeon, is 1 good enough?)
>
> As you can see I only have a vague idea. Thanks in advance guys!
> --
> Frank
> Shenanigans!!
> _______________________________________________
> nflug mailing list
> nflug at nflug.org
> http://www.nflug.org/mailman/listinfo/nflug
>
>
> !DSPAM:43e23d10169156796316472!
>
>   
_______________________________________________
nflug mailing list
nflug at nflug.org
http://www.nflug.org/mailman/listinfo/nflug