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 <mdyk...@gmail.com> 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.tompk...@googlemail.com> 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 > - mdyk...@gmail.com > > "May you live every day of your life." > Jonathan Swift >