From: Van
Date: March 12 1999 12:33am
Subject: Re: How large a database can mySQL handle?
List-Archive: http://lists.mysql.com/mysql/72
Message-Id: <36E860C9.D895835B@dedserius.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jeff Schwartz wrote:

> We've have a mySQL/PHP calendar application with a relatively small
> number of users. But that number is expected to grow to 1MM in the near
> future.
>
> Can mySQL handle traffic at that level?
>
> Is there anybody out there using it on that scale?
>
> Thanks,
> Jeff
> --

Jeff,
I did an inventory on my ISP's service (over a dedicated 56K) for the past
8 months by parsing my message logs into a mysql database.  Then it was
version 3.21.18.  The resultant table became 2.5 Million records and about
200 Meg.  On a PII MMX 233 it sifted through it in about 60 seconds per
query.  I don't know if that gives you any indication.  I think what
you're looking at is a pretty powerful machine, or you could also do some
custom clustering to put it together.  I think it's doable at about 100K
users on a single cpu machine, but at the numbers you're talking be
prepared to put some $$ into the machine.
Regards,
Van

--
=========================================================================
Linux rocks!!!   www.dedserius.com
=========================================================================