1SET @start_global_value = @@global.aria_pagecache_division_limit; 2select @@global.aria_pagecache_division_limit; 3@@global.aria_pagecache_division_limit 4100 5select @@session.aria_pagecache_division_limit; 6ERROR HY000: Variable 'aria_pagecache_division_limit' is a GLOBAL variable 7show global variables like 'aria_pagecache_division_limit'; 8Variable_name Value 9aria_pagecache_division_limit 100 10show session variables like 'aria_pagecache_division_limit'; 11Variable_name Value 12aria_pagecache_division_limit 100 13select * from information_schema.global_variables where variable_name='aria_pagecache_division_limit'; 14VARIABLE_NAME VARIABLE_VALUE 15ARIA_PAGECACHE_DIVISION_LIMIT 100 16select * from information_schema.session_variables where variable_name='aria_pagecache_division_limit'; 17VARIABLE_NAME VARIABLE_VALUE 18ARIA_PAGECACHE_DIVISION_LIMIT 100 19set global aria_pagecache_division_limit=20; 20select @@global.aria_pagecache_division_limit; 21@@global.aria_pagecache_division_limit 2220 23set session aria_pagecache_division_limit=1; 24ERROR HY000: Variable 'aria_pagecache_division_limit' is a GLOBAL variable and should be set with SET GLOBAL 25set global aria_pagecache_division_limit=1.1; 26ERROR 42000: Incorrect argument type to variable 'aria_pagecache_division_limit' 27set global aria_pagecache_division_limit=1e1; 28ERROR 42000: Incorrect argument type to variable 'aria_pagecache_division_limit' 29set global aria_pagecache_division_limit="foo"; 30ERROR 42000: Incorrect argument type to variable 'aria_pagecache_division_limit' 31set global aria_pagecache_division_limit=0; 32Warnings: 33Warning 1292 Truncated incorrect aria_pagecache_division_limit value: '0' 34select @@global.aria_pagecache_division_limit; 35@@global.aria_pagecache_division_limit 361 37set global aria_pagecache_division_limit=cast(-1 as unsigned int); 38Warnings: 39Note 1105 Cast to unsigned converted negative integer to it's positive complement 40Note 1105 Cast to unsigned converted negative integer to it's positive complement 41Warning 1292 Truncated incorrect aria_pagecache_division_limit value: '18446744073709551615' 42select @@global.aria_pagecache_division_limit; 43@@global.aria_pagecache_division_limit 44100 45SET @@global.aria_pagecache_division_limit = @start_global_value; 46