Slow Connections to Mysql Server
Posted: 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:
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
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
The mysqld already runs with "skip-name-resolve" and the network connection is good too.
I´m using dotconnect 5.40.37.0