Details
-
New Feature
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
List in INFORMATION_SCHEMA.REMOVED_STARTUP_OPTIONS all the variables that have been set in the config file or command line and that were ignored because removed.
Description
When some settings variables are removed, they are ignored to prevent the server from failing to start.
Those variables, such as `inndodb_thread_concurrency`, are set as MARIADB_REMOVED_OPTION.
This feature will list all variables that are set and ignored, allowing a DBA or a script to identify them.
Example:
MariaDB [information_schema]> select * from REMOVED_STARTUP_OPTIONS; |
+---------------------------+--------------+--------------+-------------+----------+ |
| OPTION_NAME | OPTION_VALUE | SOURCE | CONFIG_FILE | HANDLING |
|
+---------------------------+--------------+--------------+-------------+----------+ |
| innodb-thread-concurrency | 8 | COMMAND_LINE | NULL | IGNORED | |
+---------------------------+--------------+--------------+-------------+----------+ |
1 row in set (0.001 sec) |