Slow initial connection to mysql

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
KW
Posts: 125
Joined: Tue 19 Feb 2008 19:12

Slow initial connection to mysql

Post by KW » Thu 25 Jun 2009 19:15

I'm not sure if this has something to do with the connector or mysqld configuration.

Basically, I'm getting a slow initial connection to mysql - lets say 6-10 seconds, subsequent connections are very quick. I am running mysql 5.0 on a ubuntu installation.

Is there anyway to alleviate this initial slow connection? I am using tableadapters to connect to mysql.

KW
Posts: 125
Joined: Tue 19 Feb 2008 19:12

Re: Slow initial connection to mysql

Post by KW » Fri 26 Jun 2009 23:45

KW wrote:I'm not sure if this has something to do with the connector or mysqld configuration.

Basically, I'm getting a slow initial connection to mysql - lets say 6-10 seconds, subsequent connections are very quick. I am running mysql 5.0 on a ubuntu installation.

Is there anyway to alleviate this initial slow connection? I am using tableadapters to connect to mysql.
I think I have resolved this, I added skip-name-resolve to the mysql.cnf file, I believe this fixed the issue. Thank you.

Post Reply