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
13538
May 12, 2005 02:10AM
5759
May 12, 2005 03:30AM
4986
May 12, 2005 09:24AM
4469
December 13, 2005 07:39PM
4283
December 14, 2005 04:09AM
4331
December 16, 2005 01:43PM
4574
December 19, 2005 12:06PM
Re: Storage capacity
4674
December 19, 2005 01:29PM
6570
June 19, 2007 02:57AM
4020
June 19, 2007 03:05AM
4410
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.