List:General Discussion« Previous MessageNext Message »
From:Jason Dixon Date:April 19 2005 5:35pm
Subject:Table is full
View as plain text  
I'm trying to do an update to one of my tables, but I'm getting the 
"table <name> is full" error.  I've reviewed the manual 
(http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems 
to apply.  I looked at the output of myisamchk, and everything looks 
fine.  The table file is only ~100M, and the partition has almost 4G of 
free space.  The proposed update would only add approx 1byte per row, 
so I just don't see how this query can cause a full table.  Can someone 
clue me in here?

[root@prajna root]# myisamchk -dv /var/db/mysql/pflabel/statstest.MYI

MyISAM file:         /var/db/mysql/pflabel/statstest.MYI
Record format:       Packed
Character set:       latin1 (8)
File-version:        1
Creation time:       2005-04-19 12:00:51
Recover time:        2005-04-19 12:03:44
Status:              checked,analyzed
Auto increment key:              1  Last value:               2022514
Data records:              1911283  Deleted blocks:                 0
Datafile parts:            1911283  Deleted data:                   0
Datafile pointer (bytes):        4  Keyfile pointer (bytes):        4
Datafile length:         104946052  Keyfile length:          74199040
Max datafile length:    4294967294  Max keyfile length: 4398046510079
Recordlength:                  550

table description:
Key Start Len Index   Type                     Rec/key         Root  
Blocksize
1   1     4   unique  unsigned long                  1      5110784     
   1024
2   260   255 multip. char packed stripped       12574     27400192     
   2048
3   535   8   multip. ulonglong                     16     50799616     
   1024
4   543   8   multip. ulonglong                    186     74198016     
   1024


Thanks,

--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net

Thread
Table is fullJason Dixon19 Apr
  • Re: Table is full [SOLVED]Jason Dixon19 Apr