List,
I'm having some serious problems with MySQL. I have some PHP and perl
scripts that do INSERTs into MySQL. Multiple times during the day various
tables become corrupted.
Repairing the table using myisamchk with "-r" usually fixes the problem,
but sometimes I have to restart mysqld to get things working again. Any
ideas as to what is going on or how to fix this?
/var/site/mysql/libexec/mysqld -V
/var/site/mysql/libexec/mysqld Ver 3.23.36 for unknown-openbsd2.7 on i386
/var/site/mysql/bin/myisamchk: ISAM file
/var/site/mysql/var/MailingList/MailingList.MYI
/var/site/mysql/bin/myisamchk: error: Size of datafile is: 280400 Should be:
281328
/var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to
record outside datafile
/var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4723 Should
be: 4738
/var/site/mysql/bin/myisamchk: warning: Found 4723 parts Should be: 4738
parts
MyISAM-table '/var/site/mysql/var/MailingList/MailingList.MYI' is corrupted
Fix it using switch "-r" or "-o"
/var/site/mysql/bin/myisamchk: ISAM file
/var/site/mysql/var/bob/announcements_mailinglist.MYI
/var/site/mysql/bin/myisamchk: error: Size of datafile is: 203460 Should be:
204312
/var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to
record outside datafile
/var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4783 Should
be: 4804
/var/site/mysql/bin/myisamchk: warning: Found 4783 parts Should be: 4804
parts
MyISAM-table '/var/site/mysql/var/bob/announcements_mailinglist.MYI' is
corrupted
Fix it using switch "-r" or "-o"
/var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/bob/contest.MYI
/var/site/mysql/bin/myisamchk: error: Size of datafile is: 195772 Should be:
196040
/var/site/mysql/bin/myisamchk: error: Found key at page 35840 that points to
record outside datafile
/var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4358 Should
be: 4364
/var/site/mysql/bin/myisamchk: warning: Found 4358 parts Should be: 4364 par
ts
MyISAM-table '/var/site/mysql/var/bob/contest.MYI' is corrupted
Fix it using switch "-r" or "-o"
/var/site/mysql/bin/myisamchk: MyISAM file
/var/site/mysql/var/bob/bob_eval.MYI
/var/site/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed
the table properly
/var/site/mysql/bin/myisamchk: error: Size of datafile is: 3276 Should be:
3344
/var/site/mysql/bin/myisamchk: error: Found key at page 1024 that points to
record outside datafile
/var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 96 Should
be: 98
/var/site/mysql/bin/myisamchk: warning: Found 96 parts Should be: 98 parts
MyISAM-table '/var/site/mysql/var/bob/bob_eval.MYI' is corrupted
Fix it using switch "-r" or "-o"
---------------------------------------------------------------------
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
