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)