MySQL Forums
Forum List  »  Newbie

Re: Corruptions like crazy
Posted by: John Bowles
Date: April 30, 2015 08:44AM

In preparation for the last test "SELECT COUNT(*) FROM tblComposerFile;" I did this.

Here you can see I have fixed all errros on the file and checked they are not showing any more.


bash-3.2# myisamchk /var/lib/mysql/musiciansjamnetwork/*.MYI >> /tmp/MyIsamErrors
bash-3.2# myisamchk /var/lib/mysql/musiciansjamnetwork/*.MYI >> /tmp/MyIsamErrors


I just added one record to each of the three files using my website page and these are the messages I get after I run the check again.


bash-3.2# myisamchk /var/lib/mysql/musiciansjamnetwork/*.MYI >> /tmp/MyIsamErrors

myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of indexfile is: 34816 Should be: 35840
myisamchk: error: Size of datafile is: 14308 Should be: 14724
myisamchk: error: Found key at page 10240 that points to record outside datafile
myisamchk: error: Record-count is not ok; is 397 Should be: 398
myisamchk: warning: Found 397 key parts. Should be: 422
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/tblComposerFile.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of indexfile is: 49152 Should be: 50176
myisamchk: error: Size of datafile is: 25212 Should be: 25644
myisamchk: error: Found 101 keys of 723
myisamchk: error: Record-count is not ok; is 722 Should be: 723
myisamchk: warning: Found 722 key parts. Should be: 748
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/tblSongNamesFile.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of indexfile is: 45056 Should be: 46080
myisamchk: error: Size of datafile is: 42714 Should be: 42756
myisamchk: error: Found 101 keys of 1018
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/tblSongsMaster.MYI' is corrupted
Fix it using switch "-r" or "-o"

================================================================
Here is the test.
mysql> select count(*) from tblComposerFile
-> ;
+----------+
| count(*) |
+----------+
| 398 |
+----------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Written By
Posted
April 29, 2015 11:33AM
April 29, 2015 11:49AM
April 29, 2015 12:20PM
April 29, 2015 12:40PM
April 29, 2015 01:04PM
April 29, 2015 01:36PM
April 29, 2015 01:48PM
April 29, 2015 02:00PM
April 29, 2015 02:59PM
April 29, 2015 03:30PM
April 29, 2015 04:24PM
April 30, 2015 07:44AM
April 30, 2015 07:48AM
Re: Corruptions like crazy
April 30, 2015 08:44AM
April 30, 2015 08:57AM
April 30, 2015 08:59AM
April 30, 2015 09:40AM
April 30, 2015 10:19AM
April 30, 2015 01:45PM
April 30, 2015 02:42PM
April 30, 2015 03:36PM
April 30, 2015 07:36PM
April 30, 2015 10:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.