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 say something about
reusing
open
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
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
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