Page 1 of 1

Slow initial connection to mysql

Posted: Thu 25 Jun 2009 19:15
by KW
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.

Re: Slow initial connection to mysql

Posted: Fri 26 Jun 2009 23:45
by KW
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.