SQL debug logs

EventNative support SQL debug logs: DDL statements as well as CRUD queries. This feature is disabled by default. For enabling it - fill sql_debug_log section in the configuration:

sql_debug_log:
ddl:
path: <sql_debug_log_path_directory> or "global" constant
rotation_min: 10 # optional, default is 5 minutes. If set 0, 24 hours would be kept
max_backups: 20 # optional, log files won't be deleted if not set
queries:
path: <sql_debug_log_path_directory> or "global" constant
rotation_min: 10 # optional, default is 5 minutes. If set 0, 24 hours would be kept
max_backups: 20 # optional, log files won't be deleted if not set

There are two sections with the same parameters - ddl and queries. Depending on what section is configured, the logger writes only DDL, only CRUD, or both types of queries. If both types of logging are configured to write to the same directory, DDL logs will have *-ddl-debug* name pattern and CRUD logs will have *-sql-debug* names.

Field

Description

path

(required)

For writing SQL debug logs to global application logs use the constant: global

For writing to separate files use a path to the dir

rotation_min

How often files should be rotated (will be ignored if global)

max_backups

How many old log files should be kept. By default, all old log files will be kept.

(will be ignored if global)