Wayne,
WI>It is my understanding that when the app is running
WI>and I look at the status under MySQL, that I should
WI>see only one connection. However, what I see is plenty
WI>of connections, as many as there were before I added
WI>Apache::DBI to the mix.
Apache is a forking server. There are x forked child processes serving
requests, each of which has a full Perl interpreter in it. What you are
seeing is likely one database connection per server child. Use "ps" and
count the number of Apache processes (or check /server-status) and that
number should match the number of MySQL connections.
The difference by using Apache::DBI is that those connections will stick
around, rather than being created/destroyed per HTTP request per child.
The number extant at any given time may be more or less than before, the
important thing is that they are persistent, saving resources on both
sides for connection establishing.
Humbly,
Andrew
----------------------------------------------------------------------
Andrew Ho http://www.tellme.com/ [EMAIL PROTECTED]
Engineer [EMAIL PROTECTED] Voice 650-930-9062
Tellme Networks, Inc. 1-800-555-TELL Fax 650-930-9101
----------------------------------------------------------------------
