Forum Discussion
mySQL connections staying open or failing
Microsoft Employee
gman wrote:
Hi,
I keep getting many connectoins error and being locked out and needing to flush hosts when accesssing my mySQL server and it looks like PowerBI is leaving connections open or accruing a bunch of failed connections.
I currently have PowerBI sceduled with the enterprise gateway and dashboard are refreshed throughout the day.
Before everything, make sure your database and driver meet the requirement, check Power BI Data Source Prerequisites.
May I know where did you observe that bold part? Based on my test and observation(command "show processlist"), when refreshing the dataset of MySQL from PBI Service, connections would be established from Gateway and terminated after sleeping for about 300 seconds. I don't see any connection failed or left open for very long time. So can you confirm what application are the problematic connections from?
If those connections are indeed from the gateway, try to restart or re-install it. If re-installation doesn't work, you may have to submit a support ticket to microsoft. For more gateway troubleshooting, click here.
By the way, google tells that connections can be timed out by some server options in MySQL, check whether this link would work or not.