too many connections

2007-04-15 Thread Kelvin Wu
have been running mod_perl 2 with apache::dbi for few days, so far so good, normally 20 httpd with 30-40 persistant connections, cpu usage is under 1. but noticed sometimes cpu usage goes up to 30, and there are 80 httpd... can't even log into mysql because 'too many connections', have to restart

Re: Apache::DBI questions

2007-03-29 Thread Kelvin Wu
The Apache::DBI perldoc is too simple to understand its usage, but I would like to thank your guys for your great explaination on my questions... :-) -- Sent from my BlackBerry. Ignore the typos unless they're funny.

Re: Apache2::Request for ActivePerl Win32

2007-03-29 Thread Kelvin Wu
Yes just noticed, thanks for your info. On 3/29/07, Randy Kobes <[EMAIL PROTECTED]> wrote: On Thu, 29 Mar 2007, Issac Goldstand wrote: > Kelvin Wu wrote: >> >> Is there a Apache2::Request module for ActivePerl Win32 (v5.8.8 built >> for MSWin32-x86-m

Apache::DBI questions

2007-03-29 Thread Kelvin Wu
I have CGI script which uses normal DBI mysql calls(DBD, DBI::Mysql), I am tryint to port it to mod_perl2 and Apache::DBI. 1. Do I still need to use 'use Apache::DBI;' in my script (or in startup.pl) if I already set 'PerlModule Apache::DBI' in httpd.conf? 2. Will Apache::DBI work (caches and ma

Re: Apache2::Request for ActivePerl Win32

2007-03-29 Thread Kelvin Wu
I tried URI use URI; use URI::Escape; my $uri = URI->new($r->unparsed_uri()); my %args = $uri->query_form(); $r->print($args{"key"}); it works too. On 3/29/07, Kelvin Wu <[EMAIL PROTECTED]> wrote: Hi list, Is there a Apache2::Request module for ActivePerl Win

Apache2::Request for ActivePerl Win32

2007-03-29 Thread Kelvin Wu
Hi list, Is there a Apache2::Request module for ActivePerl Win32 (v5.8.8 built for MSWin32-x86-multi-thread) and mod_perl 2? I am trying to read parameters from query, the $r->args() call in mod_perl 2 simply returns whole URI rather than key/value hash which mod_perl1 does. After some research,