[unixODBC-support] RE: Connection pool on linux
bhavik at motorola.com
Mon Dec 17 13:42:26 GMT 2007
We have installed unixODBC-2.2.11-1 and we use MySQL as Backend
The Initial pool creation (lets say 60 connections created and then
subsequent creation (each time query is executed connect and disconnect
) takes same amount of time
While capturing TCP packets between MySQL and Client
We noticed the steps are same for subsequent connection i.e. create TCP
connection and do Authentication.
pool is not helping us to speed up connection setup.
Or probably there is something we are missing out from configuration.
Can any body help us out?
From: Chauhan Bhavik-A20762
Sent: Friday, December 14, 2007 11:43 AM
To: 'unixodbc-support at easysoft.com'
Subject: Connection pool on linux
we are using unixODBC and connection pool is enabled with following
configuration in odbcinst.ini
# Driver from the MyODBC package
# Setup from the unixODBC package
Trace = No
Pooling = Yes
Description = ODBC for MySQL
Driver = ./tools/odbcLibraries/libmyodbc3-3.51.14.so
Setup = ./tools/odbcLibraries/libmyodbc3-3.51.14.so
FileUsage = 1
CPTimeout = 1200
But while creating connection pool i.e. by Connect for certain number of
times and disconnect for the same, netstat shows all the TCP connection
to MySQL server as TIMED_WAIT rather than ESTABLISHED. I feel it should
be in ESTABLISHED state to reduce the connection overhead. Correct me if
I am wrong.
has anyone faced similar problem in past?
Appreciate your help in this case.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the unixODBC-support