MySQL : How to know if Trigger was fired Someone can help me please , I want to log error about triggers in MySQL 5.5
I'll like to know if it's possible to know if a trigger was'nt fired ?
You can do it the hard way by enabling MySQL logging (all SQL queries will be logged). I'm doing it when I'm trying to debug &amp; understand complex code base with big amount of SQL queries, with SQL procedures, events &amp; triggers. It's ugly, but it works.

https://support.plesk.com/hc/en-us/articles/213374189-How-to-enable-MySQL-logging-

How to Log All mysql queries into log file?

Debian-based systems:
/etc/mysql/my.cnf

[mysqld]
# Set Slow Query Log
long_query_time = 1
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
log_queries_not_using_indexes = 1

# Set General Log
general_log = on
general_log_file = /var/log/mysql/mysql-general.log