|
Starting from 10.0 server_id has SESSION scope where it can be different from the global value. However, mysql.general_log and mysql.slow_log tables still store the global value.
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;
|
|
10.5 1b12e251
|
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
|
|