Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
Description
When we analyse MariaDB servers of our customers it is sometimes not clear from where (which file) a specific configuration variable is coming from.
Thus it would be greate to see the configuration source of a variable. For example:
{{SQL> SELECT * FROM information_schema.global_variables LIMIT 10; |
+----------------------------------------------+----------------+------------------------------------+ |
| VARIABLE_NAME | VARIABLE_VALUE | VARIABLE_SOURCE |
|
+----------------------------------------------+----------------+------------------------------------+ |
| INNODB_LOG_CHECKSUMS | ON | default | |
| PERFORMANCE_SCHEMA | ON | /etc/mysql/my.cnf | |
| SYSTEM_VERSIONING_ALTER_HISTORY | ERROR | /etc/mysql/conf.d/mariadb.cnf |
|
| UNIQUE_CHECKS | ON | /etc/mysql/mariadb.conf.d/blub.cnf | |
| PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 | default | |
| MAX_RELAY_LOG_SIZE | 134217728 | online |
|
| PERFORMANCE_SCHEMA_MAX_COND_CLASSES | 90 | default | |
| HAVE_RTREE_KEYS | YES | /etc/mysql/my.cnf |
|
| PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | -1 | default | |
+----------------------------------------------+----------------+------------------------------------+ |
Where variable source can be:
- A filename where it was configured
- default if it was NOT configured at all
- online if it was configured dynamic/online with SET GLOBAL ...
I have not found this FR in jira. I hope I have searched good enough...