RE: Multiple Connections - Paul McNeil - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRE: Multiple Connections

From	Sent On	Attachments
Paul McNeil	09 Aug 2004 08:01
Egor Egorov	09 Aug 2004 09:12
Paul McNeil	09 Aug 2004 09:28
Egor Egorov	10 Aug 2004 03:20

Subject:	RE: Multiple Connections
From:	Paul McNeil (pau...@microneil.com)
Date:	08/09/2004 09:28:42 AM
List:	com.mysql.lists.mysql

So this means that my DB driver is somehow using the same connection when I ask it to create 2 different ones?

-----Original Message----- From: Egor Egorov [mailto:egor...@ensita.net] Sent: Monday, August 09, 2004 12:13 PM To: mys...@lists.mysql.com Subject: Re: Multiple Connections

"Paul McNeil" <pau...@microneil.com> wrote:

This tells me that the DB is treating my connections as the same connection. I need to know if the problem is that MySQL is caching and reusing any connection from my client OR if the problem is with my driver.

For each connection a new thread is created and this thread has every connection-dependent variables set to their default values. I.e. LAST_INSERT_ID() in a new thread will not return you a value from other.