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.
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 -----Original Message----- From: Bence Szabo [mailto:[EMAIL PROTECTED]] Sent: Thursday, 26 September 2002 15:23 To: [EMAIL PROTECTED] Subject: what about the stability? Hi, This is my first mail to mysql list, so sorry if it is a well known (answered) question. I read lot of articles, lists before and I can not decide what about the stability of mysql when I use tables with large numers of records and many sessions? Are there any experiences with it? (Our planned system about 5M records and intensive web based queryes, I don't know exactly estimated how many concurrent sessions) Thanks -- This mail sent by Bence Szabo <[EMAIL PROTECTED]> --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
