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
220
January 07, 2021 11:07AM
Re: Debug audit trigger design
71
January 07, 2021 12:26PM
68
January 08, 2021 01:59AM
74
January 08, 2021 09:04AM


Sorry, only registered users may post in this forum.

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.