Slow Connections to Mysql Server

Slow Connections to Mysql Server

Postby 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
traufeisen
 
Posts: 10
Joined: Fri 03 Apr 2009 08:39

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL