Hi, I have a table that has now reached 4gb but I thought that shouldn't be a problem since the table is running with raid. I noticed that the Datafile length has reached the Max Datafile length and I tried to increase it with myisamchk -r --data-file-length=8589934588 with no success. Do I need to clean the table up bigtime or can I increase this somehow? Can anyone please help me? :)
Best regards, Gudmundur uname -a: Linux cartman 2.4.9-6smp #1 SMP Thu Oct 18 09:22:57 EDT 2001 i686 unknown myisamchk -dv: MyISAM file: data Record format: Packed Character set: latin1 (8) File-version: 1 Creation time: 2001-06-28 13:29:11 Recover time: 2001-12-28 15:18:12 Status: changed Auto increment key: 1 Last value: 450036 RAID: Type: 1 Chunks: 6 Chunksize: 65536 Data records: 295294 Deleted blocks: 0 Datafile parts: 295294 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 Datafile length: 4294912120 Keyfile length: 8341504 Max datafile length: 4294967294 Max keyfile length: 4398046510079 Recordlength: 131 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php