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