MySQL Forums
Forum List  »  Performance

Re: 127 Error Handler
Posted by: Harrison Fisk
Date: October 30, 2004 09:55AM


The issue is that you are using non-transactional tables. The above is how MyISAM tables work, they assume that they will operate uninterrupted. You can use an option like --myisam-recover if you choose, which will cause MySQL to automatically try to repair the table if it is corrupted.

The other option is to switch your tables to InnoDB. InnoDB is a transactional table type, meaning you can do all of the BEGIN/COMMIT/SAVEPOINT operations that you are used to with Oracle. You can read more about InnoDB at or just the concept of different storage engines at

Harrison Fisk, Trainer and Consultant

Options: ReplyQuote

Written By
October 30, 2004 04:42AM
Re: 127 Error Handler
October 30, 2004 09:55AM

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.