Connection pool multi-threaded?

Connection pool multi-threaded?

Postby gwerner » Mon 07 Mar 2005 20:17

Using MySQLDirect in an ASP.Net application. Specifying connection string with pooling=true, and using MySQL 4.1.10-nt via TCP/IP.

It looks like connection pooling is working just fine for all communications on the same thread (ie the same page load), but each new thread will not reuse the connection pool. They all seem to be loading new connections.

By the way, is there any way to make MySQL login faster? The server we're testing on is running at 2% CPU, but it still takes 2 seconds or so to login using MySQLDirect. The servers are on the same segment.

Postby Serious » Wed 09 Mar 2005 12:59

Connection pool serves all threads within the current App Domain.
Pay attention that connection is taken from connection pool only if there is a connection closed earlier.
Possibly, you open new connections having not closed other connections before. In this case (when connection pool is empty) new connections to server is created.

As to login performance. We have tested this functionlality and got the results that differ much from yours (0.08..0.7 sec). Maybe the problem is in the configuration of your MySQL Server.

Postby gwerner » Thu 10 Mar 2005 18:01

Definately could be a problem with my configuration, as it's very odd indeed. I'll do some Google searching to see why the login is taking so long.

I wonder if having it on an alternate port changes things.... Hmmmmm.....

Postby gwerner » Thu 10 Mar 2005 18:35

Turns out I had reverse DNS enabled in MySQL. Amazing how much difference it made.

Return to dotConnect for MySQL