List:General Discussion« Previous MessageNext Message »
From:Eric Mayers Date:January 9 2002 12:07am
Subject:RE: 2 GB limit reached
View as plain text  
Dennis, 

You may want to look into using InnoDB tables.  I believe InnoDB tables
are immune to the 2gb limit (which usually comes from the filesystem).
Also, InnoDB claims that the innodb tables are faster than MyISAM tables
in some cases.  See www.innodb.com or
http://www.mysql.com/doc/I/n/InnoDB_overview.html for further detail.

Eric Mayers

-----Original Message-----
From: Dennis [mailto:dennis@stripped]
Sent: Tuesday, January 08, 2002 3:31 PM
To: mysql@stripped
Subject: RE: 2 GB limit reached



We have a database that seems to have grown too large, and now any 
operation fails on it. How can we fix this?

Dennis
Thread
RE: 2 GB limit reachedDennis9 Jan
  • Re: 2 GB limit reachedRandy Katz9 Jan
  • Re: 2 GB limit reachedDan Nelson9 Jan
    • Re: 2 GB limit reachedDennis9 Jan
      • Re: 2 GB limit reachedJeremy Zawodny9 Jan
    • Suggestions - FullText ??Jon Shoberg10 Jan
      • Re: Suggestions - FullText ??Amir Aliabadi13 Jan
RE: 2 GB limit reachedEric Mayers9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedJeremy Zawodny9 Jan
      • Re: 2 GB limit reachedDennis9 Jan
        • RE: 2 GB limit reachedJohnny Withers9 Jan
          • Re: 2 GB limit reachedChris Wilson9 Jan
    • Re: 2 GB limit reachedChris Wilson9 Jan
      • Re: 2 GB limit reachedChris Cooper9 Jan
RE: 2 GB limit reachedQuentin Bennett9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedDan Nelson9 Jan