MySQL Forums
Forum List  »  MyISAM

mysql crashing nightmare
Posted by: stefano noferini
Date: March 31, 2005 04:09AM

Just wondering about the corrupted .MYI in datatables. First of all it happens too often and i cant keep having fixin these tables. Plus my whole project goes bummer when crash occurs.

First i like to know what is causing this crash? is it half wrriten data in the table or is this a problem related to ppl intentionaly using some mysql bug to produce this error.

ive tryed it on many versions 4.0.20 4.0.22 and now on 4.1.10a , they are all vunerable to this

also im thinking if the reason for this is half written data in the table, then transactional tables would be the answer, but never tryed it and dont know if its gonna be of any help

is there a way to prevent this? or How can i make my tables more reliable?

someboby please help me here
stefano

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql crashing nightmare
3770
March 31, 2005 04:09AM
2445
March 31, 2005 10:30PM
2552
April 25, 2005 03:07AM


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.