RE: maximum number of records in a table

[John Mancuso]

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:paul@stripped] 
Sent: Tuesday, June 19, 2007 4:53 PM
To: kalin@stripped; mysql@stripped
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/mysql?unsub=1