Mistake:
A recent error was found in the logs as follows:Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Cause: Baidu searched for the reason: the same IP generated too many interrupted database connections (exceeding the maximum value of mysql database max_connection_errors) in a short period of time.
Workaround:Increase the number of max_connection_errors allowedGo to the Mysql database to view the max_connection_errors: Option 1:The number of modified max_connection_errors is 1000 Or go directly to my.cnf to configure
Add under [mysqld] Then restart mysql
You can then check if this parameter is in effect Option 2: Reset the number of error recordsGo to the database and execute the commandmax_connect_errors If this parameter has not been set, the default max_connect_errors = 10, you can set the parameter a little larger to avoid being locked.
If you have a master/slave master-slave database, you need to modify both the master and slave databases.
| 
Posted on 6/10/2019 10:41:06 AM
|
|
|
