|
The information_schema.system_variables table reports incorrect information for many variables:
MariaDB [(none)]> select * from information_schema.system_variables where variable_name like '%character_set_server%'\G
|
*************************** 1. row ***************************
|
VARIABLE_NAME: CHARACTER_SET_SERVER
|
SESSION_VALUE: utf8mb4
|
GLOBAL_VALUE: utf8mb4
|
GLOBAL_VALUE_ORIGIN: COMPILE-TIME
|
DEFAULT_VALUE: utf8mb4
|
VARIABLE_SCOPE: SESSION
|
VARIABLE_TYPE: ENUM
|
VARIABLE_COMMENT: The default character set
|
NUMERIC_MIN_VALUE: NULL
|
NUMERIC_MAX_VALUE: NULL
|
NUMERIC_BLOCK_SIZE: NULL
|
ENUM_VALUE_LIST: NULL
|
READ_ONLY: NO
|
COMMAND_LINE_ARGUMENT: NULL
|
1 row in set (0.00 sec)
|
I set that variable from the command line, so both GLOBAL_VALUE_ORIGIN and COMMAND_LINE_ARGUMENT are wrong.
|