MySQL Forums
Forum List  »  InnoDB

Transaction logs of triggers
Posted by: Rajkumar Ponnusamy
Date: October 02, 2008 07:38PM

Hello all

I have 2 questions. First, are logs of triggers stored internally in the the transaction log of MySQL. I am not asking about mysql-bin.0000001 file (I checked it and it does not), but I am asking about the real log records that the database use for recovery. It makes sense to store them for 'undo' and 'redo' operations, but since I dont see them in mysql-bin.0000001 file, I am wondering if it actually does or not.

Second, if it does store them, is it possible to view them?

If you know any article or a page in the documentation that talks elaborately about MySQL transaction logging and recovery, please pass it on to me. I was not able to find any.

Thanks a lot
Raj

Options: ReplyQuote


Subject
Views
Written By
Posted
Transaction logs of triggers
3841
October 02, 2008 07:38PM


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.