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...).<br>
<br>
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. <br>
<br>
Good luck!<br>
--Dennis<br>
<br>
<br><br><div><span class="gmail_quote">On 2/2/06, <b class="gmail_sendername"><a href="mailto:kobear@sharedbrain.net">kobear@sharedbrain.net</a></b> <<a href="mailto:kobear@sharedbrain.net">kobear@sharedbrain.net</a>> wrote:
</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">If your major concern is the load on the database with 500,000 + records, then<br>server size is less important than good database design. Using mySQL
5.0.2 or<br>higher, you can get significant performance gains by placing all of your<br>queries into stored procedures. Also, having properly keyed and indexed<br>database tables is another HUGE performance enabler.<br><br>
Other than mySQL design, a dual Athlon with 1GB RAM and RAID drives would be<br>sufficient. SCSI is not required, but probably an easier find for RAID5, which<br>is what I would do for a production server.<br><br>Kyle<br>
<br><br><br>Quoting Frank Kumro <<a href="mailto:fkumro@gmail.com">fkumro@gmail.com</a>>:<br><br>> I am working on a new contract and one priority is to set up a LAMP<br>> server. I have set up many before however this one will have 500,000
<br>> records that are searchable in the MySQL database. Since I have never<br>> worked with this much data I was wondering if the LUG can give me some<br>> specs for the server. PHP4 will be used for searching unless the
<br>> performance is horrible, but I will deal with that when I begin<br>> testing. What I was thinking for hardware is<br>> 1) SCSI drives<br>> 2) 2GB of ram (maybe more maybe less??)<br>> 3) 2 processors (Xeon, is 1 good enough?)
<br>><br>> As you can see I only have a vague idea. Thanks in advance guys!<br>> --<br>> Frank<br>> Shenanigans!!<br>> _______________________________________________<br>> nflug mailing list<br>> <a href="mailto:nflug@nflug.org">
nflug@nflug.org</a><br>> <a href="http://www.nflug.org/mailman/listinfo/nflug">http://www.nflug.org/mailman/listinfo/nflug</a><br>><br><br><br><br><br>----------------------------------------------------------------
<br>This message was sent using IMP, the Internet Messaging Program.<br><br>_______________________________________________<br>nflug mailing list<br><a href="mailto:nflug@nflug.org">nflug@nflug.org</a><br><a href="http://www.nflug.org/mailman/listinfo/nflug">
http://www.nflug.org/mailman/listinfo/nflug</a><br></blockquote></div><br>