No one will be able to answer your question effectively because none of us
know anything about your hardware and the design of your software and
queries.
But I can reassure you that MySQL is extremely fast. I have databases that
handle many millions of queries per day on databases several gigabytes in
size. With careful design and the right hardware, you can really make MySQL
hum.
If you are worried about potential load problems, I highly recommend that
you build your program such that you can load balance users across multiple
machines in some way if needed. Unfortunately I can't give you any
suggestions for doing so because again, I don't know much about your
configuration.
______________________
Brett Error
SuperStats.com
Free Visitor Statistics for your Website
http://www.superstats.com
> -----Original Message-----
> From: Jeff Schwartz [mailto:Jeff@stripped]
> Sent: Thursday, March 11, 1999 3:19 PM
> To: mySQL list
> Subject: How large a database can mySQL handle?
>
>
> 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
> --
> SuperCalendar highlights your calendar with color and stickers.
> Create your free SuperCalendar today!
>
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread59@stripped
>
> To unsubscribe, e-mail the address in the List-Unsubscribe header.
> For additional commands, e-mail: mysql-help@stripped
>
