MySQL Forums
Forum List  »  Performance

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

Hi,

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 http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html or just the concept of different storage engines at http://dev.mysql.com/doc/mysql/en/Storage_engines.html

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
4751
October 30, 2004 04:42AM
Re: 127 Error Handler
2332
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.