MySQL 8.0 Database Administrator — Question 48

The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000
The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?

Answer options

• A. The minimum value increases to 3000 and the maximum value increases to 4000.
• B. Only the minimum connection value is increased to 3000.
• C. The minimum connection value is changed to 2000.
• D. An error is returned.

Correct answer: D

Explanation

The command attempts to set the minimum connection delay to 3000, but since the maximum delay is not adjusted accordingly, it violates the rule that the minimum must be less than the maximum. Therefore, the result is an error being returned. The other options incorrectly suggest changes that do not occur due to this violation.