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]
