"Paul McNeil" <[EMAIL PROTECTED]> wrote: > So this means that my DB driver is somehow using the same connection when I > ask it to create 2 different ones?
No way, it uses different connections. *BUT* check your DB interface. It can store the connection handle and don't really open a new connection when requested but instead return the previous open handle. This is how mysql_pconnect in PHP and connect_cached in DBI works. > -----Original Message----- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Monday, August 09, 2004 12:13 PM > To: [EMAIL PROTECTED] > Subject: Re: Multiple Connections > > > "Paul McNeil" <[EMAIL PROTECTED]> 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. > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]