List:General Discussion« Previous MessageNext Message »
From:Aldrian Gintingsuka Date:April 12 1999 6:55am
Subject:Re: Opening multiple MySQL connections in one program (with and
without threads).
View as plain text  
Works great on my system (Solaris 2.6, MySQL 3.22.20a, egcs-1.1.2)

$ for i in 1 2 3 4 5; do tmysql $i ; done


BEHAVIOR 1: One connection, threaded.
Attempting to connect (threaded).
Connected in thread 4.
BEHAVIOR 2: Two connections, one unthreaded, one threaded.
Attempting to connect (unthreaded).
Connected (unthreaded).
Attempting to connect (threaded).
Connected in thread 4.
BEHAVIOR 3: Two connections, unthreaded.
Attempting to connect (unthreaded).
Connected (unthreaded).
First done.
Attempting to connect (unthreaded).
Connected (unthreaded).
Second done.
BEHAVIOR 4: Two connections, threaded.
Attempting to connect (threaded).
Connected in thread 4.
First done.
Attempting to connect (threaded).
Connected in thread 5.
Second done.
BEHAVIOR 5: Two connections, forked.
Attempting to connect (unthreaded).
Attempting to connect (unthreaded).
Connected (unthreaded).
Second done.
Connected (unthreaded).
First done.

========================================================================
Aldrian Gintingsuka -- Systems Consultant -- Mitra Integrasi Informatika
Phone: +62-21-251-1360 ext. 1414 -- Fax: +62-21-251-2748
Email: aldrian@stripped, aldrian@stripped
------------------------------------------------------------------------
Si tu es contre Dieu, tu es contre l'homme (Enigma: Sadeness part I)



Thread
Opening multiple MySQL connections in one program (with and without threads).terry jones12 Apr
  • Re: Opening multiple MySQL connections in one program (with and without threads).Ed Carp12 Apr
  • Re: Opening multiple MySQL connections in one program (with and without threads).terry jones12 Apr
  • Re: Opening multiple MySQL connections in one program (with and without threads).Ed Carp12 Apr
  • Re: Opening multiple MySQL connections in one program (with and without threads).Ed Carp12 Apr
  • Re: Opening multiple MySQL connections in one program (with andwithout threads).Aldrian Gintingsuka12 Apr
  • Opening multiple MySQL connections in one program (with and without threads).Michael Widenius12 Apr
  • Opening multiple MySQL connections in one program (with and without threads).terry jones12 Apr
    • Re: Opening multiple MySQL connections in one program (with andwithout threads).Ilya Obshadko12 Apr
    • Re: Opening multiple MySQL connections in one program (with andwithout threads).terry jones12 Apr
      • Re: Opening multiple MySQL connections in one program (with andwithout threads).Ilya Obshadko12 Apr
      • Re: Opening multiple MySQL connections in one program (with andwithout threads).terry jones13 Apr
  • Re: Opening multiple MySQL connections in one program (with and without threads).Ed Carp13 Apr
  • Re: Opening multiple MySQL connections in one program (with and without threads).terry jones14 Apr