How does the MySQL server behave with incorrectly spelled options?

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:
[mysqld]
Loq-bin
Binrylog_format=ROW
You do not notice the spelling error in binrylog_format and restart your production server.
How does the MySQL server behave with incorrectly spelled options?

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:
[mysqld]
Loq-bin
Binrylog_format=ROW
You do not notice the spelling error in binrylog_format and restart your production server.
How does the MySQL server behave with incorrectly spelled options?

A.
Mysqld uses internal configuration versioning and reverts to the previous configuration.

B.
When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and
typing mistakes.

C.
The mysqld_safe script skips the unknown variable and starts using the remaining configuration
changes.

D.
Mysqld prints to the error log about an unknown variable, and then exits.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *