Re: Storage capacity

[Jacky Shu]

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