MySQL Forums
Forum List  »  Triggers

Re: Debug audit trigger design
Posted by: Peter Brawley
Date: January 07, 2021 12:26PM

Simplest might be to enable the General Query Log, have the Trigger log diagnostic info including time, and thus identify the culprit process.

Depending on the app language, a trace module with logging https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html) might also be informative.

Options: ReplyQuote


Subject
Views
Written By
Posted
678
January 07, 2021 11:07AM
Re: Debug audit trigger design
317
January 07, 2021 12:26PM
299
January 08, 2021 01:59AM
297
January 08, 2021 09:04AM


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.