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 diagnostics 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]
