1SET @start_global_value = @@global.innodb_ft_ignore_stopwords; 2SELECT @start_global_value; 3@start_global_value 40 5Valid values are 'ON' and 'OFF' 6SELECT @@global.innodb_ft_ignore_stopwords IN (0, 1); 7@@global.innodb_ft_ignore_stopwords IN (0, 1) 81 9SELECT @@global.innodb_ft_ignore_stopwords; 10@@global.innodb_ft_ignore_stopwords 110 12SELECT @@session.innodb_ft_ignore_stopwords IN (0, 1); 13@@session.innodb_ft_ignore_stopwords IN (0, 1) 141 15SELECT @@session.innodb_ft_ignore_stopwords; 16@@session.innodb_ft_ignore_stopwords 170 18SHOW GLOBAL VARIABLES LIKE 'innodb_ft_ignore_stopwords'; 19Variable_name Value 20innodb_ft_ignore_stopwords OFF 21SHOW SESSION VARIABLES LIKE 'innodb_ft_ignore_stopwords'; 22Variable_name Value 23innodb_ft_ignore_stopwords OFF 24SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 25VARIABLE_NAME VARIABLE_VALUE 26innodb_ft_ignore_stopwords OFF 27SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 28VARIABLE_NAME VARIABLE_VALUE 29innodb_ft_ignore_stopwords OFF 30SET GLOBAL innodb_ft_ignore_stopwords = 'OFF'; 31SET SESSION innodb_ft_ignore_stopwords = 'OFF'; 32SELECT @@global.innodb_ft_ignore_stopwords; 33@@global.innodb_ft_ignore_stopwords 340 35SELECT @@session.innodb_ft_ignore_stopwords; 36@@session.innodb_ft_ignore_stopwords 370 38SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 39VARIABLE_NAME VARIABLE_VALUE 40innodb_ft_ignore_stopwords OFF 41SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 42VARIABLE_NAME VARIABLE_VALUE 43innodb_ft_ignore_stopwords OFF 44SET @@global.innodb_ft_ignore_stopwords = 1; 45SET @@session.innodb_ft_ignore_stopwords = 1; 46SELECT @@global.innodb_ft_ignore_stopwords; 47@@global.innodb_ft_ignore_stopwords 481 49SELECT @@session.innodb_ft_ignore_stopwords; 50@@session.innodb_ft_ignore_stopwords 511 52SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 53VARIABLE_NAME VARIABLE_VALUE 54innodb_ft_ignore_stopwords ON 55SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 56VARIABLE_NAME VARIABLE_VALUE 57innodb_ft_ignore_stopwords ON 58SET GLOBAL innodb_ft_ignore_stopwords = 0; 59SET SESSION innodb_ft_ignore_stopwords = 0; 60SELECT @@global.innodb_ft_ignore_stopwords; 61@@global.innodb_ft_ignore_stopwords 620 63SELECT @@session.innodb_ft_ignore_stopwords; 64@@session.innodb_ft_ignore_stopwords 650 66SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 67VARIABLE_NAME VARIABLE_VALUE 68innodb_ft_ignore_stopwords OFF 69SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 70VARIABLE_NAME VARIABLE_VALUE 71innodb_ft_ignore_stopwords OFF 72SET @@global.innodb_ft_ignore_stopwords = 'ON'; 73SET @@session.innodb_ft_ignore_stopwords = 'ON'; 74SELECT @@global.innodb_ft_ignore_stopwords; 75@@global.innodb_ft_ignore_stopwords 761 77SELECT @@session.innodb_ft_ignore_stopwords; 78@@session.innodb_ft_ignore_stopwords 791 80SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 81VARIABLE_NAME VARIABLE_VALUE 82innodb_ft_ignore_stopwords ON 83SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 84VARIABLE_NAME VARIABLE_VALUE 85innodb_ft_ignore_stopwords ON 86SET GLOBAL innodb_ft_ignore_stopwords = 1.1; 87ERROR 42000: Incorrect argument type to variable 'innodb_ft_ignore_stopwords' 88SET SESSION innodb_ft_ignore_stopwords = 1.1; 89ERROR 42000: Incorrect argument type to variable 'innodb_ft_ignore_stopwords' 90SET GLOBAL innodb_ft_ignore_stopwords = 1e1; 91ERROR 42000: Incorrect argument type to variable 'innodb_ft_ignore_stopwords' 92SET SESSION innodb_ft_ignore_stopwords = 1e1; 93ERROR 42000: Incorrect argument type to variable 'innodb_ft_ignore_stopwords' 94SET GLOBAL innodb_ft_ignore_stopwords = 2; 95ERROR 42000: Variable 'innodb_ft_ignore_stopwords' can't be set to the value of '2' 96SET SESSION innodb_ft_ignore_stopwords = 2; 97ERROR 42000: Variable 'innodb_ft_ignore_stopwords' can't be set to the value of '2' 98SET GLOBAL innodb_ft_ignore_stopwords = 'AUTO'; 99ERROR 42000: Variable 'innodb_ft_ignore_stopwords' can't be set to the value of 'AUTO' 100SET SESSION innodb_ft_ignore_stopwords = 'AUTO'; 101ERROR 42000: Variable 'innodb_ft_ignore_stopwords' can't be set to the value of 'AUTO' 102SET GLOBAL innodb_ft_ignore_stopwords = -3; 103ERROR 42000: Variable 'innodb_ft_ignore_stopwords' can't be set to the value of '-3' 104SET SESSION innodb_ft_ignore_stopwords = -7; 105ERROR 42000: Variable 'innodb_ft_ignore_stopwords' can't be set to the value of '-7' 106SELECT @@global.innodb_ft_ignore_stopwords; 107@@global.innodb_ft_ignore_stopwords 1081 109SELECT @@session.innodb_ft_ignore_stopwords; 110@@session.innodb_ft_ignore_stopwords 1111 112SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 113VARIABLE_NAME VARIABLE_VALUE 114innodb_ft_ignore_stopwords ON 115SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_ft_ignore_stopwords'; 116VARIABLE_NAME VARIABLE_VALUE 117innodb_ft_ignore_stopwords ON 118SET GLOBAL innodb_ft_ignore_stopwords = @start_global_value; 119SELECT @@global.innodb_ft_ignore_stopwords; 120@@global.innodb_ft_ignore_stopwords 1210 122