CODEWITHSUNDEEP
mysqltriggerslogging
patorjk
patorjk

Reputation: 2182

Logging Queries Generated by Triggers in MySQL

Is there a way to log queries generated by triggers in MySQL in the General Query Log? My General Query Log doesn't seem to pick these up.

Also, if a query generated by a trigger exceeds the threshold for slow queries, will it be logged in the slow query log?

Upvotes: 3

Views: 1164

Answers (1)

ajreal
ajreal

Reputation: 47321

Yup, via binary log for stored programs (stored procedures and functions, triggers, and events)

Upvotes: 2

Related Questions