Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5.8, 10.2, 10.3, 10.4, 10.5, 10.6
-
None
Description
I've added a custom config include file /etc/mysql/mariadb.conf.d/extra.cnf with contents
[mysqld]
|
autocommit=OFF
|
bind_address=0.0.0.0
|
Checking I_S.SYSTEM_VARIABLES for these two settings, I see that both values have been set as requested, but only for bind_address I see the correct origin and path information, while for autocommit it still claims to be using the complied-in default even though the current value is clearly different than the default:
MariaDB [(none)]> select variable_name, default_value, global_value, global_value_origin, global_value_path from information_schema.system_variables where variable_name IN ('autocommit','bind_address')\G
|
*************************** 1. row ***************************
|
variable_name: BIND_ADDRESS
|
default_value:
|
global_value: 0.0.0.0
|
global_value_origin: CONFIG
|
global_value_path: /etc/mysql/mariadb.conf.d/extra.cnf
|
*************************** 2. row ***************************
|
variable_name: AUTOCOMMIT
|
default_value: ON
|
global_value: OFF
|
global_value_origin: COMPILE-TIME
|
global_value_path: NULL
|