RE: Reusing connections.

2006-03-11 Thread fbsd_user
day, March 10, 2006 2:24 PM To: [EMAIL PROTECTED] Cc: Mysql Subject: Re: Reusing connections. "fbsd_user" <[EMAIL PROTECTED]> wrote on 03/10/2006 02:18:49 PM: > In my reading of mysql tutorials I see many examples of mysql access > with out first doing a connect. Comments sa

Re: Reusing connections.

2006-03-10 Thread Kishore Jalleda
once a client connects to the server, mysql opens a (TCP/IP or Socket) connection for the client, but after it has serviced the client , mysql still keeps the connection open (thread is in sleep state) for some time depending on the variable "wait_timeout" value anticipating more requests from the

Re: Reusing connections.

2006-03-10 Thread SGreen
"fbsd_user" <[EMAIL PROTECTED]> wrote on 03/10/2006 02:18:49 PM: > In my reading of mysql tutorials I see many examples of mysql access > with out first doing a connect. Comments say something about reusing > open connections for faster processing and less resources usage > overhead. What are they

Reusing connections.

2006-03-10 Thread fbsd_user
In my reading of mysql tutorials I see many examples of mysql access with out first doing a connect. Comments say something about reusing open connections for faster processing and less resources usage overhead. What are they talking about & what code do I need to make this happen? -- MySQL Gene