Re: does each database connect cause mysqld to fork?

2001-11-22 Thread Dan Nelson
In the last episode (Nov 21), Bennett Haselton said: Do you mean processes instead of threads? (ps lists each *process* separately, along with its process ID, but doesn't list separate threads within each process. If mysqld handles each new connection by calling fork(), then I think fork()

Re: does each database connect cause mysqld to fork?

2001-11-22 Thread Paul DuBois
At 7:14 PM -0800 11/21/01, Bennett Haselton wrote: Each time I open a database handle (in perl code), does that cause a new process to run, a new instance of mysqld? And each time I disconnect the database handle ($dbh-disconnect() in perl code), does that cause the number of running

RE: does each database connect cause mysqld to fork?

2001-11-21 Thread Quentin Bennett
PROTECTED] Subject: does each database connect cause mysqld to fork? Each time I open a database handle (in perl code), does that cause a new process to run, a new instance of mysqld? And each time I disconnect the database handle ($dbh-disconnect() in perl code), does that cause the number

RE: does each database connect cause mysqld to fork?

2001-11-21 Thread Bennett Haselton
PROTECTED]] Sent: Thursday, 22 November 2001 4:15 p.m. To: [EMAIL PROTECTED] Subject: does each database connect cause mysqld to fork? Each time I open a database handle (in perl code), does that cause a new process to run, a new instance of mysqld? And each time I disconnect the database handle ($dbh