List:General Discussion« Previous MessageNext Message »
From:Jeff Brewer Date:September 12 2000 2:00pm
Subject:RE: MySQL Limits...
View as plain text  
Bill,

MySQL 3.23 supports tables of up to 8,000 GB on the underlying file system
but 3.22 only goes up to 2GB.  I found that RedHat 6.1 supports files larger
than 2GB on Alphas but not on Intels.  As far as the number of rows, I've
got indexed tables with 250 million plus rows.  Look in the MySQL
documentation for more specific information.

Jeff Brewer

-----Original Message-----
From: Bill Hess [mailto:bhess@stripped]
Sent: Monday, September 11, 2000 10:21 PM
To: mysql@stripped
Subject: Re: MySQL Limits...


What file sizes can Solaris support?
How about Linux - Red Hat 6.1/6.2?

Bill Hess - Technology Resource Group


> On Mon, Sep 11, 2000 at 09:03:22PM -0400, Bill Hess wrote:
>
> > What are some of the "upper limits" of MySQL - that is maximum
> > number of rows in a table, database size, etc... Or where can I go
> > look for them
>
> Don't have an easy answer. It should be in a FAQ somewhere, since
> someone asks just about every other day.
>
> > I am looking at having some tables which may be 20-25 million rows
> > plus (with indexes) - will I run into problems because of the table
> > size?
>
> You shouldn't have any problem provided that your OS has support for
> files big enough to hold the data.
>
> Jeremy
> --
> Jeremy D. Zawodny, <jzawodn@stripped>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878    Fax: (408) 530-5454
> Cell: (408) 439-9951


--
---------------------------------------------------------------------
Please check "http://www.mysql.com/php/manual.php" before
posting. To request this thread, e-mail mysql-thread50389@stripped

To unsubscribe, send a message to:
    <mysql-unsubscribe-jeff=fatkat.com@stripped>

If you have a broken mail client that cannot send a message to the above
address(Microsoft Outlook), you can use
http://lists.mysql.com/php/unsubscribe.php

Thread
MySQL Limits...Bill Hess12 Sep
  • Re: MySQL Limits...Jeremy D. Zawodny12 Sep
  • Re: MySQL Limits...Bill Hess12 Sep
    • RE: MySQL Limits...Jeff Brewer12 Sep
      • Re: MySQL Limits...Jeremy D. Zawodny12 Sep
      • ODBC in FoxPro with char fieldsfritz13 Sep
        • Re: ODBC in FoxPro with char fieldsfritz13 Sep
Re: MySQL Limits...Richard Ellerbrock12 Sep