Connection pool weirdness

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Desperado
Posts: 8
Joined: Mon 08 Nov 2004 08:05
Location: Norway

Connection pool weirdness

Post by Desperado » Tue 18 Jan 2005 08:56

Got a weird problem turning on connection pooling with version 2.50

After a time, i will start getting "max pool size reached" errors, even with a pool size of 100.

Looking at the database server at the time, it only had 20 open connections or so, suggesting that the connections have been closed on the server side, and the MySQL.net client not quite realizing this.

Setting a timeout value for the pool doesnt help either, nor does setting direct = false.

This is my connection string:


User=user;
Password=password;
Host=host;
Database=db;
Pooling=true;
Connection Lifetime=60;
Max Pool Size=100;
Min Pool Size=0;
Direct=true

Also, 99% of my database access is through data adapters.

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: Connection pool weirdness

Post by Oleg » Tue 18 Jan 2005 10:34

Known problems with connection pool were fixed in MySQLDirect .NET v2.70.
Please download the last version of our product (2.70.2).

Desperado
Posts: 8
Joined: Mon 08 Nov 2004 08:05
Location: Norway

Post by Desperado » Tue 18 Jan 2005 10:36

Thanks, i will give it a try :)

gift

upgrading

Post by gift » Wed 26 Jan 2005 09:05

I have a license for 2.7.0, how can i upgrade to the new one?

Devart
Site Admin
Posts: 3974
Joined: Tue 26 Oct 2004 13:51

Post by Devart » Thu 27 Jan 2005 14:43

You can download the last version from registered users area.
Use login information from the registration email.

Post Reply