List:General Discussion« Previous MessageNext Message »
From:John Mancuso Date:June 20 2007 3:25am
Subject:RE: maximum number of records in a table
View as plain text  
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

Thread
maximum number of records in a tablekalin mintchev11 Jun
  • Re: maximum number of records in a tableDavid T. Ashley12 Jun
    • Re: maximum number of records in a tablekalin mintchev12 Jun
      • Re: maximum number of records in a tableOlaf Stein12 Jun
        • Re: maximum number of records in a tablekalin mintchev12 Jun
          • Re: maximum number of records in a tableJon Ribbens12 Jun
          • Re: maximum number of records in a tableOlaf Stein12 Jun
            • Re: maximum number of records in a tablekalin mintchev12 Jun
  • Re: maximum number of records in a tablePaul DuBois19 Jun
    • RE: maximum number of records in a tableJohn Mancuso20 Jun
Re: maximum number of records in a tablekalin mintchev11 Jun
Re: maximum number of records in a tableJ.R. Bullington12 Jun
  • Re: maximum number of records in a tablekalin mintchev12 Jun
  • Re: maximum number of records in a tablekalin mintchev12 Jun
Re: maximum number of records in a tableJ.R. Bullington12 Jun