server_id in logging tables shows the global value while the session one can be different

set @output.save= @@global.log_output;

set global log_output='TABLE';

set server_id= 22;

set long_query_time=0.00001;

select sleep(0.1);

select server_id, sql_text from mysql.slow_log;

select server_id, argument from mysql.general_log;

set global log_output= @output.save;

select server_id, sql_text from mysql.slow_log;

server_id	sql_text

1	set long_query_time=0.00001

1	select sleep(0.1)

select server_id, argument from mysql.general_log;

server_id	argument

1	set server_id= 22

1	set long_query_time=0.00001

1	select sleep(0.1)

1	select server_id, sql_text from mysql.slow_log

1	select server_id, argument from mysql.general_log