Hello Michael,
We used to handle around that much traffic a few months back. Our setup
consists of a MySQL backend with a mod_perl/PHP Apache front end. All our
pages have dynamic content and are built on the fly.
Right now we have a dedicated server with DellHost (D-3200) and it doesn't
even blink under pressure. During the holiday peak the server load didn't go
above 0.3 and stayed on a daily average of 0.15. Right now it's running
about twenty queries per second. The queries we run are mostly indexed and
lightweight, we strive to keep it that way, although we do have our
homegrown full text search engine that runs in Mod_Perl that uses MySQL
often.
The machine is a Dual processor Intel 800Mhz with Raid 1 SCSI and half a Gig
Ram. It's solid as the rock of Gibraltar and really burns rubber. I haven't
rebooted since the initial setup four months ago and MySQL (now mature and
running on a great machine) *never* coughs and dies anymore. DellHost's
service is pretty good considering the scale on which they host and the
hellish tech support I received from our other providers.
Check out http://www.dellhost.com/dedicated_two.html
Dell sells these servers pre-configured or on a lease to own plan. They are
also behind Red Hat being major investors and all. Sounds like I sold my
soul to Dell but I'm very happy with our setup. I can sleep better now.
And if I can save anyone by having them choose DellHost, then my work here
is done.
Saludos,
Anthony
[EMAIL PROTECTED]
> From: Michael Zornek <[EMAIL PROTECTED]>
> Date: Fri, 12 Jan 2001 21:00:03 -0500
> To: [EMAIL PROTECTED]
> Subject: mySQL performance
>
> Ok, I'm starting to design a PHP/mySQL web site that will house about 6-8
> tables, lot of relation stuff, very dynamic output to the web visitors. My
> worry is performance. By doing authentication via comparing a member's
> profile to the record he want to read in the db and all that other fun
> mySQL stuff I'm truly petrified that performance will be slow.
>
> Currently we get about 1300 visitors a day but that's been doubling every
> few months. During our high point (near our own technology trade show) we
> get even more.
>
> So now that we should be getting some funds to buy a new tower what are the
> most important specs? Should I get a dual processor, RAID hard drives, gig
> of RAM. What's the best set up for a PHP/mySQL web server for approx 60,000
> page views and 1300 visitors per day?
>
> Thanks in advance,
> Mike
>
> ================================
> Mike Zornek, Web Developer
> http://www.mikezornek.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
