What I've found out...
> 1) debug in single server mode - I'm sure you realize that Apache::DBI
> creates one connection per httpd child, not just one connection that is
> shared by all httpd processes.
Sorry,At first I really think that all Apache child will share one Mysql
connection :-) Though Not now,but what a nice feature to add later?just
create the mysql connection when apache startup then pass the dbh also as a
GLOBAL var to apache child to share with.Not hard to add I think?
> I doubt that IE and Netscape are treating your DBI connection
differently...
True,IE and Netscape treat it totally different. When exam this with
mysqladmin processlist(I exam the Sleep time parameter list in the
output),I've found out that,all script invoke in same IE window will share
the first mysql connection it used,say,if first time you execute the script
use mysql connection with id 100,the 2nd and 3rd... execute will still use
this connection except you wait a long time beyond the KeepAliveTimeout in
httpd.conf (is it?)and the apache child died.
But Netscape is totally different.It seems that Netscape will randomly pick
up a existed mysql connection to use,well,should be a random apache child
will serve netscape's request.Why?
> do some more research and let me know what you find...
>
I do find those stuff.hmmmm...what do you think?
> --Geoff
>
______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com?sr=mc.mk.mcm.tag001
