Hello,
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.
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.
Comment