Forum Discussion
mySQL connections staying open or failing
I know this is an old thread, but I'll post just in case someone stumbles across this like I have while searching for a fix to this problem. There's not a lot of information about this issue, I've been experiencing the same problem where the Aborted_connections value increments over time as the web service refreshes reports, eventually hitting the top and blocking the host.
It doesn't appear to be related to the length of time the connection is open for, because the aborted_connections value increments almost instantly when the web service starts a refresh. From what I can read around the place it appears that the Power BI web service, or the gateway makes one or more unauthenticated connection attempts to the MySQL server for every table that it queries. I have a report which queries nine tables and every time it refreshes itself the Aborted_connections value goes up by 54!
Microsoft is apparently aware of this problem but there is not a fix on the horizon any time soon. Some people have suggested just setting the global max_connection_errors variable to some large number but this is hardly a good fix, in fact it only delays this problem from manifesting in the hope that the hosts table will be flushed before that number is reached.
I found some help in this thread here:
To get around this issue I've slightly increased the number of connection attempts before MySQL blocks a host and an automated task that just flushes the hosts table periodically, this is less than the ideal solution, however it is effective.