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
Hi, From previous message (I don't run linux), I believe that linux ps lists all threads, and mysqld does create a thread for each connection. Regards Quentin -Original Message- From: Bennett Haselton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 22 November 2001 4:15 p.m. To: [EMAIL

RE: does each database connect cause mysqld to fork?

2001-11-21 Thread Bennett Haselton
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() creates a new process, not a new thread.)