to the
database exit after the current request. Newly spawned children seem to
connect okay.
- Perrin
into shared memory? If so, how?
DBI-install_driver()
See http://perl.apache.org/guide/performance.html#Initializing_DBI_pm for more.
- Perrin
variable name = one variable. If
you need two, they need to have different package names or different variable
names. The file name is irrelevant.
- Perrin
and detailed help.
- Perrin
for this in Apache::PerlRun.
- Perrin
migration script or not upgrade
Apache::Session.
- Perrin
connection will go to
mod_perl.
- Perrin
it) or you can replace one or
the other with a new compile.
- Perrin
Is this the correct list for help with Apache::Session::MySQL?
This is a good list for it if you are using mod_perl. If you're using
CGI, try one of the CGI resources instead, or stick with perlmonks.org. I
just replied to your post there a few minutes ago.
- Perrin
increase. Depending on
what you're doing, it can make a really huge difference in performance.
I do recommend that you fix your current Apache::Session problem first,
before thinking about converting to mod_perl.
- Perrin
.
- Perrin
Christopher Hicks wrote:
I've used the lines below and the various other provided incantations for
using Apache::SSI or Apache::SSIChain.
PerlModule Apache::SSIChain
PerlModule Apache::Filter
PerlModule Apache::SSI
PerlModule Apache::OutputChain
Alias /ssiperl/ /www/perl/ssibin
gh "Time"s under the "sleep" stat when I
do a 'processlist' in mysql. Please advise.
-- Viren
If ANYTHING is different in your connect string, Apache::DBI will keep a
separate connection open. You probably have slight variations in your
connect strings.
- Perrin
anything
over Stage 1.
I think Oracle 8 is doing some magic by parsing your SQL and matching it
up to previous statements, whether you use bind variables or not. It may
matter more on other databases.
- Perrin
, but for me the overhead of the method call seemed to erase any
savings from not stat-ing files, etc.
- Perrin
that you could also use BerkeleyDB
(interface to version 2 3 of Berkeley DB library), which manages its
own locks at a page level using shared memory. I haven't used this
under load, so I can't vouch for it yet, but it looks like a great
solution for sites that run on one machine.
- Perrin
.
- Perrin
than the fastest servlet runner
(http://www.caucho.com/) with the fastest JVM (IBM 1.1.8 final
release). If you're on Solaris, all bets are off. I suspect you should
be able to clobber JServ in the performance department on any platform
though.
- Perrin
undef a sub reference,
does the memory really get released and reused?
- Perrin
? For parsing the output
of actual apache modules like PHP, I have no idea, but PHP does have a
CGI mode.
- Perrin
Perrin Harkins wrote:
Greg Stark wrote:
For example, it makes it very hard to mix any kind of long running query with
OLTP transactions against the same data, since rollback data accumulates very
quickly. I would give some appendage for a while to tell Oracle to just use
the most recent
RTFM. perldoc Apache::DBI.
- Perrin
benchmark is kind of misleading. You test performance with
everything on one machine and then you test it with things split between
two machines. To be fair, both tests should use both machines.
- Perrin
you never have to touch the underlying Perl code. See above.
This is different from XMLC, which requires the program using it to
specify which node to replace the contents of. I think your approach is
better.
- Perrin
be more work done there.
Ideally, I would get rid of every page except the one which lists the
tests grouped by OS/machine. Then I would put a big statement at the
top saying that comparisons across different people's tests are
meaningless.
- Perrin
there is secondary confirmation ?
Your call. Again, to my mind each person's contribution can only be viewed
in its own private context, so one is no more skewed than any other.
- Perrin
On Sun, 30 Jan 2000, Perrin Harkins wrote:
I can understand that; I just don't want mod_perl users to get a
reputation
as the Mindcraft of web application benchmarks.
I'm not sure I see how that can happen when we quite clearly state that
php4 is faster than mod_perl.
Only one person
Hi,
A week or two ago, in the squid performance thread, I mentioned that I was
looking for ways to eliminate squid from our production servers. I noted
that we are using squid to save an expensive trip to the database to
retrieve mostly static files. At that time I said that I planned to
and the
NetApp. Otherwise, things that use file mod times (like Registry) will
have strange behavior.
- Perrin
.) is
effective, and the XML configuration is a joy to deal with compared to
Apache's httpd.conf.
So, it's nice, but not as fast as mod_perl on Linux. If anyone wants to
try this on another OS, I can supply a tar of the files we used for
testing.
- Perrin
java - .class, etc.) is
effective, and the XML configuration is a joy to deal with compared to
Apache's httpd.conf.
So, it's nice, but not as fast as mod_perl on Linux. If anyone wants to
try this on another OS, I can supply a tar of the files we used for
testing.
- Perrin
sub, like accidental closures.
- Perrin
et and as a JSP page and found no difference in
performance.
- Perrin
On Tue, 8 Feb 2000, Scott Chapman wrote:
What magazines are good on Perl?
At least two of the members on this list write for Web Techniques (Lincoln
and Randal). And of course The Perl Journal is good.
- Perrin
, you have to run make install manually or
force the install through cpan which I have NO IDEA how to do).
From the CPAN shell:
force install Apache::SSI
All the Ken Williams modules have this problem in their test scripts. Any
chance you could fix that Ken?
- Perrin
I came up with some reasons after all. So go ahead and use it if
you see a fit. Just don't believe anything that a person with a product
to sell tells you about XML. Or anything else. But that's a different
story.
- Perrin
it.
How about this: for Apache::AuthCookie I've been writing a system that will ask
the user at "perl Makefile.PL" time for the path to an httpd. The default is
$ENV{APACHE} or '/usr/lib/httpd/httpd'.
Will that work?
That would be great.
- Perrin
and maintain the HTML
templates, they may find it easier than XSLT. Of course, it's a Perl-only
solution.
- Perrin
anymore.
They prefer BLOB for this and are phasing out Long. Maybe they broke Long
in the 8i release for certain situations.
BLOB works fine from DBD::Oracle, so give it a try. You may need to set
the type on the bind parameter to ORA_BLOB. perldoc DBD::Oracle for the
scoop.
- Perrin
On Wed, 29 Mar 2000, Jerome MOUREAUX wrote:
Alias /indicators2/perl "/disc1/sherpa_a/indicators2/perl"
[...]
PerlSetEnv ORACLE_HOME /disc1/sherpa/oracle
Do you really have a /disc1/sherpa directory and a /disc1/sherpa_a
directory?
- Perrin
for this other user.
- Perrin
t Registry.
As for making changes without restarting, I always restart my production
servers when I change code, in order to maximize shared memory, but I can
do this because I have a cluster of servers. I could see this being a
problem if I only had one machine.
- Perrin
l your own.
Maybe you could make a subclass of Apache::Request that adds somemethods
for this.
If there are any tutorials out there, I'd love some links.
It really isn't difficult enough to merit a tutorial, in my opinion. It's
just ordinary perl module stuff.
- Perrin
, etc)?
You probably want to set up one for each Apache::Registry script you have
right now, unless you don't like the way they're structured and want to
re-work it.
- Perrin
at /home/... line ...
You should only be getting that error if there is more data on that
statement handle that you haven't read. You can take care of that by
calling $sth-finish, or by reading the rest of the data.
- Perrin
ie is sent accepted.
Does your Set-Cookie header include a path setting? Some browsers require
that.
- Perrin
Jim Winstead wrote:
An important point is that although "Host:" wasn't required until
HTTP/1.1, all of the common browsers have sent it with 1.0 requests
for some time.
Yes, but I've had problems with corporate proxy servers that don't send
it.
- Perrin
never
does...
You could try using a PerlCleanupHandler to kill any open locks.
$r-register_cleanup( \clear_locks );
- Perrin
'$location'here/a.");
return OK;
Jim
You could also put the cookie info in the URL you redirect to (as a
query string), and make your handler look for it there if the cookie is
missing.
- Perrin
-server approach for mod_perl, and
if that doesn't work for you look at FastCGI, and if that doesn't work for
you join the effort to get mod_perl working on Apache 2.0 with a
multi-threaded model. Or just skip the preliminaries and go straight for
the hack value...
- Perrin
of lexical variables to work.
Are you saying that destroying the variables and actually reclaiming the
memory are separate, and only the first is happening?
- Perrin
behavior would be significant. This shouldn't
be a problem if you simply avoid using closures in a recursive
algorithm. In your example, I believe only the value of $i will be
saved each time, since $funnierstuff will go out of scope at the end of
the block and get garbage collected.
- Perrin
d) and (curiously)
the detail of the syntax error does now at least appear in error.log!
CGI::Carp can't catch compile errors.
- Perrin
routine
where it checks to see if it's in an eval, but that's pretty lame and
makes CGI::Carp incompatible with use of eval blocks. I don't use
Apache::Registry or CGI::Carp, so I'm not very motivated to find a better
fix. You could contact the author.
- Perrin
attempting to reconnect. The
code author decided not to perform a disconnect() because they knew the
connection was already timed out.
Those are both good guesses. I'd say the latter as well. One of your
db handles probably failed to ping and got removed. I wouldn't worry
about it.
- Perrin
ost people don't have to wait as long
for a response? The sequential model is great if you're the next in line,
but terrible if there are 50 big requests in front of you and yours is
very small. Parallelism evens things out.
- Perrin
On Wed, 26 Apr 2000, Leslie Mikesell wrote:
According to Perrin Harkins:
On Tue, 25 Apr 2000 [EMAIL PROTECTED] wrote:
With mod_proxy you really only need a few mod_perl processes because
no longer is the mod_perl ("heavy") apache process i/o bound. It's
now CPU bound.
assReverse
(http://www.apache.org/docs/mod/mod_proxy.html#proxypassreverse) when you
start using a proxy server in this way.
- Perrin
methods are changed or added. How does this affect memory? Does
each one get a full copy of the module in memory, and then it is changed?
Again, there is only one copy of the code, but any variables are separate.
- Perrin
er
support) that usually send people to NAT-based approaches for high-traffic
commercial sites.
- Perrin
suggestions from this section of the guide. You may find the section in
the camel book on optimizing for size useful as well.
- Perrin
ort
symbols if necessary), you could at least put the do statement inside a
BEGIN block so that it will only happen once per script. You still waste
memory by loading the same library multiple times, but you do get the
performance benefits.
- Perrin
Autarch wrote:
On Mon, 8 May 2000, Perrin Harkins wrote:
Some apps that use Apache::Session, like Embperl and Mason, have chosen
to rely on cookies. They implement the cookie part themselves.
Apache::Session has nothing to do with cookies.
I don't know about Embperl but Mason
mechanism in your 1.5 release. I've found the automatic
locking it does to be very efficient. For single machine setups I suspect
it will outperform the other options.
- Perrin
On Tue, 9 May 2000, Wim Kerkhoff wrote:
On 09-May-2000 Perrin Harkins wrote:
On Mon, 8 May 2000, Wim Kerkhoff wrote:
On a fresh restart of apache, my processes are about 20 ~ 25 MB each,
which is about normal for mod_perl (as far as I know). However,
within a few hours (with little use
traffic to need a cluster of machines also care
about sessions surviving individual machine problems.
- Perrin
;, but put it in
BEGIN block so it doesn't run on every request.
- Perrin
static
page traffic than you can afford the bandwidth for anyway.
- Perrin
, if you're using CPAN to install (which I assume you
are, because this wouldn't be a problem for you otherwise) you can just do
a "force install".
- Perrin
the path I give to the Makefile.PL override this one?
By the way, this one does let me skip the test if I want to. Maybe it was
Filter's test that didn't have an opt-out.
- Perrin
your autocommit settings.
- Perrin
://www.best.com/~pjl/software/swish/ (no, it's not the same
one apache.org is using).
I've also had great success with htdig. Maybe I'll try spidering the
guide with and see how it does.
- Perrin
. These are not multi-threaded processes.
- Perrin
on CPAN if your data is appropriate for this. And you could try switching
between perl's malloc and your system's malloc, though this requires you
to build a new version of perl.
- Perrin
g ...) -
hence another potential source of failure.
You have to do a write-through cache, i.e. you must write to the database
as well as the cache, but you only have to READ the database if you don't
find the session in the cache. If you have a fair amount of read-only use
of the session this can be a big win.
- Perrin
to the database when the
object is destroyed. Make sure it is really going out of scope.
- Perrin
up
in the process list. Is there something I'm missing?
Are you pulling in the DBI and DBD modules in your startup.pl? Is there
any message in the error_log? Apache::DBI is not at all like DBD::mysql,
so it sounds like you may have a problem totally unrelated to DBI.
- Perrin
this.
- Perrin
page. New child processes spawned by Apache don't
have any trouble connecting.
This is with Oracle 8 on Linux.
- Perrin
must use them in? Apache::DBI installed without a
hitch, are there other pitfalls of which I should be aware?
Yes, the Apache::DBI docs explain that you must load it before any other
DBI-related modules.
- Perrin
t any rate, "do" is nearly always a bad thing and the
business about being parsed twice only applies to Apache's config file
and Perl sections in it, not to your modules.
- Perrin
Marc Lehmann wrote:
While I understand how my problem happens, it just caught me again
(letting me deb
disposal...
- Perrin
variables being created.
Anyway, I was just trying to help you solve your problem. There's no need
to get defensive.
- Perrin
or Yams instead.
- Perrin
On 25 May 2000, Randal L. Schwartz wrote:
I got no "no warnings". this is still 5.5.3 :)
There's always the time-honored
{
local $^W;
}
- Perrin
ot; by
Steve McConnell is good.
- Perrin
finsih) this
handler will take care of it.
Maybe this should be folded into Apache::DBI, like the automatic rollback?
- Perrin
could use on their own systems to do comparisons.
- Perrin
BLOBs breaking synonyms is a bug either.
- Perrin
indicate that.
- Perrin
class? You can
easily make classes to hold data using Class::Struct or
Class::MethodMaker.
Is it just that you want a safer way to do introspection than looking at
the data structure the class is made from? Maybe you want the
Class::Fields module from CPAN.
- Perrin
y::Module::foo\n";
Honestly though, your example makes it look like you'd be better off with
dbm files and Tie::MLDBM or something.
- Perrin
I have to keep it
simple for them. If I used a binary file format I'd have to make them
learn the tools for changing it.
Depending on how much of this data you have and how timely it has to be,
you could make a cron that crawls the text files every 5 minutes or so
and build a dbm with their data in it.
- Perrin
your modules.
- Perrin
in the SQL. You'd still want to run
a cron to actually delete the old session data.
- Perrin
it altogether.
If you don't use these your code should work just fine, lexicals,
accessors, and all.
- Perrin
ey're just trying to make money from you. Use a database.
- Perrin
On Sat, 3 Jun 2000, Stas Bekman wrote:
* install_driver (2):
DBI-install_driver("mysql");
I've never seen that before, and it isn't in the DBI perldoc. Is it safer
than "use DBD::mysql;"?
- Perrin
On Sat, 3 Jun 2000, Stas Bekman wrote:
correction for the 3rd version (had the wrong startup), but it's almost
the same.
Version Size SharedDiff Test type
1 3469312 2609152 860160
object
methods. Whether that slowness will be noticeable next to the slowness of
accessing a database is questionable. There were a few benchmarks posted
to this list that you could dig out of the archive.
- Perrin
wallclock secs (10.72 usr + 0.03 sys = 10.75 CPU)
Never mind the performance, that multi_print and list_print are just
U-G-L-Y! Here doc rules. Great for SQL too.
- Perrin
1 - 100 of 1298 matches
Mail list logo
