Question

Assume that you want to know which Mysql Server options were set to custom values. Which two methods would you use to find out?

a) Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
b) Check the command-line options provided for the Mysql Server and compare them with default values.
c) Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
d) Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.

Answer 1

To determine custom MySQL Server options, check the configuration files against default values or use SHOW GLOBAL VARIABLES to compare the current settings with defaults.

Step-by-step explanation:

To determine which MySQL Server options were set to custom values, you can use two methods:

1. Check the configuration files in the order in which they are read by the MySQL Server and compare them with default values to see if any custom settings have been applied.
2. Use the SHOW GLOBAL VARIABLES command to get a list of all the current variables along with their values and then compare them to the default values, usually available in the MySQL documentation or by installing a fresh MySQL server with default settings.

These approaches will allow you to effectively identify any variables that have been changed from their default settings.