MySQL Forums
Forum List  »  MyISAM

Re: Storage capacity
Posted by: Jacky Shu
Date: December 19, 2005 01:29PM

Ben Hollingsworth wrote:
> I've got a MyISAM table whose data file has hit
> 4GB. Any new inserts are getting a "table full"
> error. The mysql server is running Red Hat
> Enterprise AS 4.0 (i386). What can I do to
> increase the available size of this table?
> There's plenty of disk space available. Is the
> 32-bit OS limiting the size of my data file to
> 4GB, or is there some MySQL configuration I can
> change to increase it?


ALTER TABLE myisamtable MAX_ROWS=4000000000 AVG_ROW_LENGTH=100;

Jacky Shu

OCPDBA, MCDBA

Options: ReplyQuote


Subject
Views
Written By
Posted
13606
May 12, 2005 02:10AM
5787
May 12, 2005 03:30AM
5023
May 12, 2005 09:24AM
4493
December 13, 2005 07:39PM
4312
December 14, 2005 04:09AM
4360
December 16, 2005 01:43PM
4605
December 19, 2005 12:06PM
Re: Storage capacity
4707
December 19, 2005 01:29PM
6602
June 19, 2007 02:57AM
4046
June 19, 2007 03:05AM
4435
April 09, 2008 06:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.