1SET @start_global_value = @@global.aria_pagecache_age_threshold; 2select @@global.aria_pagecache_age_threshold; 3@@global.aria_pagecache_age_threshold 4300 5select @@session.aria_pagecache_age_threshold; 6ERROR HY000: Variable 'aria_pagecache_age_threshold' is a GLOBAL variable 7show global variables like 'aria_pagecache_age_threshold'; 8Variable_name Value 9aria_pagecache_age_threshold 300 10show session variables like 'aria_pagecache_age_threshold'; 11Variable_name Value 12aria_pagecache_age_threshold 300 13select * from information_schema.global_variables where variable_name='aria_pagecache_age_threshold'; 14VARIABLE_NAME VARIABLE_VALUE 15ARIA_PAGECACHE_AGE_THRESHOLD 300 16select * from information_schema.session_variables where variable_name='aria_pagecache_age_threshold'; 17VARIABLE_NAME VARIABLE_VALUE 18ARIA_PAGECACHE_AGE_THRESHOLD 300 19set global aria_pagecache_age_threshold=200; 20select @@global.aria_pagecache_age_threshold; 21@@global.aria_pagecache_age_threshold 22200 23set session aria_pagecache_age_threshold=1; 24ERROR HY000: Variable 'aria_pagecache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL 25set global aria_pagecache_age_threshold=1.1; 26ERROR 42000: Incorrect argument type to variable 'aria_pagecache_age_threshold' 27set global aria_pagecache_age_threshold=1e1; 28ERROR 42000: Incorrect argument type to variable 'aria_pagecache_age_threshold' 29set global aria_pagecache_age_threshold="foo"; 30ERROR 42000: Incorrect argument type to variable 'aria_pagecache_age_threshold' 31set global aria_pagecache_age_threshold=1; 32Warnings: 33Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '1' 34select @@global.aria_pagecache_age_threshold; 35@@global.aria_pagecache_age_threshold 36100 37set global aria_pagecache_age_threshold=@@global.aria_pagecache_age_threshold + 100 - 1; 38Warnings: 39Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '199' 40select @@global.aria_pagecache_age_threshold; 41@@global.aria_pagecache_age_threshold 42100 43set global aria_pagecache_age_threshold=@@global.aria_pagecache_age_threshold + 100; 44select @@global.aria_pagecache_age_threshold; 45@@global.aria_pagecache_age_threshold 46200 47set global aria_pagecache_age_threshold=cast(-1 as unsigned int); 48Warnings: 49Note 1105 Cast to unsigned converted negative integer to it's positive complement 50Note 1105 Cast to unsigned converted negative integer to it's positive complement 51Warning 1292 Truncated incorrect aria_pagecache_age_threshold value: '18446744073709551615' 52select @@global.aria_pagecache_age_threshold; 53@@global.aria_pagecache_age_threshold 5418446744073709551600 55SET @@global.aria_pagecache_age_threshold = @start_global_value; 56