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
