RE: mod_perl vs. C for high performance Apache modules
I spoke to the technical lead at Yahoo who said mod_perl will not scale as well as c++ when you get to their level of traffic, but for a large ecommerce site mod_perl is fine. I think people just stick to what they started with. We wrote our site racesearch.com using mod_perl and it is super fast. (faster than Amazon.com) -tom -Original Message- From: Jeff Yoak [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 12:12 PM To: [EMAIL PROTECTED] Subject: mod_perl vs. C for high performance Apache modules Hi All, Recently I did a substantial project for a client in using mod_perl. That client is happy with the work, but an investor with their company is very angry because of what a horrible choice mod_perl is for high-load web applications compared with Apache modules and even CGI programs, written in C. If anyone on this list could forward any resources that do comparisons along these lines, or even analysis of mod_perl's handling of high-load web traffic, I would be very grateful. Cheers, Jeff -- Jeff Yoak 626-705-6996
FW: Problem after rebooting apache with Oracle
Does anyone have ideas why we would get this error periodically after our
system has been running for about 20 minutes?
thanks,
-tom
[Wed Jan 10 16:22:45 2001] [error] DBI->connect(RSPD1) failed: ORA-12154:
TNS:could not resolve service name (DBD ERROR: OCIServerAttach) at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI.pm line 411
DBI::connect('DBI', 'dbi:Oracle:RSPD1', 'username', 'password',
'HASH(0x192fb60)') called at /data/www/racesearch/htdocs/CGI/LIB/RSDBI.pm
line 323
RSDBI::connect('RSDBI') called at
/data/www/racesearch/htdocs/CGI/search_modules/SBPN.pm line 72
SBPN::main('SBPN', 'HASH(0x191d284)') called at
/data/www/racesearch/htdocs/CGImp/mhp line 132
Apache::ROOTwww_2eracesearch_2ecom::CGImp::mhp::mode_sbpn('HASH(0x191d284)')
called at /data/www/racesearch/htdocs/CGImp/mhp line 63
Apache::ROOTwww_2eracesearch_2ecom::CGImp::mhp::handler('Apache=SCALAR(0x237
cd74)') called at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Apache/Registry.pm line
143
require 0 called at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Apache/Registry.pm line
143
Apache::Registry::handler('Apache=SCALAR(0x237cd74)') called at
/dev/null line 0
require 0 called at /dev/null line 0
> Everything works fine for about 1/2 an hour and then we start getting the
> message below. We used to get an error that Oracle home was not found, so
we
> hard-coded it in and now we just get the message below.
was the ORACLE_HOME an error or just a warning? if your oratab is
set up properly it shouldn't need ORACLE_HOME once the instance is
found.
> Does anyone have any suggestions? If our code produces an oracle error,
does
> that corrupt the mod_perl process and therefore give any future users who
> connect to that particular process the error below?
>
> perl version 5.6.0
> Oracle 8.1.5
> mod_perl 1.21
> apache 1.3.12
i have a similar setup (5.6.0, 8.1.6, 1.21_1, 1.3.14) w/o any
problems IFF tnslsnr is set up properly and started. otherwise
there is chaos.
connecting via:
my @dbinfo =
qw(
dbi:Oracle:host=somehost;sid=foo
username
password
);
my $dbh = DBI->connect( @dbinfo ) or croak "Roadkill: $!";
the ORA-12154 gives me a freudian feeling that your tnslsnr is
not set up properly.
quick check:
. oraenv
lsnrctl;
> stop
> start
should tell you about stopping and starting properly. if it doesn't
then fix this before worrying about DBD::Oracle (or dump oracle for
a database that isn't living hell to set up).
note: i've just had to go through this in order to set up a demo
for one of our clients. i can haul my system in on monday and
we can go over the setup steps if anyone else is interested in this.
--
Steven Lembark 2930 W. Palmer St.
Chicago, IL 60647
[EMAIL PROTECTED] 800-762-1582
Problem after rebooting apache with Oracle
Everything works fine for about 1/2 an hour and then we start getting the
message below. We used to get an error that Oracle home was not found, so we
hard-coded it in and now we just get the message below.
Does anyone have any suggestions? If our code produces an oracle error, does
that corrupt the mod_perl process and therefore give any future users who
connect to that particular process the error below?
perl version 5.6.0
Oracle 8.1.5
mod_perl 1.21
apache 1.3.12
[Sat Dec 23 09:55:08 2000] [error] DBI->connect(RSPD1) failed: ORA-12154:
TNS:could not resolve service name (DBD ERROR: OCIServerAttach) at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI.pm line 411
DBI::connect('DBI', 'dbi:Oracle:RSPD1', 'username', 'password',
'HASH(0x192a9b4)') called at /data/www/racesearch/htdocs/CGI/LIB/RSDBI.pm
line 323
RSDBI::connect('RSDBI') called at
/data/www/racesearch/htdocs/CGI/search_modules/SBPN.pm line 72
SBPN::main('SBPN', 'HASH(0x2574a84)') called at
/data/www/racesearch/htdocs/CGImp/mhp line 132
Apache::ROOTwww_2eracesearch_2ecom::CGImp::mhp::mode_sbpn('HASH(0x2574a84)')
called at /data/www/racesearch/htdocs/CGImp/mhp line 61
Apache::ROOTwww_2eracesearch_2ecom::CGImp::mhp::handler('Apache=SCALAR(0x24a
04f8)') called at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Apache/Registry.pm line
143
require 0 called at
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Apache/Registry.pm line
143
Apache::Registry::handler('Apache=SCALAR(0x24a04f8)') called at
/dev/null line 0
require 0 called at /dev/null line 0
