[mp2] make test failures on OS X

2005-01-17 Thread Abe Timmerman
[Long report!] -8<-- Start Bug Report 8<-- 1. Problem Description: This is OS X (10.3) with their standard perl, CompleteApache2 and mod_perl-2-RC3 Running make test shows some failures: Failed Test Stat Wstat Total Fail Failed Lis

[mp1] Problem with loading Time::Piece at startup

2005-01-17 Thread Ian McDonald-ONLINE
Hi, I have a problem using Time::Piece with mod_perl. If Time::Piece is loaded on startup, either by startup.pl, in PerlModule, or by being used in another module. It appears in %INC. In a cgi-perl script running under Apache::Registry: 'use Time::Piece' does not cause the file to be re-read. %T

Re: [mp2] PerlPostConfigRequire requires absolute path?

2005-01-17 Thread Patrick LeBoutillier
> It's a fairly new feature. If you find the documentation lacking, please > do submit a documentation > patch ;-) (Or did you have a specific question about > PerlPostConfigRequire ?) What I meant was that I didn't find anything indicating that it should behave differently than, say, PerlRequire.

mp2 + worker mpm + threads + threads::shared + PerlChildInitHandler

2005-01-17 Thread Richard F. Rebel
Hello, I have a high volume application that basically needs to keep track of a couple counters for the number of times certain requests were made and update a MySQL db. Unfortunately, it's high volume enough that it's no longer possible to keep these counters in the databases updated in real ti

Re: CGI::Session or CGI::Application

2005-01-17 Thread Perrin Harkins
On Sat, 2005-01-15 at 21:57 -0500, Todd Finney wrote: > Have you checked ::MySQL against Apache::Session::DB_File? My experience > is a couple of years out of date on this, but I switched away from using > ::MySQL for sessions because it was such a pig. MySQL will be a lot faster than the tied

Re: mp2 + worker mpm + threads + threads::shared + PerlChildInitHandler

2005-01-17 Thread Perrin Harkins
On Mon, 2005-01-17 at 11:25 -0500, Richard F. Rebel wrote: > Unfortunately, it's high volume enough that it's no longer possible to > keep these counters in the databases updated in real time. (updates are > to the order of 1000's per second). I would just use BerkeleyDB for this, which can easil

Re: [mp1] Problem with loading Time::Piece at startup

2005-01-17 Thread Perrin Harkins
On Mon, 2005-01-17 at 11:52 +, Ian McDonald-ONLINE wrote: > The use of any Time::Piece function or method falls back to AutoLoader, > which tries to load the .al file. > The interpreter cannot find the .al file, and issues a fatal > error. This probably means you have a permissions problem on

Re: [BENCHMARK] Server Resources

2005-01-17 Thread Perrin Harkins
On Sat, 2005-01-15 at 18:31 -0700, [EMAIL PROTECTED] wrote: > Would you recommend squid or mod_proxy? I would recommend mod_proxy because you already know how to run apache, and it can run useful things like mod_rewrite, mod_ssl, mod_auth_tkt, etc. I benchmarked them a VERY long time ago and foun

RE: [mp1] Problem with loading Time::Piece at startup

2005-01-17 Thread Ian McDonald-ONLINE
Thanks for answering, Perrin. To be clear, I am not splitting the modules. My intention is to pre-load all of them; the module has not been split into *.al files, and when I trussed the Apache process, the startup.pl script was reading Time/Piece.pm (which has all the functions in it). It cannot

Re: mp2 + worker mpm + threads + threads::shared + PerlChildInitHandler

2005-01-17 Thread Richard F. Rebel
Another good idea... :) But I am transfixed by this problem... I can't seem to get each forked apache server to have both a shared global hash between all cloned interpreters, *and* one thread in each process that runs in the background doing housekeeping. I can think of numerous things that th

Re: CGI::Session or CGI::Application

2005-01-17 Thread William McKee
On Sat, Jan 15, 2005 at 08:15:31AM -0500, Michael Peters wrote: > CGI::Session does not appear to be well maintained. It's very popular > and I know many people who have tried to send in patches and fixes but > the author has been unresponsive. Which is really ashame since it's listed in the P

Re: CGI::Session or CGI::Application

2005-01-17 Thread Perrin Harkins
On Mon, 2005-01-17 at 14:45 -0500, William McKee wrote: > On Sat, Jan 15, 2005 at 08:15:31AM -0500, Michael Peters wrote: > > CGI::Session does not appear to be well maintained. It's very popular > > and I know many people who have tried to send in patches and fixes but > > the author has been

RE: [mp1] Problem with loading Time::Piece at startup

2005-01-17 Thread Perrin Harkins
On Mon, 2005-01-17 at 19:12 +, Ian McDonald-ONLINE wrote: > To be clear, I am not splitting the modules. My intention is to pre-load > all of them; the module has not been split into *.al files, and when I > trussed the Apache process, the startup.pl script was reading > Time/Piece.pm (which ha

RE: [mp1] Problem with loading Time::Piece at startup

2005-01-17 Thread Ian McDonald-ONLINE
> -Original Message- > From: Perrin Harkins [mailto:[EMAIL PROTECTED] > Sent: 17 January 2005 20:31 > To: Ian McDonald-ONLINE > Cc: modperl@perl.apache.org > Subject: RE: [mp1] Problem with loading Time::Piece at startup > > > What happens if you remove the () after "use Time::Piece" i

Re: [BENCHMARK] Server Resources

2005-01-17 Thread Perrin Harkins
On Fri, 2005-01-14 at 13:08 -0800, Skylos wrote: > My first suggestion based on a migration the company I work for did > not too long ago would be to use apache2 in thread mode. There was a > staggering drop in system memory resources consumed when we made the > shift - from most of a gigabyte to

Re: CGI::Session or CGI::Application

2005-01-17 Thread William McKee
Hi Perrin, Thanks for the feedback. I've been meaning to find a better alternative. I think many programmers writing standard cgi scripts are scared off from using the Apache::Session modules because of the chosen namespace, although I understand that it's possible to use them outside of Apache. M

RE: [mp1] Problem with loading Time::Piece at startup

2005-01-17 Thread Perrin Harkins
On Mon, 2005-01-17 at 20:39 +, Ian McDonald-ONLINE wrote: > > What happens if you remove the () after "use Time::Piece" in > > your script? > > It crashes with the same "can't locate" error on "use Time::Piece", > instead of on "Time::Piece->import". I separated them out to clarify > when a

Re: [SOLVED] mp2 + worker mpm + threads + threads::shared + PerlChildInitHandler

2005-01-17 Thread Richard F. Rebel
Hi, Well, the problem was my fault. :/ I had a bug in a generic base class I use that makes it easier to build classes that work both inside and outside mod_perl. For those of you who are interested, this solutions works well. By using PerlChildInit handler to create a thread to maintain a sh

Re: [mp1] Problem with loading Time::Piece at startup

2005-01-17 Thread Adam Kennedy
hmmm... prefork.pm was created for this sort of problem, when some form of run-time loader is being silly, and everything should really just be loaded in at compile-time. I wonder if it's time to investigating adding autoloader support to prefork.pm some how. For anyone else that has issues at

DBI memory usage

2005-01-17 Thread Chris Ochs
Is there a way to do large queries that return lots of data without having my apache process grow by the equivalent size in ram of the data returned? The only thing I can think of is to run a separate script outside of mod perl for queries like this. Chris

Re: DBI memory usage

2005-01-17 Thread Perrin Harkins
Chris Ochs wrote: Is there a way to do large queries that return lots of data without having my apache process grow by the equivalent size in ram of the data returned? Yes. Many databases support sending the results a few rows at a time instead of all at once. For specific advice on this, you mi

Re: DBI memory usage

2005-01-17 Thread Perrin Harkins
Perrin Harkins wrote: Chris Ochs wrote: Is there a way to do large queries that return lots of data without having my apache process grow by the equivalent size in ram of the data returned? Yes. Many databases support sending the results a few rows at a time instead of all at once. For specific

Re: DBI memory usage

2005-01-17 Thread Chris Ochs
> > Yes. Many databases support sending the results a few rows at a time > > instead of all at once. For specific advice on this, you might check > > your DBD documentation or ask on the dbi-users list. You can also have > > your program schedule the current apache process to exit after finishin

Re: DBI memory usage

2005-01-17 Thread Steven Lembark
Is there a way to do large queries that return lots of data without having my apache process grow by the equivalent size in ram of the data returned? Yes. Many databases support sending the results a few rows at a time instead of all at once. For specific advice on this, you might check your DBD

Re: DBI memory usage

2005-01-17 Thread Chris Ochs
> > Also ask yourself if you really need all of the data at > once. You may be able to filter it down in the query or > build some incremental data structures using row-by-row > iteration instead of fetchall_arrayref. Ya I do, it's basically a customer list export from the database that I write o

Re: CGI::Session or CGI::Application

2005-01-17 Thread Octavian Rasnita
And I have seen that CGI::Session is not very fast, even when there are only a few sessions in a MySQL table, but... are there any other libraries that can do it better? I have seen that CGI::session is made in such a way that anyone can write a driver for another databases or ways of storing data