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?
Attempting to set the global variable connection_control_min_connection_delay to 3000 while the connection_control_max_connection_delay is still at 2000 will result in an error. The value of connection_control_min_connection_delay cannot exceed connection_control_max_connection_delay. Therefore, the command will fail and return an error.
root@localhost[(none)]> show variables like '%connection_control_max_connection_delay%'; +-----------------------------------------+-------+ | Variable_name | Value | +-----------------------------------------+-------+ | connection_control_max_connection_delay | 2000 | +-----------------------------------------+-------+ 1 row in set (0.00 sec) root@localhost[(none)]> SET GLOBAL connection_control_min_connection_delay=3000; ERROR 1231 (42000): Variable 'connection_control_min_connection_delay' can't be set to the value of '3000'
First Max value need to change