1SET @start_value = @@global.innodb_max_changed_pages; 2SELECT @start_value; 3@start_value 41000000 5SET @@global.innodb_max_changed_pages = 5000; 6SET @@global.innodb_max_changed_pages = DEFAULT; 7SELECT @@global.innodb_max_changed_pages; 8@@global.innodb_max_changed_pages 91000000 10SET @@global.innodb_max_changed_pages = 0; 11SELECT @@global.innodb_max_changed_pages; 12@@global.innodb_max_changed_pages 130 14SET @@global.innodb_max_changed_pages = 1; 15SELECT @@global.innodb_max_changed_pages; 16@@global.innodb_max_changed_pages 171 18SET @@global.innodb_max_changed_pages = 18446744073709551614; 19SELECT @@global.innodb_max_changed_pages; 20@@global.innodb_max_changed_pages 2118446744073709551614 22SET @@global.innodb_max_changed_pages = 18446744073709551615; 23SELECT @@global.innodb_max_changed_pages; 24@@global.innodb_max_changed_pages 2518446744073709551615 26SET @@global.innodb_max_changed_pages = 18446744073709551616; 27ERROR 42000: Incorrect argument type to variable 'innodb_max_changed_pages' 28SELECT @@global.innodb_max_changed_pages; 29@@global.innodb_max_changed_pages 3018446744073709551615 31SET @@global.innodb_max_changed_pages = 18446744073709551617; 32ERROR 42000: Incorrect argument type to variable 'innodb_max_changed_pages' 33SELECT @@global.innodb_max_changed_pages; 34@@global.innodb_max_changed_pages 3518446744073709551615 36SET @@global.innodb_max_changed_pages = 105.54; 37ERROR 42000: Incorrect argument type to variable 'innodb_max_changed_pages' 38SELECT @@global.innodb_max_changed_pages; 39@@global.innodb_max_changed_pages 4018446744073709551615 41SET @@global.innodb_max_changed_pages = -200; 42Warnings: 43Warning 1292 Truncated incorrect innodb_max_changed_pages value: '-200' 44SELECT @@global.innodb_max_changed_pages; 45@@global.innodb_max_changed_pages 460 47SET @@global.innodb_max_changed_pages = ON; 48ERROR 42000: Incorrect argument type to variable 'innodb_max_changed_pages' 49SELECT @@global.innodb_max_changed_pages; 50@@global.innodb_max_changed_pages 510 52SET @@global.innodb_max_changed_pages = 'foo'; 53ERROR 42000: Incorrect argument type to variable 'innodb_max_changed_pages' 54SELECT @@global.innodb_max_changed_pages; 55@@global.innodb_max_changed_pages 560 57SET @@session.innodb_max_changed_pages = 4096; 58ERROR HY000: Variable 'innodb_max_changed_pages' is a GLOBAL variable and should be set with SET GLOBAL 59SELECT @@session.innodb_max_changed_pages; 60ERROR HY000: Variable 'innodb_max_changed_pages' is a GLOBAL variable 61SELECT @@global.innodb_max_changed_pages = VARIABLE_VALUE 62FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 63WHERE VARIABLE_NAME='innodb_max_changed_pages'; 64@@global.innodb_max_changed_pages = VARIABLE_VALUE 651 66Warnings: 67Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 68SELECT @@global.innodb_max_changed_pages = VARIABLE_VALUE 69FROM INFORMATION_SCHEMA.SESSION_VARIABLES 70WHERE VARIABLE_NAME='innodb_max_changed_pages'; 71@@global.innodb_max_changed_pages = VARIABLE_VALUE 721 73Warnings: 74Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 75SET @@global.innodb_max_changed_pages=6789; 76SELECT @@global.innodb_max_changed_pages=@@innodb_max_changed_pages; 77@@global.innodb_max_changed_pages=@@innodb_max_changed_pages 781 79SET @@global.innodb_max_changed_pages=@start_value; 80SELECT @@global.innodb_max_changed_pages; 81@@global.innodb_max_changed_pages 821000000 83