|
If variable X is set to be tracked, and it has an alias X_ALIAS, and its value changes, tracking does not occur. I'm not sure whether it should (MySQL documentation at least doesn't say one way or another), but it would be logical for the purpose of having a consistent session state.
--enable_session_track_info
|
|
--echo #
|
--echo # Only max_delayed_threads is set for tracking,
|
--echo # the value changed via a synonym -- no tracking
|
--echo #
|
|
SET session_track_system_variables='max_delayed_threads';
|
|
SELECT @@max_delayed_threads;
|
SET max_insert_delayed_threads= 0;
|
|
--echo #
|
--echo # Both max_delayed_threads and the synonym are set for tracking,
|
--echo # the value changed via a synonym - only the synonym tracked
|
--echo #
|
|
SET session_track_system_variables='max_insert_delayed_threads,max_delayed_threads';
|
|
SELECT @@max_delayed_threads;
|
SET max_insert_delayed_threads= DEFAULT;
|
|
10.10 87e8463e
|
#
|
# Only max_delayed_threads is set for tracking,
|
# the value changed via a synonym -- no tracking
|
#
|
SET session_track_system_variables='max_delayed_threads';
|
SELECT @@max_delayed_threads;
|
@@max_delayed_threads
|
20
|
SET max_insert_delayed_threads= 0;
|
#
|
# Both max_delayed_threads and the synonym are set for tracking,
|
# the value changed via a synonym - only the synonym tracked
|
#
|
SET session_track_system_variables='max_insert_delayed_threads,max_delayed_threads';
|
SELECT @@max_delayed_threads;
|
@@max_delayed_threads
|
0
|
SET max_insert_delayed_threads= DEFAULT;
|
-- Tracker : SESSION_TRACK_SYSTEM_VARIABLES
|
-- max_insert_delayed_threads
|
-- 20
|
|