[MDEV-28672] Several server options / settings still not visible from SQL level Created: 2022-05-26  Updated: 2022-12-28

Status: Open
Project: MariaDB Server
Component/s: Configuration, Information Schema
Affects Version/s: 10.5.8
Fix Version/s: 11.1

Type: Bug Priority: Minor
Reporter: Daniel Black Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: beginner-friendly

Issue Links:
Issue split
split to MDEV-30188 Ensure all binlog* variables are visi... Closed
split to MDEV-30189 Add and alias remaining mariadbd repl... Open
Relates
relates to MDEV-24815 Add 'allow-suspicious-udfs' and 'skip... Closed

 Description   

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 ...?

 Comments   
Comment by Daniel Black [ 2022-05-26 ]

Original from MDEV-24815. See that MDEV for options and categories of variables to exclude (plugin enable/disables/alias/deprecated ones/perf schema settings).

Paraphrased from hholzgra:

debug / testing options:

  • debug-abort-slave-event-count
  • debug-disconnect-slave-event-count
  • debug-gdb
  • debug-max-binlog-dump-events
  • debug-no-sync
  • debug-sporadic-binlog-dump-fail
  • safe-mode

Replication options

  • binlog-do-db
  • binlog-ignore-db
  • binlog-row-event-max-size
  • master-info-file
  • master-retry-count
  • replicate-rewrite-db
  • replicate-same-server-id
  • show-slave-auth-info
  • skip-slave-start

skip-grant-tables - resolved in MDEV-25419

bootstrap maybe of use.

Remaining cases that seem to be valid, and do not fit into other categories above:

  • allow-suspicious-udfs resolved in MDEV-24815
  • aria-log-dir-path
  • des-key-file
  • innodb-status-file
  • log-ddl-recovery
  • log-isam
  • log-tc
  • memlock
  • old-style-user-limits,,
  • safe-user-create
  • silent-startup
  • skip-host-cache
  • ssl
  • stack-trace
  • sysdate-is-now
  • tc-heuristic-recover
  • transaction-isolation
  • transaction-read-only
Comment by Brandon Nesterenko [ 2022-12-09 ]

The replication options will be handled in different subtasks. Specifically:

Generated at Thu Feb 08 10:02:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.