1RESET MASTER; 2SET @start_global_value = @@global.gtid_executed; 3SELECT @start_global_value; 4@start_global_value 5 6SET @start_show_compatibility_56= @@GLOBAL.SHOW_COMPATIBILITY_56; 7SELECT @start_show_compatibility_56; 8@start_show_compatibility_56 91 10SELECT @@GLOBAL.GTID_EXECUTED; 11@@GLOBAL.GTID_EXECUTED 12 13SET @@GLOBAL.SHOW_COMPATIBILITY_56= OFF; 14SELECT * FROM performance_schema.global_variables; 15SHOW WARNINGS; 16Level Code Message 17SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'gtid_executed'; 18VARIABLE_NAME VARIABLE_VALUE 19gtid_executed 20SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'gtid_%' ORDER BY VARIABLE_NAME; 21VARIABLE_NAME VARIABLE_VALUE 22gtid_executed 23gtid_executed_compression_period 1000 24gtid_mode OFF 25gtid_owned 26gtid_purged 27SHOW GLOBAL VARIABLES; 28SHOW WARNINGS; 29Level Code Message 30SELECT * FROM information_schema.global_variables; 31SHOW GLOBAL VARIABLES LIKE 'gtid_executed'; 32Variable_name Value 33gtid_executed 34SHOW GLOBAL VARIABLES LIKE 'gtid_%'; 35Variable_name Value 36gtid_executed 37gtid_executed_compression_period 1000 38gtid_mode OFF 39gtid_owned 40gtid_purged 41SET @@GLOBAL.SHOW_COMPATIBILITY_56= ON; 42SHOW GLOBAL VARIABLES; 43SHOW WARNINGS; 44Level Code Message 45SELECT * FROM information_schema.global_variables; 46SHOW WARNINGS; 47Level Code Message 48Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 49SHOW GLOBAL VARIABLES LIKE 'gtid_executed'; 50Variable_name Value 51gtid_executed 52SELECT * FROM information_schema.global_variables WHERE VARIABLE_NAME LIKE 'gtid_executed'; 53VARIABLE_NAME VARIABLE_VALUE 54GTID_EXECUTED 55Warnings: 56Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 57SHOW GLOBAL VARIABLES LIKE 'gtid_%'; 58Variable_name Value 59gtid_executed 60gtid_executed_compression_period 1000 61gtid_mode OFF 62gtid_owned 63gtid_purged 64SELECT * FROM information_schema.global_variables WHERE VARIABLE_NAME LIKE 'gtid_%' ORDER BY VARIABLE_NAME; 65VARIABLE_NAME VARIABLE_VALUE 66GTID_EXECUTED 67GTID_EXECUTED_COMPRESSION_PERIOD 1000 68GTID_MODE OFF 69GTID_OWNED 70GTID_PURGED 71Warnings: 72Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 73SET GLOBAL SHOW_COMPATIBILITY_56= OFF; 74SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME LIKE 'xyz'; 75VARIABLE_NAME VARIABLE_VALUE 76SHOW GLOBAL VARIABLES LIKE 'xyz'; 77Variable_name Value 78SET GLOBAL SHOW_COMPATIBILITY_56= ON; 79SHOW GLOBAL VARIABLES LIKE 'xyz'; 80Variable_name Value 81SELECT * FROM information_schema.global_variables WHERE VARIABLE_NAME LIKE 'xyz'; 82VARIABLE_NAME VARIABLE_VALUE 83Warnings: 84Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 85SET GLOBAL SHOW_COMPATIBILITY_56= OFF; 86# 87# gtid_executed deprecation warnings are issued 88# 89SELECT @@SESSION.GTID_EXECUTED; 90@@SESSION.GTID_EXECUTED 91 92Warnings: 93Warning 1681 '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. 94SELECT @@SESSION.GTID_EXECUTED, @@SESSION.GTID_EXECUTED; 95@@SESSION.GTID_EXECUTED @@SESSION.GTID_EXECUTED 96 97Warnings: 98Warning 1681 '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. 99SET @my_gtid_executed= @@SESSION.GTID_EXECUTED; 100Warnings: 101Warning 1681 '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. 102# 103# gtid_executed deprecation warnings are NOT issued 104# 105SET GLOBAL SHOW_COMPATIBILITY_56= ON; 106SHOW VARIABLES; 107SHOW WARNINGS; 108Level Code Message 109SHOW SESSION VARIABLES; 110SHOW WARNINGS; 111Level Code Message 112SELECT * FROM information_schema.session_variables; 113SHOW WARNINGS; 114Level Code Message 115Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 116SHOW VARIABLES LIKE 'gtid_executed'; 117Variable_name Value 118gtid_executed 119SHOW SESSION VARIABLES LIKE 'gtid_executed'; 120Variable_name Value 121gtid_executed 122SELECT * FROM information_schema.session_variables WHERE VARIABLE_NAME LIKE 'gtid_executed'; 123VARIABLE_NAME VARIABLE_VALUE 124GTID_EXECUTED 125Warnings: 126Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 127SHOW VARIABLES LIKE 'gtid_%'; 128Variable_name Value 129gtid_executed 130gtid_executed_compression_period 1000 131gtid_mode OFF 132gtid_next AUTOMATIC 133gtid_owned 134gtid_purged 135SHOW SESSION VARIABLES LIKE 'gtid_%'; 136Variable_name Value 137gtid_executed 138gtid_executed_compression_period 1000 139gtid_mode OFF 140gtid_next AUTOMATIC 141gtid_owned 142gtid_purged 143SELECT * FROM information_schema.session_variables WHERE VARIABLE_NAME LIKE 'gtid_%' ORDER BY VARIABLE_NAME; 144VARIABLE_NAME VARIABLE_VALUE 145GTID_EXECUTED 146GTID_EXECUTED_COMPRESSION_PERIOD 1000 147GTID_MODE OFF 148GTID_NEXT AUTOMATIC 149GTID_OWNED 150GTID_PURGED 151Warnings: 152Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 153SHOW VARIABLES LIKE 'xyz'; 154Variable_name Value 155SHOW SESSION VARIABLES LIKE 'xyz'; 156Variable_name Value 157SELECT * FROM information_schema.session_variables WHERE VARIABLE_NAME LIKE 'xyz'; 158VARIABLE_NAME VARIABLE_VALUE 159Warnings: 160Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 161# 162# @@session.gtid_executed is not present in P_S table and no deprecation 163# warnings ar issued 164# 165SET GLOBAL SHOW_COMPATIBILITY_56= OFF; 166SELECT * FROM performance_schema.session_variables; 167SHOW WARNINGS; 168Level Code Message 169SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME LIKE 'gtid_executed'; 170VARIABLE_NAME VARIABLE_VALUE 171SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME LIKE 'gtid_%' ORDER BY VARIABLE_NAME; 172VARIABLE_NAME VARIABLE_VALUE 173gtid_executed_compression_period 1000 174gtid_mode OFF 175gtid_next AUTOMATIC 176gtid_owned 177gtid_purged 178SHOW VARIABLES; 179SHOW WARNINGS; 180Level Code Message 181SHOW SESSION VARIABLES; 182SHOW WARNINGS; 183Level Code Message 184SHOW VARIABLES LIKE 'gtid_executed'; 185Variable_name Value 186SHOW SESSION VARIABLES LIKE 'gtid_executed'; 187Variable_name Value 188SHOW VARIABLES LIKE 'gtid_%'; 189Variable_name Value 190gtid_executed_compression_period 1000 191gtid_mode OFF 192gtid_next AUTOMATIC 193gtid_owned 194gtid_purged 195SHOW SESSION VARIABLES LIKE 'gtid_%'; 196Variable_name Value 197gtid_executed_compression_period 1000 198gtid_mode OFF 199gtid_next AUTOMATIC 200gtid_owned 201gtid_purged 202SELECT * FROM performance_schema.session_variables WHERE VARIABLE_NAME LIKE 'xyz'; 203VARIABLE_NAME VARIABLE_VALUE 204SHOW VARIABLES LIKE 'xyz'; 205Variable_name Value 206SHOW SESSION VARIABLES LIKE 'xyz'; 207Variable_name Value 208SET GLOBAL SHOW_COMPATIBILITY_56= @start_show_compatibility_56; 209set @@global.gtid_executed = ''; 210ERROR HY000: Variable 'gtid_executed' is a read only variable 211set @@session.gtid_executed = ''; 212ERROR HY000: Variable 'gtid_executed' is a read only variable 213