Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5
-
None
Description
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 |