mysql 出现 mysqladmin flush-hosts和频繁死锁

mysqladmin flush-hosts

mysql 突然链接不上，报如下错误
Caused by: com.mysql.cj.exceptions.CJException: null, message from server: “Host ‘192.168.1.42’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’”
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490

这个因为mysql连接数不够用
linux my.cnf更改连接数
windows my.ini更改连接数

max_connections = 500

频繁update 和insert 导致死锁

innodb_lock_wait_timeout=30     #锁请求超时时间(秒)
innodb_print_all_deadlocks = ON  #死锁都保存到错误日志
lock_wait_timeout=30  #所有引擎
innodb_deadlock_detect = ON