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
Subject
Views
Written By
Posted
14746
May 12, 2005 02:10AM
6082
May 12, 2005 03:30AM
5422
May 12, 2005 09:24AM
4751
December 13, 2005 07:39PM
4599
December 14, 2005 04:09AM
4638
December 16, 2005 01:43PM
4918
December 19, 2005 12:06PM
Re: Storage capacity
5143
December 19, 2005 01:29PM
6891
June 19, 2007 02:57AM
18542
August 30, 2008 02:26PM
4160
April 17, 2009 10:08PM
4347
June 19, 2007 03:05AM
4812
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.