Yes let it finish. Never stop a repair in progress. Now myisamchk is rebuilding the index file since you’re the table is extremely corrupt. Myisamchk can run faster if you set some buffer properties. Put this in you’re my.cnf file for next time.
[myisamchk] key_buffer=256M sort_buffer=256M read_buffer=2M write_buffer=2M - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: rmck [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, November 11, 2003 5:27 PM -->To: Dathan Vance Pattishall -->Subject: RE: Error 127 = Record-file is crashed --> -->Thank you for the reply.... --> -->Before you replied I killed the first "myisamchk" thinking I should do -->"REPAIR TABLE" -->Then your email came and I killed the "REPAIR TABLE" and -->reran -->myisamchk -rf Nov03. -->Thats whats running now "myisamchk -rf Nov03" --> -->NOW I noticed my .MYI file is at 1024K: --> -->[root]# ls -al Nov* -->-rw-rw---- 1 mysql mysql 8802 Nov 6 07:04 Nov03.frm -->-rw-rw---- 1 mysql mysql 8812359152 Nov 11 01:25 Nov03.MYD -->-rw-rw---- 1 mysql mysql 1024 Nov 11 16:33 Nov03.MYI -->-rw-r--r-- 1 root root 67108864 Nov 11 17:05 Nov03.TMD --> -->Man I really messed this up? Should I let this keep on running?? --> -->Thank You -->Rob --> -->-----Original Message----- -->From: Dathan Vance Pattishall <[EMAIL PROTECTED]> -->Sent: Nov 11, 2003 4:19 PM -->To: 'rmck' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] -->Subject: RE: Error 127 = Record-file is crashed --> --> --> -->- Dathan Vance Pattishall --> - Sr. Programmer and mySQL DBA for FriendFinder Inc. --> - http://friendfinder.com/go/p40688 --> --> -->-->-----Original Message----- -->-->From: rmck [mailto:[EMAIL PROTECTED] -->-->Sent: Tuesday, November 11, 2003 3:17 PM -->-->To: [EMAIL PROTECTED] -->-->Subject: Error 127 = Record-file is crashed -->--> -->-->Hello, -->--> -->-->I have "mysql-standard-4.0.16-pc-linux-i686" installed on a 4gig mem, -->-->2cpu system, RH 9. -->-->I have a large table (Data records: 72426930) that is now giving me -->this -->-->error "Error 127" -->-->when doing selects... -->--> -->-->This is my first crash of any kind with Mysql. So I'm a liitle -->confused -->-->on what I should do. -->-->The manual states -->-->use myisamchk, then you read further and it says use REPAIR TABLE... -->--> -->-->I'm confused can someone give me a 1 to end step on repairing this -->-->table?? -->--> -->-->At this point I brought my mysqld down. -->--> -->-->Tried running this: -->-->[root]# myisamchk -r Nov03 -->-->- recovering (with keycache) MyISAM-table 'Nov03' -->-->Data records: 72426930 -->-->myisamchk: error: Can't create new tempfile: '/opt/logs/Nov03.TMD' -->-->MyISAM-table 'Nov03' is not fixed because of errors -->-->Try fixing it by using the --safe-recover (-o) or the --force (-f) -->option -->--> -->-->So I tried this: -->-->[root]# myisamchk -rf Nov03 -->-->[EMAIL PROTECTED] ip_logs]# myisamchk -rf Nov03 -->-->- recovering (with keycache) MyISAM-table 'Nov03' -->-->Data records: 72426930 -->-->5939000 -->--> -->-->It looks like its doing something -->--> -->-->my data dir and the table in question: -->-->-rw-rw---- 1 mysql mysql 8812359152 Nov 11 01:25 Nov03.MYD -->-->-rw-rw---- 1 mysql mysql 5346325504 Nov 11 14:52 Nov03.MYI -->-->-rw-rw---- 1 mysql mysql 631242752 Nov 11 14:52 Nov03.TMD -->--> -->-->Please advise... --> -->Good you turned off mysql and ran this command. If you didn't you would -->just cause further corruption. Next the TMD file means that as myisamchk -->repairs, this temp file above is appended as the datafile is compared to -->the index file. This is to ensure that the source data file is not -->modified (yet) in case of row loss. If you need to recover the lost rows -->that occur during this repair (source data file will be stored in a .BAK -->file) then it's possible. --> -->So, what you need to do right now is wait till that 631242752 file size -->equals the 8812359152 file size. --> -->Myisamchk will report how many rows have been lost if any during the end -->of the repair. --> --> -->--> -->-->Thanks -->-->Rob -->--> -->--> -->--> -->-->-- -->-->MySQL General Mailing List -->-->For list archives: http://lists.mysql.com/mysql -->-->To unsubscribe: -->-->http://lists.mysql.com/[EMAIL PROTECTED] --> --> --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] --> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
