E.g. the actual used values of allow-suspicious-udfs and skip-grant-tables can't be seen in SHOW GLOBAL VARIABLES output, and are not listed in INFORMATION_SCHEMA.SYSTEM_VARIABLES either.
As both of these settings have security implications it should be possible to see their current value from the SQL level though, for audit / secure configuration check purposes.
Especially with the now added GLOBAL_VALUE_ORIGIN and GLOBAL_VALUE_PATH information in I_S SYSTEM_VARIABLES, every setting that can be done via command line or my.cnf should actually be visible in SYSTEM_VARIABLES ...?
- relates to
-
MDEV-28672
Several server options / settings still not visible from SQL level
-
-
Open
{"report":{"fcp":1222.5999999940395,"ttfb":274.2999999821186,"pageVisibility":"visible","entityId":96745,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"1ca1e837-b5d1-4e24-958f-fd96dee89c67","navigationType":0,"readyForUser":1308,"redirectCount":0,"resourceLoadedEnd":1509.5,"resourceLoadedStart":287.7999999821186,"resourceTiming":[{"duration":255.40000000596046,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":287.7999999821186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":287.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":543.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":255.40000000596046,"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":288.09999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":288.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":543.5,"responseStart":0,"secureConnectionStart":0},{"duration":294.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":288.2999999821186,"connectEnd":288.2999999821186,"connectStart":288.2999999821186,"domainLookupEnd":288.2999999821186,"domainLookupStart":288.2999999821186,"fetchStart":288.2999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":288.2999999821186,"responseEnd":583.0999999940395,"responseStart":583.0999999940395,"secureConnectionStart":288.2999999821186},{"duration":605.2999999821186,"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":288.5,"connectEnd":288.5,"connectStart":288.5,"domainLookupEnd":288.5,"domainLookupStart":288.5,"fetchStart":288.5,"redirectEnd":0,"redirectStart":0,"requestStart":288.5,"responseEnd":893.7999999821186,"responseStart":893.7999999821186,"secureConnectionStart":288.5},{"duration":609.7999999821186,"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":288.59999999403954,"connectEnd":288.59999999403954,"connectStart":288.59999999403954,"domainLookupEnd":288.59999999403954,"domainLookupStart":288.59999999403954,"fetchStart":288.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":288.59999999403954,"responseEnd":898.3999999761581,"responseStart":898.3999999761581,"secureConnectionStart":288.59999999403954},{"duration":610.3000000119209,"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":288.7999999821186,"connectEnd":288.7999999821186,"connectStart":288.7999999821186,"domainLookupEnd":288.7999999821186,"domainLookupStart":288.7999999821186,"fetchStart":288.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":288.7999999821186,"responseEnd":899.0999999940395,"responseStart":899.0999999940395,"secureConnectionStart":288.7999999821186},{"duration":610.5999999940395,"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":289,"connectEnd":289,"connectStart":289,"domainLookupEnd":289,"domainLookupStart":289,"fetchStart":289,"redirectEnd":0,"redirectStart":0,"requestStart":289,"responseEnd":899.5999999940395,"responseStart":899.5999999940395,"secureConnectionStart":289},{"duration":620,"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":289.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":289.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":909.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":610.6000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":289.39999997615814,"connectEnd":289.39999997615814,"connectStart":289.39999997615814,"domainLookupEnd":289.39999997615814,"domainLookupStart":289.39999997615814,"fetchStart":289.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":289.39999997615814,"responseEnd":900,"responseStart":900,"secureConnectionStart":289.39999997615814},{"duration":619.7999999821186,"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":289.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":289.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":909.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":610.9000000059605,"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":289.7999999821186,"connectEnd":289.7999999821186,"connectStart":289.7999999821186,"domainLookupEnd":289.7999999821186,"domainLookupStart":289.7999999821186,"fetchStart":289.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":289.7999999821186,"responseEnd":900.6999999880791,"responseStart":900.6999999880791,"secureConnectionStart":289.7999999821186},{"duration":1209.0999999940395,"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":290.59999999403954,"connectEnd":290.59999999403954,"connectStart":290.59999999403954,"domainLookupEnd":290.59999999403954,"domainLookupStart":290.59999999403954,"fetchStart":290.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":290.59999999403954,"responseEnd":1499.699999988079,"responseStart":1499.699999988079,"secureConnectionStart":290.59999999403954},{"duration":1209.699999988079,"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":290.59999999403954,"connectEnd":290.59999999403954,"connectStart":290.59999999403954,"domainLookupEnd":290.59999999403954,"domainLookupStart":290.59999999403954,"fetchStart":290.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":290.59999999403954,"responseEnd":1500.2999999821186,"responseStart":1500.2999999821186,"secureConnectionStart":290.59999999403954},{"duration":343,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":732.5,"connectEnd":732.5,"connectStart":732.5,"domainLookupEnd":732.5,"domainLookupStart":732.5,"fetchStart":732.5,"redirectEnd":0,"redirectStart":0,"requestStart":732.5,"responseEnd":1075.5,"responseStart":1075.5,"secureConnectionStart":732.5},{"duration":333.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1167.5999999940395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1167.5999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1501.0999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":333.19999998807907,"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":1168.5,"connectEnd":1168.5,"connectStart":1168.5,"domainLookupEnd":1168.5,"domainLookupStart":1168.5,"fetchStart":1168.5,"redirectEnd":0,"redirectStart":0,"requestStart":1168.5,"responseEnd":1501.699999988079,"responseStart":1501.699999988079,"secureConnectionStart":1168.5},{"duration":340.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1169,"connectEnd":1169,"connectStart":1169,"domainLookupEnd":1169,"domainLookupStart":1169,"fetchStart":1169,"redirectEnd":0,"redirectStart":0,"requestStart":1169,"responseEnd":1509.5,"responseStart":1509.5,"secureConnectionStart":1169},{"duration":346.40000000596046,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1215.7999999821186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1215.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1562.199999988079,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":116,"responseStart":274,"responseEnd":285,"domLoading":286,"domInteractive":1563,"domContentLoadedEventStart":1563,"domContentLoadedEventEnd":1604,"domComplete":2789,"loadEventStart":2789,"loadEventEnd":2791,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1505.7999999821186},{"name":"bigPipe.sidebar-id.end","time":1506.699999988079},{"name":"bigPipe.activity-panel-pipe-id.start","time":1506.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":1509.0999999940395},{"name":"activityTabFullyLoaded","time":1620.0999999940395}],"measures":[],"correlationId":"2249815d6dbbc0","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":99,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}