Slow initial connection to mysql

Slow initial connection to mysql

Postby 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: 121
Joined: Tue 19 Feb 2008 19:12

Re: Slow initial connection to mysql

Postby 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.
KW
 
Posts: 121
Joined: Tue 19 Feb 2008 19:12


Return to dotConnect for MySQL