Thanks for the information below.
Also, according to the article here:
http://www.webtechniques.com/archives/2001/05/hong/
The wildly popular amihotornot.com has served over
17.5 million page views in one month using mySQL
exclusively.
I don't know how extensively Yahoo Finance uses mySQL
in their production enviornment, but the above site,
with its Linux+mySQL-PHP development platform, ought
to become the poster child for anyone interested in
mySQL advocacy for real world, enterprise level
Weblications.
--- Basil Hussain <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> > 35 Million keyword searches a day are done at the
> > Goolge site.
> >
> > My calculator tells me this is roughly 405 keyword
> > searches per SECOND.
> >
> > Not even considering any other database queries
> needed
> > to generate targeted ad placement on each page,
> etc
> > one is left with a haunting question:
> >
> > How is it all done so quickly?
>
> I once read an article in Linux Gazette where Sergey
> Brin (one of the
> founders of Google) mentioned they used over 6,000
> Linux servers distributed
> across the USA:
>
> http://www.linuxgazette.com/issue59/correa.html
>
> Obviously, not all of these power the Google search
> engine itself, as they
> say they have more than 25,000 third-party sites
> using their services, but
> it indicates they're not short of computing power!
> They also use their own
> custom software. If you want to know more about how
> Google works, check this
> paper out:
>
>
http://www7.scu.edu.au/programme/fullpapers/1921/com1921.htm
>
> Anyway, 405 queries per second is not so much if you
> have monster hardware.
> I seem to remember one of the MySQL developers
> mentioning one time that they
> had benchmarked a MySQL server at over 1,000
> queries/sec.
>
> Regards,
>
> ------------------------------------------------
> Basil Hussain ([EMAIL PROTECTED])
>
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.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