Host "X" is blocked due to many connection errors
mysql stuck with this message
Mysql2 :: Error: host 'X' is blocked due to many connection errors; unblock flash hosts with mysqladmin
in the meantime, I am getting a lot of timeouts from Rails
ActiveRecord :: ConnectionTimeoutError: Failed to get database connection for 5 seconds (expected 5.00223 seconds). The maximum pool size is currently 5; think about increasing it.
Is mysql hitting ActiveRecord every time? Can Rails timeouts cause mysql blocking?
Or are they two errors due to too many problems / lack of resources?
+3
source to share
1 answer
First increase the size of the connection pool.
Connection Pool size Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; MinimumPoolSize=10;maximumpoolsize=50;
You can try a different / mysql connection string here. http://www.connectionstrings.com/mysql
0
source to share