want to record the committer of sql

[linquan92]

Now，we can set @@tidb_general_log=1 and record all the SQL statements in the log. But the committer of SQL is not recorded in the log. We want to make analysis on the details of the SQL.
Can tidb support to the committer of every SQL？The demo of log can add the committer of SQL based on the tidb_slow_query.log
Like this:
[info] cost_time:582.76183ms succ:true connection_id:457 txn_start_ts:399880415363465346 database:a table_ids:[] index_ids:[] committer:xxx sql:select count(1) from a.b;

[XuHuaiyu]

Hi, @powqabc , thank you for your feedback.
The committer you mentioned here is the user with which the session login?

[linquan92]

Yes.
There is an other question.Is each record a complete statement without carriage return?
Thank you.

[shenli]

@powqabc Good suggestion!

[melin]

Json format is recommended to facilitate parsing

[lysu]

Should we add src-ip/src-port of sql emitter at the same time? or make user easy found that though connid?
@coocood @shenli

[coocood]

@lysu the host is included in the user string.