Access DSP system/session variables in mysql triggers?


#1

Looking for solution.

I’m using MySQL triggers to perform after insert/update and before delete logging of changes to a MySQL table.
Not considering server-side scripting at this point.

In the context of the trigger, the MySQL function USER() evaluates to “appuser@localhost” as predicted, since DF is configured to access mysql running on localhost using “appuser” credentials.

What I think I’m looking for is a connection-related or session-related variable that gets SET by DF whenever a REST API call results in a SQL statement.

I’m running on a resent version of MySQL, and so I have the performance_schema database, if that helps.

I’ve already looked at performance_schema.user_variables_by_thread, but I don’t see anything helpful within the context of a trigger instance.