List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:November 4 2009 3:36pm
Subject:Re: CONNECTION_ID() and Threads
View as plain text  
Hi

Thanks for your quick response.  In our test environment running MySQL
5.1.31 over SSL (hosted external of our network) and IIS 6 on Windows 2003
Server, I've found when opening a test connection to the database from my PC
and one from my colleagues PC on the same internal network, we both had the
same connectionID ?  Is this right ?

The reason I need to know about the CONNECTION_ID() is because we have a
issue on our website whereby not all database connections are correctly
closed.  As commented on in this URL http://bugs.mysql.com/bug.php?id=12274

Can anyone offer any advice regarding this ?

Regards
Neil

On Wed, Nov 4, 2009 at 3:27 PM, Michael Dykman <mdykman@stripped> wrote:

> Typically, a  thread works on a single connection exclusively..
> otherwise it is impossible to do anything transactional.  However, I
> have seen applications, in auto-commit mode use distinct statements
> concurrently from the same connection to do read-only work.
>
> If you are worried about the latency of creating new connections for a
> many-threaded design, you should be looking into connection pooling
> which manages the problem of maintaining many connections and only
> letting one thread have a given connection at a time.
>
>  - michael dykman
>
> On Wed, Nov 4, 2009 at 10:20 AM, Tompkins Neil
> <neil.tompkins@stripped> wrote:
> > Hi,
> >
> > With regards the CONNECTION_ID() variable in MySQL, is this based on a
> per
> > user basis.   Or can multiple users use the same connection_id ?
> >
> > Thanks,
> > Neil
> >
>
>
>
> --
>  - michael dykman
>  - mdykman@stripped
>
> "May you live every day of your life."
>    Jonathan Swift
>

Thread
CONNECTION_ID() and ThreadsTompkins Neil4 Nov
Re: CONNECTION_ID() and ThreadsTompkins Neil4 Nov
  • Re: CONNECTION_ID() and ThreadsMichael Dykman4 Nov
    • Re: CONNECTION_ID() and ThreadsTompkins Neil4 Nov
Re: CONNECTION_ID() and ThreadsTompkins Neil5 Nov
  • Re: CONNECTION_ID() and ThreadsMichael Dykman6 Nov