MySQL Forums
Forum List  »  Triggers

Use event schedule rather than trigger?
Posted by: Darren White
Date: March 09, 2012 02:16AM

I have been using a TRIGGER to log data from one table to another. The TRIGGER is called on UPDATE. The problem is that I want to limit how often data is logged. This is proving difficult with a TRIGGER (at least for me).

Yesterday I was introduced to the Event Scheduler, which I am now using to dump the log tables out to csv files and empty the tables once a day.

Now I am wondering if I would be better off just using the event scheduler to do logging too then I could just specify a time period for data to logged?

What are the pros vs cons here?

Options: ReplyQuote

Written By
Use event schedule rather than trigger?
March 09, 2012 02:16AM

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.