[nflug] Server Specs - Need Some Comments

[kobear at sharedbrain.net]

If your major concern is the load on the database with 500,000 + records, then
server size is less important than good database design.  Using mySQL 5.0.2 or
higher, you can get significant performance gains by placing all of your
queries into stored procedures.  Also, having properly keyed and indexed
database tables is another HUGE performance enabler.

Other than mySQL design, a dual Athlon with 1GB RAM and RAID drives would be
sufficient.  SCSI is not required, but probably an easier find for RAID5, which
is what I would do for a production server.

Kyle



Quoting Frank Kumro <fkumro at gmail.com>:

> 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
>




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

_______________________________________________
nflug mailing list
nflug at nflug.org
http://www.nflug.org/mailman/listinfo/nflug