Does nobody have any ideas on this? It's quite perplexing. It's MySQL "Ver 14.6 Distrib 4.1.5-gamma", if it makes a difference.
Jon Ribbens <[EMAIL PROTECTED]> wrote: > I am getting Error 136 "No more room in index file" on a table, > but the table does not appear to be full in any way. As you can see > from the "myisamchk -dv" output below, both the datafile length and > the keyfile length are much smaller than their respective maximums. > The table is on a Linux ext3 partition and the partition is nowhere > near full. > > Does anyone know how to fix this problem? I have already tried > 'alter table foo max_rows=38807046144', which took over 30 hours > to complete and hasn't had any noticeable effect. > > $ uname -a > Linux fooserver 2.4.21-20.EL #1 Wed Aug 18 20:46:27 EDT 2004 i686 athlon i386 > GNU/Linux > > $ ls -l foo.* > -rw-rw---- 1 mysql mysql 23990598560 Feb 5 09:19 foo.MYD > -rw-rw---- 1 mysql mysql 18353124352 Feb 5 09:19 foo.MYI > -rw-rw---- 1 mysql mysql 9746 Feb 4 03:17 foo.frm > > # myisamchk -dv foo > > MyISAM file: foo > Record format: Fixed length > Character set: latin1_swedish_ci (8) > File-version: 1 > Creation time: 2005-02-04 3:17:26 > Recover time: 2005-02-05 8:59:54 > Status: open,changed > Data records: 749706205 Deleted blocks: 0 > Datafile parts: 749706205 Deleted data: 0 > Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 > Datafile length: 23990598560 Keyfile length: 18353124352 > Max datafile length: 137438953470 Max keyfile length: 4398046510079 > Recordlength: 32 > > table description: > Key Start Len Index Type Rec/key Root Blocksize > 1 2 4 unique unsigned long 0 6117707776 1024 > 2 7 4 multip. unsigned long 0 12235415552 1024 > 3 11 4 multip. unsigned long 0 18353123328 1024 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
