1SET @start_global_value = @@global.innodb_ft_num_word_optimize; 2SELECT @start_global_value; 3@start_global_value 42000 5Valid values are zero or above 6select @@global.innodb_ft_num_word_optimize >=1000; 7@@global.innodb_ft_num_word_optimize >=1000 81 9select @@global.innodb_ft_num_word_optimize; 10@@global.innodb_ft_num_word_optimize 112000 12select @@session.innodb_ft_num_word_optimize; 13ERROR HY000: Variable 'innodb_ft_num_word_optimize' is a GLOBAL variable 14show global variables like 'innodb_ft_num_word_optimize'; 15Variable_name Value 16innodb_ft_num_word_optimize 2000 17show session variables like 'innodb_ft_num_word_optimize'; 18Variable_name Value 19innodb_ft_num_word_optimize 2000 20select * from information_schema.global_variables where variable_name='innodb_ft_num_word_optimize'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_FT_NUM_WORD_OPTIMIZE 2000 23select * from information_schema.session_variables where variable_name='innodb_ft_num_word_optimize'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_FT_NUM_WORD_OPTIMIZE 2000 26set global innodb_ft_num_word_optimize=1000; 27select @@global.innodb_ft_num_word_optimize; 28@@global.innodb_ft_num_word_optimize 291000 30select * from information_schema.global_variables where variable_name='innodb_ft_num_word_optimize'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_FT_NUM_WORD_OPTIMIZE 1000 33select * from information_schema.session_variables where variable_name='innodb_ft_num_word_optimize'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_FT_NUM_WORD_OPTIMIZE 1000 36set session innodb_ft_num_word_optimize=1000; 37ERROR HY000: Variable 'innodb_ft_num_word_optimize' is a GLOBAL variable and should be set with SET GLOBAL 38set global innodb_ft_num_word_optimize=1.1; 39ERROR 42000: Incorrect argument type to variable 'innodb_ft_num_word_optimize' 40set global innodb_ft_num_word_optimize=1e1; 41ERROR 42000: Incorrect argument type to variable 'innodb_ft_num_word_optimize' 42set global innodb_ft_num_word_optimize="foo"; 43ERROR 42000: Incorrect argument type to variable 'innodb_ft_num_word_optimize' 44set global innodb_ft_num_word_optimize=-7; 45Warnings: 46Warning 1292 Truncated incorrect innodb_ft_num_word_optimize value: '-7' 47select @@global.innodb_ft_num_word_optimize; 48@@global.innodb_ft_num_word_optimize 491000 50select * from information_schema.global_variables where variable_name='innodb_ft_num_word_optimize'; 51VARIABLE_NAME VARIABLE_VALUE 52INNODB_FT_NUM_WORD_OPTIMIZE 1000 53SET @@global.innodb_ft_num_word_optimize = @start_global_value; 54SELECT @@global.innodb_ft_num_word_optimize; 55@@global.innodb_ft_num_word_optimize 562000 57