On Thursday 26 September 2002 12:35 pm, Andrew Braithwaite scribbled something
about:
> Hi Bence,
>
> We are running mysql with over 1,000 tables - plenty of them have 10
> Million to 40 Milion records (Geographic data) - about 500 concurrent
> sessions doing about 800 to 1000 queries total per second at peak.
Bence,
Out of curiosity, what kind of hardware are you using? Are you using a lot of
servers, few servers lots of processors, and/or lots of hard drives?
-Gary
>
> We haven't had any problems in the last 2.5 years. (our system is read
> heavy & light on the updates..)
>
> Make sure you get your DB design right & the optimal indexes in place :)
>
> Oh... And check out 'heap tables' for read heavy queries...
>
> Hope that helps..
>
> Cheers,
>
> Andrew
>
>
---------------------------------------------------------------------
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
