D-Rock D-Rock - 1 year ago 200
MySQL Question

Are MySQL Triggers Asynchronous

When an AFTER UPDATE or AFTER INSERT trigger is fired is it a synchronous or asynchronous event? In other words does it hold up the total execution time of the query that tripped the trigger?

Answer Source

Trigger are not asynch. Yes, they will increase the time it takes for an update or insert to complete.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download