Slow Connections to Mysql Server

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
traufeisen
Posts: 10
Joined: Fri 03 Apr 2009 08:39

Slow Connections to Mysql Server

Post by traufeisen » Mon 03 Aug 2009 15:27

Hi,
I´m connecting to the database-server with a connectionString like this:

host=10.0.2.9;user id=test;password=test;database=test;Min Pool Size=10; Max Pool Size=100; Pooling=true

The connections to the database are made very slowly as the mysqld-query.log shows:

Code: Select all

090803 17:18:01  382956 Connect     test@10.0.1.50 on test
                 382957 Connect     test@10.0.1.50 on test
090803 17:18:02  382958 Connect     test@10.0.1.50 on test
                 382959 Connect     test@10.0.1.50 on test
090803 17:18:03  382960 Connect     test@10.0.1.50 on test
090803 17:18:04  382961 Connect     test@10.0.1.50 on test
                 382962 Connect     test@10.0.1.50 on test
090803 17:18:05  382963 Connect     test@10.0.1.50 on test
                 382964 Connect     test@10.0.1.50 on test
090803 17:18:06  382965 Connect     test@10.0.1.50 on test
                 382966 Connect     test@10.0.1.50 on test
090803 17:18:07  382967 Connect     test@10.0.1.50 on test
                 382968 Connect     test@10.0.1.50 on test
090803 17:18:08  382969 Connect     test@10.0.1.50 on test
                 382970 Connect     test@10.0.1.50 on test
090803 17:18:09  382971 Connect     test@10.0.1.50 on test
2 connections per second isn´t very good.
The mysqld already runs with "skip-name-resolve" and the network connection is good too.
I´m using dotconnect 5.40.37.0

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 05 Aug 2009 08:45

Thank you for your inquiry. We have made some performance improvements already, the new build will contain some of them.

Post Reply