;
> >> Thanks Ed. I'll add it and see if it helps. My load testing phase is
> >> already completed, but I may get a chance to retest next year.
> >>
> >> On Thu, Oct 10, 2024 at 6:32AM Edward J. Sabol
> >> wrote:
> >>
> >>> On
ce to retest next year.
>>
>> On Thu, Oct 10, 2024 at 6:32 AM Edward J. Sabol
>> wrote:
>>
>>> On Oct 7, 2024, at 5:55 PM, Tim Lank wrote:
>>>
>>> I have the following in my startup.pl:
>>>
>>> use CGI qw(:all);
>>> us
CGI qw(:all);
>> use CGI::Carp 'fatalsToBrowser', 'carpout';
>> use List::Util 'shuffle';
>> CGI->compile(':all');
>> Apache::DBI->connect_on_init
>>
>> ("DBI:mysql:holidayshop",
>>
>>
>
> use CGI qw(:all);
> use CGI::Carp 'fatalsToBrowser', 'carpout';
> use List::Util 'shuffle';
> CGI->compile(':all');
> Apache::DBI->connect_on_init
>
> ("DBI:mysql:holidayshop",
>
>
> I don't know
On Oct 7, 2024, at 5:55 PM, Tim Lank wrote:I have the following in my startup.pl:use CGI qw(:all);use CGI::Carp 'fatalsToBrowser', 'carpout';use List::Util 'shuffle';CGI->compile(':all');Apache::DBI->connect_on_init ("DBI:mysql:holidayshop&qu
look at the code and make educated guesses.
>>
>> Adam
>>
>> On Oct 7, 2024, at 5:56 PM, Tim Lank wrote:
>>
>>
>>
>> You don't often get email from timl...@timlank.com. Learn why this is
>> important <https://aka.ms/LearnAboutSenderIdent
n why this is
> important <https://aka.ms/LearnAboutSenderIdentification>
>
> Apache::DBI experts:
>
> I have the following in my startup.pl:
>
> use CGI qw(:all);
> use CGI::Carp 'fatalsToBrowser', 'carpout';
> use List::Util 'shuffle';
> CGI->c
, at 5:56 PM, Tim Lank wrote:
You don't often get email from timl...@timlank.com. Learn why this is
important<https://aka.ms/LearnAboutSenderIdentification>
Apache::DBI experts:
I have the following in my startup.pl<http://startup.pl>:
use CGI qw(:all);
use CGI::Carp 'fata
-not-loaded
>
> On Mon, Oct 7, 2024, 4:56 PM Tim Lank wrote:
>
>> Apache::DBI experts:
>>
>> I have the following in my startup.pl:
>>
>> use CGI qw(:all);
>> use CGI::Carp 'fatalsToBrowser', 'carpout';
>> use List::Util &#x
Maybe this helps ?
https://php.watch/articles/fix-php-mysql-84-mysql_native_password-not-loaded
On Mon, Oct 7, 2024, 4:56 PM Tim Lank wrote:
> Apache::DBI experts:
>
> I have the following in my startup.pl:
>
> use CGI qw(:all);
> use CGI::Carp 'fatalsToBrowser',
Apache::DBI experts:
I have the following in my startup.pl:
use CGI qw(:all);
use CGI::Carp 'fatalsToBrowser', 'carpout';
use List::Util 'shuffle';
CGI->compile(':all');
Apache::DBI->connect_on_init
("DBI:mysql:holidayshop",
"d
36 PM, Perrin Harkins wrote:
> Apache::DBI overrides DBI's connect() method so that you're using
> persistent connections when you use DBI directly. It may be that your
> performance improvement came from better management of Pg resources
> with PgBouncer than from reducing conn
Apache::DBI overrides DBI's connect() method so that you're using
persistent connections when you use DBI directly. It may be that your
performance improvement came from better management of Pg resources
with PgBouncer than from reducing connection overhead. You could test
it be remov
use Apache::DBI (); appears in our startup.pl but the application code uses
DBI directly.
On Tue, Apr 22, 2014 at 12:30 PM, Perrin Harkins wrote:
> Thanks John. Were you using Apache::DBI before PgBouncer?
> Apache::DBI would also eliminate the overhead of establishing new
> co
Thanks John. Were you using Apache::DBI before PgBouncer?
Apache::DBI would also eliminate the overhead of establishing new
connections.
- Perrin
On Tue, Apr 22, 2014 at 12:23 PM, John Dunlap wrote:
> I can speak to your final point. I recently deployed PGBouncer into our
> prod
2014 at 12:18 PM, Perrin Harkins wrote:
> Interesting. Why did you have to install PgBouncer? Can't Postgres
> handle remote connections from your web server?
>
> I don't use Postgres, but reading the description of PgBouncer I can
> see some things you'd want
Interesting. Why did you have to install PgBouncer? Can't Postgres
handle remote connections from your web server?
I don't use Postgres, but reading the description of PgBouncer I can
see some things you'd want to consider.
First, Apache::DBI prevents you from making persist
Apache::DBI caches database connection per process so you avoid the cost of
creating a connection on each requests.
Pgbouncer pools database connections so that you don't tie up one
postmaster process per httpd process.
If you only have one webserver you may not have a real need for pgbo
I'd be interested in hearing about this too.
On Tue, Apr 22, 2014 at 10:02 AM, jbiskofski wrote:
> I just want to confirm something with all you smart folks.
>
> I recently separated my web servers from my database servers, before I was
> using Apache::DBI to maintain persi
I just want to confirm something with all you smart folks.
I recently separated my web servers from my database servers, before I was
using Apache::DBI to maintain persistent connections between Apache and
Postgres. With this new setup I had to install PgBouncer. Can I now safely
remove Apache
Hi Perrin,
Thanks very much for below information. This is helpful. My conclusion is that
there is no problem in Apache::DBI. It is the application code that doesn't
handle db connection correctly.
- xinhuan
From: Perrin Harkins mailto:phark...@gmail.com>>
Date: Monday, November 11
On Fri, Nov 8, 2013 at 2:58 PM, Xinhuan Zheng wrote:
> The query is from the application code not the 'select 1' test query.
>
OK, then it seems like Apache::DBI may not have a problem.
> While most of time I saw Apache::DBI->connect is called but sometime from
> a p
Hi Perrin,
The query is from the application code not the 'select 1' test query.
While most of time I saw Apache::DBI->connect is called but sometime from a
process, it will print out it finds a cached connection and ping is ok but
sometimes from the same process it didn&#x
On Thu, Nov 7, 2013 at 11:06 PM, Xinhuan Zheng wrote:
> As I turned on more debugging, when the problem occurs, the Apache cached
> connection reference is different than the database handle reference the
> query is using.
Which query are you talking about? The ping in Apache:
sometimes the
query would fail. We use Apache::DBI and DBI and use Apache::DBI is before DBI.
We actually call DBI->connect_cached and based on DBI document, I guess this
would be handled by Apache::DBI connect. However, I guess we also defined a
base class that can store a database handle. There
})) {
>
> What's the difference between the two? Why the code in favor of "or"
> instead of "and"?
>
> - xinhuan
>
> From: Perrin Harkins
> Date: Thursday, November 7, 2013 3:05 PM
>
> To: Xinhuan Zheng
> Cc: Adam Prime , "modperl@
m.pr...@utoronto.ca>>,
"modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI connect
Sorry, I can't determine the problem from your log. You'll need to either run
it in the debugger or add some debuggi
ping fails, because it
doesn't say "new connect..." after that. I also wonder where that
disconnect() call is coming from.
- Perrin
On Thu, Nov 7, 2013 at 1:07 PM, Xinhuan Zheng wrote:
> I only looked at Apache::DBI not DBI document.
>
> My test program works. It
I only looked at Apache::DBI not DBI document.
My test program works. It reconnects to database OK. I ran it multiple times
and every time it reconnects OK. But Apache::DBI doesn't work. You saw the
previous debugging info. Where is the problem?
- xinhuan
From: Perrin Harkins mailto:
;On 13-11-07 11:29 AM, Xinhuan Zheng wrote:
> >> one correct - In both cases, the return value is evaluated to false.
> >>
> >> How do you distinguish?
> >>
> >> - xinhuan
> >>
> >> From: Xinhuan Zheng >> <mailto:xzh...@christ
t;> From: Xinhuan Zheng > <mailto:xzh...@christianbook.com>>
>> Date: Thursday, November 7, 2013 11:12 AM
>> To: Perrin Harkins mailto:phark...@gmail.com>>
>> Cc: mod_perl list ><mailto:modperl@perl.apache.org>>
>> Subject: Re: Apache::DB
return value is evaluated to false.
How do you distinguish?
- xinhuan
From: Xinhuan Zheng mailto:xzh...@christianbook.com>>
Date: Thursday, November 7, 2013 11:12 AM
To: Perrin Harkins mailto:phark...@gmail.com>>
Cc: mod_perl list mailto:modperl@perl.apache.org>>
Subject:
l.apache.org>>
Subject: Re: Apache::DBI connect
> I don't actually understand why you did that. What was wrong with the normal
> ping?
With Oracle DRCP, even though ping succeeds, the connection to the server
process is actually terminated. Or ora_ping() may return 0E0 "
ping() is foreign to me. I made the change based
on what Apache::DBI the document said.
> In any case, there's no need to change the Apache::DBI code, even with your
> "select 1 from dual" test. It returns a true value (0E0) if it succeeds and
> a false value (undef
to test for undef.
> Since I changed DBD::Oracle subroutine ping to use 'select 1 from dual',
I don't actually understand why you did that. What was wrong with the
normal ping?
In any case, there's no need to change the Apache::DBI code, even with your
"select 1 from du
uot;);
print "last ok = $ok\n";
print "last disconnect\n";
$dbh1->disconnect;
}
After sleeping 501 seconds, the 2nd 'select 1 from dual' failed with
"DBD::Oracle::db ping failed: ORA-03113: end-of-file on communication channel"
error, since DRCP MAX_THINK_TI
gt; document:
>
> http://search.cpan.org/~phred/Apache-DBI-1.12/lib/Apache/DBI.pm
>
> I have changed the DBD::Oracle to use the following ping instead of
> ora_ping:
>
> sub ping {
> my ($dbh) = @_;
> my $ret = 0;
> eval {
> local $SIG{__DIE__} = sub { return (0); };
&g
Hi Perrin,
I am using Oracle Resident Connection Pool feature. The application randomly
got "ORA-03114 not connect to oracle database" error. As per this document:
http://search.cpan.org/~phred/Apache-DBI-1.12/lib/Apache/DBI.pm
I have changed the DBD::Oracle to use the following pi
On Wed, Nov 6, 2013 at 4:07 PM, Xinhuan Zheng wrote:
> I wonder this line of code should be changed to 'DBI->connect(@args) if
> ($@)'. If ping failed, that means the connection is already closed, $drh
> may be no longer valid, will $drh->connect always return a valid new
> connection? What's the
Hi,
I am using Apache+mod_perl and Apache::DBI with Oracle connection pooling
feature. I noticed a problem with subroutine connect. Below code checks
database connection:
200:if ($Connected{$Idx} and (!$needping or eval{$Connected{$Idx}->ping})) {
debug(2, "$prefix
rrin Harkins mailto:phark...@gmail.com>>
Date: Thursday, June 13, 2013 11:03 AM
To: Xinhuan Zheng mailto:xzh...@christianbook.com>>
Cc: "modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI "connection lost co
That's unfortunate. Are you using it the same way, with a DBI connection
in a block? I haven't seen anyone else mention a problem with it in
Apache 1.
- Perrin
On Wed, Jun 12, 2013 at 5:05 PM, Xinhuan Zheng wrote:
> Hi Perrin,
>
> Today I tested the Apache-DBI 1.12 wit
Hi Perrin,
Today I tested the Apache-DBI 1.12 with Apache 1.3.42 and mod_perl 1. We have
to use mod_perl 1 in some situations. There is same issue when startup.pl has
created database handle. This database handle gets cached and forked across
child processes. With debugging turned on, there
Thanks Fred!
On Wed, Jun 12, 2013 at 3:29 AM, Fred Moyer wrote:
> Apache-DBI 1.12 was just pushed to CPAN with this update. Thanks for
> the great work on the fix Perrin.
>
> On Thu, Jun 6, 2013 at 2:53 PM, Perrin Harkins wrote:
> > That's great! I'll commit the p
Apache-DBI 1.12 was just pushed to CPAN with this update. Thanks for
the great work on the fix Perrin.
On Thu, Jun 6, 2013 at 2:53 PM, Perrin Harkins wrote:
> That's great! I'll commit the patch and see about getting a new release out
> to CPAN.
>
> - Perrin
>
>
>
r anymore. The patch looks good to me.
>
> Thanks,
> - xinhuan
>
> From: Perrin Harkins
> Date: Thursday, June 6, 2013 3:02 PM
> To: Xinhuan Zheng
> Cc: "modperl@perl.apache.org"
>
> Subject: Re: Apache::DBI "connection lost contact" error
>
&g
hristianbook.com>>
Cc: "modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI "connection lost contact" error
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng
mailto:xzh...@christianbook.com>>
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng
wrote:
> The database handle that is created in startup.pl needs to be really
disconnected (not overloaded disconnect) so that won't leave an idle server
> process running on the database side. Once it's really disconnected, the
server process can be
om>>
Cc: Jim Schueler mailto:jschue...@eloquency.com>>,
"modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI "connection lost contact" error
On Tue, Jun 4, 2013 at 2:32 PM, Xinhuan Zheng
ma
27;s very necessary. Otherwise, if your code throws an uncaught exception
in the middle of some database work, the next request would reuse the same
handle with uncommitted changes left on it. In my opinion, this is the
most important thing about Apache::DBI.
I understand you're worried abou
n
From: Perrin Harkins mailto:phark...@gmail.com>>
Date: Tuesday, June 4, 2013 12:18 PM
To: Xinhuan Zheng mailto:xzh...@christianbook.com>>
Cc: Jim Schueler mailto:jschue...@eloquency.com>>,
"modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:m
On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng
wrote:
> Will the new connection that's created be cached after then and the
connection that's not ping-able will be discarded?
Yes.
> Will this cached the new connection last until the child process exit?
Yes, unless it times out on the Oracle side
o replace it.
It looks like we still can use the way we do with Apache::DBI safely. The child
process creates the new connection and replaces the one that's inherited but
not ping-able. Will the new connection that's created be cached after then and
the connection that's not ping-a
On Mon, Jun 3, 2013 at 4:36 PM, Dave Morgan wrote:
> As an administrator I still rely and depend on Apache::DBI, even if it is
unsupported.
Can we kill this rumor please? Apache::DBI is supported.
- Perrin
On Mon, Jun 3, 2013 at 2:36 PM, Dave Morgan wrote:
> On 06/03/2013 03:14 PM, Perrin Harkins wrote:
>
> DO NOT USE Apache::DBI with DBI::Connector or any other database caching
> technique. This requires
> knowledge of the code!!!
DBIx::Class monkey patches Apache::DBI so t
On 06/03/2013 03:14 PM, Perrin Harkins wrote:
On Monday, June 3, 2013, Xinhuan Zheng wrote:
> What is the check to see if the server is restarting? Is that new child
processes spawning?
I always found the best way to run/test Apache::DBI was to run a mod-perl
enabled http server with
On Monday, June 3, 2013, Xinhuan Zheng wrote:
> What is the check to see if the server is restarting? Is that new child
processes spawning?
It's a test for whether or not we're running in the parent process, used to
skip caching connections during startup. It's this, line 128:
if (Apache2::ServerU
Hi Perrin,
> Does Apache::DBI work right with Apache2+mod_perl2?
Yes, but there may be a bug in how it checks to see if the server is restarting.
What is the check to see if the server is restarting? Is that new child
processes spawning?
If there is a bug in how it checks to see if the ser
On Fri, May 31, 2013 at 5:45 PM, Xinhuan Zheng
wrote:
> 2520 Apache::DBI skipping connection during server startup,
read the docu !!
> 2520 Apache::DBI skipping connection during server startup,
read the docu !!
That's good.
> 2521 Apache::DBI
I set this DEBUG in Apache::DBI module. Here is the debugging error it produces
at 'apachectl start':
2520 Apache::DBI skipping connection during server startup, read
the docu !!
2520 Apache::DBI skipping connection during server startup, read
the docu !!
2
Jim,
Jim Schueler wrote:
With regards to Apache::DBI, it is very much supported :)
No. It is not. What little I know of you, you seem knowledgable and
experienced. But you don't seem to have read this thread. The
documentation says that the module will be supported by this list
rs step
up. It's generally how CPAN (and now Github) works to a large degree.
On Fri, May 31, 2013 at 1:41 PM, Jim Schueler wrote:
>> With regards to Apache::DBI, it is very much supported :)
>
>
> No. It is not. What little I know of you, you seem knowledgable and
> e
Jim,
I just don't see the issue with not having an individual's name on one of
the mod_perl modules as the support contact. To me, Apache::DBI is being
supported, exactly as the documentation says. Someone wrote to the mailing
list, asked a question, and received responses that were
With regards to Apache::DBI, it is very much supported :)
No. It is not. What little I know of you, you seem knowledgable and
experienced. But you don't seem to have read this thread. The
documentation says that the module will be supported by this list, and the
facts now demons
on.
It's a slow process, but one has to patiently overcome years of Java and MS propaganda,
and that doesn't happen in a day.
Also,
the significant question seems to be whether Apache::DBI is supported or
not.
From Mr. Zheng's point-of-view (in this case, the one that matter
bit more murky in that individual authors can decide to
deprecate modules, or they can drop off the face of the earth, but
widely used modules such as Apache::DBI, SOAP::Lite (maintenance
recently stewarded by yours truly) will almost always have volunteers
step up and maintain them, because those
y: Is
the number of unsupported modules 2.5% or 25%? (For more rhetorical
nit-picking, you probably don't use the ones that don't work :) Also, the
significant question seems to be whether Apache::DBI is supported or not.
From Mr. Zheng's point-of-view (in this case, the one that matters
> the perl web dev world is more splintered and there are fewer people
> on the mod_perl list than there used to be. That's a little sad for
> me to see, but the new stuff is pretty nice too, and lots of people
> are still using mod_perl and answering questions on this list.
>
I wonder if the
module is no longer supported, don't lie about it. Support forums are
an incredible resource. But if commercial software developers similarly
blurred this distinction, every p.o.s. would be advertising free 24x7
tech support.
Apache::DBI seems like a #2 pretending to be a #3. On the bas
pport is
a common practice with any widely used module, e.g. DBI.
Apache::DBI is obsolete in the sense that most people are using an ORM
framework that handles database persistence for them, so they have no use
for Apache::DBI. It's not broken, and people should feel free to use it if
it fits thei
onger supported, don't lie about it. Support forums are an
incredible resource. But if commercial software developers similarly
blurred this distinction, every p.o.s. would be advertising free 24x7 tech
support.
Apache::DBI seems like a #2 pretending to be a #3. On the basis of your
resp
Hi Jim,
I appreciate the thought, but I'm not the mod_perl list. If you look at
who has done the most support around here recently, it's probably Torsten.
(Thanks Torsten!) More to the point, there are many people on the list
who know enough perl to help with a question about A
There's an existing thread with an Apache::DBI question. But since I want
to post a separate question to this list, I decided to start a new thread.
Just got done reading the Man page for Apache::DBI. One of the last
notes suggests that this package is obsolete (having been replac
Well, you are on the modperl list, so that means you. :)
Xinhuan, the error is harmless, but if you're concerned about it I would
try turning on debugging to make sure the connection is not being cached.
Do this:
$Apache::DBI::DEBUG = 2;
And then watch for a message like this in you
I'm afraid I'm out of my league. I just noticed the following comment on
the Apache::DBI man page:
Edmund Mergl was the original author of Apache::DBI. It is now supported
and maintained by the modperl mailinglist, see the mod_perl documentation
for instructions on how to
out of scope, the
>> destroy
>> call will disconnect. But it appears even though variable is out
>> of scope,
>> we still get that error. Don't know why.
>> - xinhuan
>>
>> On 5/30/13 8:31 AM, "Jim Schueler"
/13 8:31 AM, "Jim Schueler"
wrote:
>Did this solve your problem?
>
> -Jim
>
>On Wed, 29 May 2013, Perrin Harkins wrote:
>
>> Hi,
>> Apache::DBI is supposed to skip caching if you connect during
startup.
Don't know why.
> - xinhuan
>
> On 5/30/13 8:31 AM, "Jim Schueler" wrote:
>
> >Did this solve your problem?
> >
> > -Jim
> >
> >On Wed, 29 May 2013, Perrin Harkins wrote:
> >
> >> Hi,
> >> Apache::DBI is supposed
>
> -Jim
>
>On Wed, 29 May 2013, Perrin Harkins wrote:
>
>> Hi,
>> Apache::DBI is supposed to skip caching if you connect during startup.
>>You
>> should just need to disconnect your database handle after you finish
>>with
>> it. It sounds like you
Did this solve your problem?
-Jim
On Wed, 29 May 2013, Perrin Harkins wrote:
Hi,
Apache::DBI is supposed to skip caching if you connect during startup. You
should just need to disconnect your database handle after you finish with
it. It sounds like you're opening it and then leavi
Hi,
Apache::DBI is supposed to skip caching if you connect during startup. You
should just need to disconnect your database handle after you finish with
it. It sounds like you're opening it and then leaving it open.
- Perrin
On Wed, May 29, 2013 at 3:24 PM, Xinhuan Zheng wrote:
mod_perl2 (prefork). perl
binary is 5.10.1. In startup.pl file there is call
Apache::DBI->connect_on_init.
use Apache::DBI;
Apache::DBI->connect_on_init( $DB_DRIVER, $DB_USER, $DB_PASSWORD );
use DBI;
I need to call DBI->connect to load some data during server startup stage.
There is pro
Hi,
I have apache 2.2.23 statically compiled with mod_perl2 (prefork). perl binary
is 5.10.1. In startup.pl<http://startup.pl/> file there is call
Apache::DBI->connect_on_init.
use Apache::DBI;
Apache::DBI->connect_on_init( $DB_DRIVER, $DB_USER, $DB_PASSWORD );
use DBI;
I need
On Tuesday, 05 June 2012 10:52:54 Erik Scholtz wrote:
> thanks for your answer, which confirms my observation on this: Do you
> have documents that will explain this behaviour in detail?
Simple explanation, you have a single thread of execution. It can either block
on the database or watch for e
André,
thanks for your answer, which confirms my observation on this: Do you
have documents that will explain this behaviour in detail?
Greetings,
Erik
If a http-connection drops (for any reason), while a huge amount of
data is loaded from the database to the webserver, will Apache::DBI
g
> as it takes.
>
> When it is done talking to the database server, and starts sending the data
> to the client, then it will get the error and probably crash, unless it is
> prepared for such errors and returns nicely.
After all that, Apache::DBI will issue a rollback on the database
Erik Scholtz wrote:
Hi,
I have a small question about the Apache::DBI behaviour:
If a http-connection drops (for any reason), while a huge amount of data
is loaded from the database to the webserver, will Apache::DBI cancel
the loading (means cancel the query) or will it continue loading the
Hi,
I have a small question about the Apache::DBI behaviour:
If a http-connection drops (for any reason), while a huge amount of data
is loaded from the database to the webserver, will Apache::DBI cancel
the loading (means cancel the query) or will it continue loading the
data till the end
On Thu, Jan 19, 2012 at 8:48 AM, Josh Narins wrote:
> The idea of Apache::DBI is that you get to pool connections.
>
> If you call Apache::DBI->new and there is a spare connection, you get it, if
> not, one is created for you.
That's a little misleading. There's no act
> From: Perrin Harkins
> However, if you are trying to make the handle persistent
>yourself, by putting it in a global variable or something similar,
>that will be a problem. You have to close all connections you open
>during startup, and open new ones in the child processes.
>
heres kinda s
On 01/19/2012 08:48 AM, Josh Narins wrote:
The idea of Apache::DBI is that you get to pool connections.
If you call Apache::DBI->new and there is a spare connection, you get
it, if not, one is created for you.
This isn't quite accurate. Apache::DBI doesn't do connection pooling
The idea of Apache::DBI is that you get to pool connections.
If you call Apache::DBI->new and there is a spare connection, you get it, if
not, one is created for you.
You almost certainly don't want one $db object being shared as a member of a
class, unless your entire program also ha
ngst all apache
> processes, or will each process load this library on its own thus having a
> unique db handle for each httpd process?
Apache::DBI does not make handles persistent when you open them during
startup. However, if you are trying to make the handle persistent
yourself, by p
e.com/
>
> From: mike cardeiro
>To: modper
>Sent: Wednesday, January 18, 2012 10:08 PM
>Subject: preloading modules and apache::dbi
>
>
>Hi,
>
>
>I am totally new to mod perl (after 13+ years of building web applications on
&g
Hi,
I am totally new to mod perl (after 13+ years of building web applications on
shared servers I now am developing on a dedicated box woo-hoo)
I have installed apache::dbi and set it to preload in the apache config file.
Here is what I think my problem might be.
I have a library I want to
Apache::DBI 1.11 has been released with a perl 5.14 compatibility update.
1.11 October 7, 2011
- RT 69087, Perl 5.14 'Using qw(...) as parentheses' fix
Forwarded message:
> From: PAUSE
> Reply To: cpan-uplo...@perl.org
> To: Fred Moyer
> Date: Friday, October 7, 201
How about DBIx::Connector?
On Tue, Aug 2, 2011 at 6:30 AM, Feng He wrote:
> Hi,
>
> I just want to develop a modperl application.
> It's a handler, the database is Mysql.
> Shall I use Apache::DBI, or DBI is just fine ?
>
> Thank u.
> Regards.
>
--
Your cl
On Wed, Aug 3, 2011 at 2:49 AM, Feng He wrote:
> ab -n 100 -c 3 http://bizstatus.game.yy.com/upload/?arguments
>
>
> When the client number is larger than one, the items number in
> database is not correct.
> it's always larger than 100, for example, 101, 102, 103 etc.
>
> So, what's wrong with my
On 8/3/2011 2:49 AM, Feng He wrote:
Hi,
Thank you all for the info.
I have finished writting the handler this morning, and have enabled
Apache::DBI in httpd.conf.
My handler is for this url:
http://bizstatus.game.yy.com/upload/
It accept client's uploaded data and write the data to dat
Hi,
Thank you all for the info.
I have finished writting the handler this morning, and have enabled
Apache::DBI in httpd.conf.
My handler is for this url:
http://bizstatus.game.yy.com/upload/
It accept client's uploaded data and write the data to database.
The strange stuff is, when I run
1 - 100 of 732 matches
Mail list logo
