Blocked because of many connection errors

Hi. I’m regularly getting the error ‘Host ‘XX.XX.XX.XX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’’

It doesn’t make a load of sense to me because there are never more than 70 connections and the max connections is set to 1000.

Below is the status I had whilst this error was occurring and when I flushed hosts, I was able to reconnect and the status showed now change to the results.

Does anyone know what my problem is?

Thanks

Chris

mysql> SHOW STATUS LIKE '%conn%';
+-------------------------------------------------------+---------------------+
| Variable_name                                         | Value               |
+-------------------------------------------------------+---------------------+
| Aborted_connects                                      | 20202               |
| Connection_errors_accept                              | 0                   |
| Connection_errors_internal                            | 0                   |
| Connection_errors_max_connections                     | 0                   |
| Connection_errors_peer_address                        | 1                   |
| Connection_errors_select                              | 0                   |
| Connection_errors_tcpwrap                             | 0                   |
| Connections                                           | 179894              |
| Locked_connects                                       | 0                   |
| Max_used_connections                                  | 67                  |
| Max_used_connections_time                             | 2022-02-28 12:03:07 |
| Mysqlx_connection_accept_errors                       | 0                   |
| Mysqlx_connection_errors                              | 0                   |
| Mysqlx_connections_accepted                           | 0                   |
| Mysqlx_connections_closed                             | 0                   |
| Mysqlx_connections_rejected                           | 0                   |
| Performance_schema_session_connect_attrs_longest_seen | 115                 |
| Performance_schema_session_connect_attrs_lost         | 0                   |
| Ssl_client_connects                                   | 0                   |
| Ssl_connect_renegotiates                              | 0                   |
| Ssl_finished_connects                                 | 0                   |
| Threads_connected                                     | 45                  |
+-------------------------------------------------------+---------------------+
22 rows in set (0.00 sec)

mysql> SHOW variables LIKE '%conn%';;
+-----------------------------------------------+--------------------+
| Variable_name                                 | Value              |
+-----------------------------------------------+--------------------+
| character_set_connection                      | utf8mb4            |
| collation_connection                          | utf8mb4_0900_ai_ci |
| connect_timeout                               | 10                 |
| disconnect_on_expired_password                | ON                 |
| init_connect                                  |                    |
| max_connect_errors                            | 100                |
| max_connections                               | 1000               |
| max_user_connections                          | 0                  |
| mysqlx_connect_timeout                        | 30                 |
| mysqlx_max_connections                        | 100                |
| performance_schema_session_connect_attrs_size | 512                |
+-----------------------------------------------+--------------------+
11 rows in set (0.00 sec)

I am pretty sure this may help: [Solved] MySql Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts… | DebugAH

Thanks very much Sascha!

1 Like