I’ve got strange problem, and can’t google right answer.
Every 5-10 minutes mysql declines to accept 1-2 connections, showing the error code 1130: Host ‘X.X.X.X’ is not allowed to connect to this MySQL server, and successfully accepts the rest.
To replicate this issue, i’m using php script, with 30 forks that connects/disconnects to selected Percona server with all the same login/password/db.
And usually, every 5-10 minutes i see 2-3 errors at a time. At the same time, the rest of the threads are connecting fine.
There’s no errors in /var/log/messages, or at mysql .err log.
It’s Debian Squeeze server, Percona 5.1.54 built from sources.
If you have ANY ideas what could it be, please let me know.