Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
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 |
Attachments
Issue Links
- relates to
-
MDEV-7567 rename slow queries variables
- Closed
-
MDEV-8931 (server part of) session state tracking
- Closed
-
MDEV-29297 remove aliases of system variables
- Open
-
MDEV-31746 Problems with tx_isolation after MDEV-21921
- Closed