SQL statement logging output has been revised to a single-line JSON format and includes the timestamp, user, and IP-address of the client making the request. This new format should allow easier ingestion of these logs into external monitoring systems. The following configuration options now output in this format:
SQL_DEBUG LOG_STMT
SQL_DEBUG LOG_STMT_TIMES
SQL_DEBUG LOG_STMT_TIMES_FETCH
Example Output
{"timestamp":"Fri Aug 24 11:56:24 2020","ipaddr":"::ffff:127.0.0.1","db":"CTREESQL","user":"admin","thread":23,"operation":"OPEN","exectime":7,"tmptime":2,"statement":"select * from syscolumns order by width "}
The SQL_DEBUG LOG_STMT_TIMES format has been changed as follows:
In the case of a parameterized string, SQL_DEBUG LOG_STMT_TIMES does not log the parameter value anymore.