Slow Connections to Mysql Server

traufeisen · 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     [email protected] on test
                 382957 Connect     [email protected] on test
090803 17:18:02  382958 Connect     [email protected] on test
                 382959 Connect     [email protected] on test
090803 17:18:03  382960 Connect     [email protected] on test
090803 17:18:04  382961 Connect     [email protected] on test
                 382962 Connect     [email protected] on test
090803 17:18:05  382963 Connect     [email protected] on test
                 382964 Connect     [email protected] on test
090803 17:18:06  382965 Connect     [email protected] on test
                 382966 Connect     [email protected] on test
090803 17:18:07  382967 Connect     [email protected] on test
                 382968 Connect     [email protected] on test
090803 17:18:08  382969 Connect     [email protected] on test
                 382970 Connect     [email protected] on test
090803 17:18:09  382971 Connect     [email protected] 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 · 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.