We have 1/2 a billion records in one Innodb table on one server. Still extremely quick. The only limit is hardware
John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 4:53 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: maximum number of records in a table At 6:24 PM -0400 6/11/07, kalin mintchev wrote: >hi all... > >from http://dev.mysql.com/doc/refman/5.0/en/features.html: > >"Handles large databases. We use MySQL Server with databases that >contain 50 million records. We also know of users who use MySQL Server >with 60,000 tables and about 5,000,000,000 rows." > >that's cool but i assume this is distributed over a few machines... No. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]