Re: [phplib] HELP: phplib leaving processes in MySQL From: Bob Bowker (bowker <email protected>)
Date: 04/06/01

Steve --

Are you using "mysql_pconnect" ...? If so, change it to "mysql_connect"
and the problem should go away. Unless you're running 100,000 people a
minute through your web site, the downside to pconnects far outweighs the
upside, no matter what database you're using.

Not based on anything concrete, just the solution that worked for me -
immediately and completely. At a California conference 18 months ago,
Monty and Rasmus scratched their heads over this, and ultimately blamed
Apache (!).

Good luck!

Bob.

At 05:29 PM 4/6/01 -0400, Stephen Woodbridge wrote:
>Hi all,
>
>I just noticed that phplib seems to be leaving sleeping processes in
>MySQL. What am I doing wrong or is this a know bug? What is the
>fix/work-a-round?
>
>Any help would be appreaciated.
> -Steve
>
>Here are the details:
>
>Here is a very basic test secript that reproduces the problem:
>
><?php
> php_track_vars;
> page_open(array("sess" => "Example_Session",
> "auth" => "Example_Default_Auth",
> "perm" => "Example_Perm"));
>
> print "<html>\nHello\n</html>\n";
>
> page_close();
>
>?>
>
>I am using the following:
>
>phplib RELEASE 7.2b
>PHP Version 3.0.15
>System: Linux porky.devel.redhat.com 2.2.5-22smp #1 SMP Wed Jun 2
>09:11:51 EDT 1999 i686
>Allow persistent links: Yes
>Persistent links: 1/Unlimited
>Total links: 2/Unlimited
>Client API version: 3.22.32
>pache Version: Apache/1.3.12
>Apache Release: 10312100
>Apache API Version: 19990320
>Loaded modules: mod_php3, mod_perl, mod_setenvif, mod_so,
> mod_usertrack, mod_headers, mod_expires,
>mod_proxy,
> mod_digest, mod_auth_db, mod_auth_anon,
>mod_auth, mod_access,
> mod_rewrite, mod_alias, mod_userdir,
>mod_actions, mod_imap,
> mod_asis, mod_cgi, mod_dir, mod_autoindex,
>mod_include,
> mod_info, mod_status, mod_negotiation,
>mod_mime,
> mod_log_referer, mod_log_agent, mod_log_config,
>mod_env,
> mod_vhost_alias, http_core
>Apache/1.3.12 (Unix) (Red Hat/Linux) PHP/3.0.15 mod_perl/1.21
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: phplib-unsubscribe <email protected>
>For additional commands, e-mail: phplib-help <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>