-
Task
-
-
Major
-
Resolution:
Won't Fix
-
-
-
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...
{"report":{"fcp":839.8000000119209,"ttfb":245.9000000357628,"pageVisibility":"visible","entityId":97485,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"a1293b12-7fde-4631-b318-8ec8598655c6","navigationType":0,"readyForUser":976.1000000238419,"redirectCount":0,"resourceLoadedEnd":957.4000000357628,"resourceLoadedStart":252,"resourceTiming":[{"duration":59.700000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":252,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":252,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":311.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":69.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":252.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":252.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":321.4000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":118.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":252.60000002384186,"connectEnd":252.60000002384186,"connectStart":252.60000002384186,"domainLookupEnd":252.60000002384186,"domainLookupStart":252.60000002384186,"fetchStart":252.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":252.60000002384186,"responseEnd":371,"responseStart":371,"secureConnectionStart":252.60000002384186},{"duration":207.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":252.70000004768372,"connectEnd":252.70000004768372,"connectStart":252.70000004768372,"domainLookupEnd":252.70000004768372,"domainLookupStart":252.70000004768372,"fetchStart":252.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":252.70000004768372,"responseEnd":459.9000000357628,"responseStart":459.9000000357628,"secureConnectionStart":252.70000004768372},{"duration":209.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":254.10000002384186,"connectEnd":254.10000002384186,"connectStart":254.10000002384186,"domainLookupEnd":254.10000002384186,"domainLookupStart":254.10000002384186,"fetchStart":254.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":254.10000002384186,"responseEnd":463.80000001192093,"responseStart":463.80000001192093,"secureConnectionStart":254.10000002384186},{"duration":210,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":254.30000001192093,"connectEnd":254.30000001192093,"connectStart":254.30000001192093,"domainLookupEnd":254.30000001192093,"domainLookupStart":254.30000001192093,"fetchStart":254.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":254.30000001192093,"responseEnd":464.30000001192093,"responseStart":464.30000001192093,"secureConnectionStart":254.30000001192093},{"duration":210.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":254.5,"connectEnd":254.5,"connectStart":254.5,"domainLookupEnd":254.5,"domainLookupStart":254.5,"fetchStart":254.5,"redirectEnd":0,"redirectStart":0,"requestStart":254.5,"responseEnd":464.7000000476837,"responseStart":464.7000000476837,"secureConnectionStart":254.5},{"duration":263.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":254.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":254.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":518.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":210.4000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":254.80000001192093,"connectEnd":254.80000001192093,"connectStart":254.80000001192093,"domainLookupEnd":254.80000001192093,"domainLookupStart":254.80000001192093,"fetchStart":254.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":254.80000001192093,"responseEnd":465.2000000476837,"responseStart":465.2000000476837,"secureConnectionStart":254.80000001192093},{"duration":263.4000000357628,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":255,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":255,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":518.4000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":210.5999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":255.20000004768372,"connectEnd":255.20000004768372,"connectStart":255.20000004768372,"domainLookupEnd":255.20000004768372,"domainLookupStart":255.20000004768372,"fetchStart":255.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":255.20000004768372,"responseEnd":465.80000001192093,"responseStart":465.80000001192093,"secureConnectionStart":255.20000004768372},{"duration":572.6999999880791,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":261.80000001192093,"connectEnd":261.80000001192093,"connectStart":261.80000001192093,"domainLookupEnd":261.80000001192093,"domainLookupStart":261.80000001192093,"fetchStart":261.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":261.80000001192093,"responseEnd":834.5,"responseStart":834.5,"secureConnectionStart":261.80000001192093},{"duration":573.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":262,"connectEnd":262,"connectStart":262,"domainLookupEnd":262,"domainLookupStart":262,"fetchStart":262,"redirectEnd":0,"redirectStart":0,"requestStart":262,"responseEnd":835.5,"responseStart":835.5,"secureConnectionStart":262},{"duration":266.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":530.6000000238419,"connectEnd":530.6000000238419,"connectStart":530.6000000238419,"domainLookupEnd":530.6000000238419,"domainLookupStart":530.6000000238419,"fetchStart":530.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":530.6000000238419,"responseEnd":797.1000000238419,"responseStart":797.1000000238419,"secureConnectionStart":530.6000000238419},{"duration":176.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":832.3000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":832.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1008.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":102.40000003576279,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":855,"connectEnd":855,"connectStart":855,"domainLookupEnd":855,"domainLookupStart":855,"fetchStart":855,"redirectEnd":0,"redirectStart":0,"requestStart":855,"responseEnd":957.4000000357628,"responseStart":957.4000000357628,"secureConnectionStart":855}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":87,"responseStart":245,"responseEnd":261,"domLoading":250,"domInteractive":1042,"domContentLoadedEventStart":1042,"domContentLoadedEventEnd":1084,"domComplete":1884,"loadEventStart":1884,"loadEventEnd":1885,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1017.1000000238419},{"name":"bigPipe.sidebar-id.end","time":1018.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1018.4000000357628},{"name":"bigPipe.activity-panel-pipe-id.end","time":1020.8000000119209},{"name":"activityTabFullyLoaded","time":1091.1000000238419}],"measures":[],"correlationId":"dde16b5f788c81","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":99,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}