Viewing Configuration Parameter Values

You can view active configuration parameter values in two ways:

SHOW Statements

Use the following SHOW statements to view active configuration parameters:

If a configuration parameter requires a restart to take effect, the values in a SHOW CURRENT statement might differ from values in other SHOW statements. To see which parameters require restart, query the CONFIGURATION_PARAMETERS system table.

System Tables

You can query two system tables for configuration parameters: