1use information_schema; 2select variable_name, s.variable_value, v.global_value 3from global_variables s join system_variables v using (variable_name) 4where not (s.variable_value <=> v.global_value); 5variable_name variable_value global_value 6select variable_name, s.variable_value, v.session_value 7from session_variables s join system_variables v using (variable_name) 8where v.variable_scope != 'GLOBAL' and 9not (s.variable_value <=> v.session_value); 10variable_name variable_value session_value 11