mikadit
10-9-07, 09:04 AM
I'm wondering if a FLUSH of few table could help time to time to solve connections problems. So I woulded like to test it out, just to see what the phpmyadmin would report after flushing, error or what else. But this is not allowed, which is the main reason? It's not necessary or it could cause problem to the server?
Here a link to the MySQL documentation:
http://dev.mysql.com/doc/refman/5.0/en/flush.html
When more than max_connect_errors errors occur successively for a given host while connecting to the MySQL server, MySQL assumes that something is wrong and blocks the host from further connection requests. Flushing the host tables allows the host to attempt to connect again.
Here a link to the MySQL documentation:
http://dev.mysql.com/doc/refman/5.0/en/flush.html
When more than max_connect_errors errors occur successively for a given host while connecting to the MySQL server, MySQL assumes that something is wrong and blocks the host from further connection requests. Flushing the host tables allows the host to attempt to connect again.