Yes let it finish. Never stop a repair in progress. Now myisamchk is
rebuilding the index file since youre the table is extremely corrupt.
Myisamchk can run faster if you set some buffer properties. Put this in
youre 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-rw1 mysqlmysql8802 Nov 6 07:04 Nov03.frm
---rw-rw1 mysqlmysql8812359152 Nov 11 01:25 Nov03.MYD
---rw-rw1 mysqlmysql1024 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-rw1 mysqlmysql8812359152 Nov 11 01:25
Nov03.MYD
-rw-rw1 mysqlmysql5346325504 Nov 11 14:52
Nov03.MYI
-rw-rw1 mysqlmysql631242752 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]
