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
13359
May 12, 2005 02:10AM
5680
May 12, 2005 03:30AM
4901
May 12, 2005 09:24AM
4398
December 13, 2005 07:39PM
4204
December 14, 2005 04:09AM
4250
December 16, 2005 01:43PM
4492
December 19, 2005 12:06PM
Re: Storage capacity
4588
December 19, 2005 01:29PM
6494
June 19, 2007 02:57AM
3947
June 19, 2007 03:05AM
4335
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.