Re: Opening multiple MySQL connections in one program (with and without threads).

[Aldrian Gintingsuka]

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: [phone] ext. 1414 -- Fax: [phone]
Email: aldrian@stripped, aldrian@stripped
------------------------------------------------------------------------
Si tu es contre Dieu, tu es contre l'homme (Enigma: Sadeness part I)