[nflug] Server Specs - Need Some Comments

[Dennis Ruzeski]

MySQL is a great performer for reads. Less so for writes. If the database is
going to be used primarily for reads, install it with the myisam engine. If
you're expecting a lot of write/update use the inno engine (supports
row-level locking, high-concurrency, full transaction support, real
referential integrity, etc...).

Memory is more important than CPU, but dual procs will give you a big boost.
Fast disk is essential- If the DB will be heavy reads and you won't be doing
referrer logging w/ apache, RAID 5 will be ok but if you need referrer logs
and/or the database will get lots of write/update traffic, then go w/ 4
disks and RAID 10. Make sure you spend some time tuning everything after the
build-- Out of the box, no linux or mysql combo will be anywhere near
optimal.  I'd put the web and database on the same box (Unix named pipes are
a HUGE performance gain over a TCP socket) and install squid as a reverse
proxy to cache common requests and keep the DB load down.

Good luck!
--Dennis



On 2/2/06, kobear at sharedbrain.net <kobear at sharedbrain.net> wrote:
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.nflug.org/pipermail/nflug/attachments/20070525/dd354362/attachment.html
-------------- next part --------------
_______________________________________________
nflug mailing list
nflug at nflug.org
http://www.nflug.org/mailman/listinfo/nflug