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
I'd be interested in hearing about this too.
On Tue, Apr 22, 2014 at 10:02 AM, jbiskofski jbiskof...@gmail.com 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
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 pgbouncer
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 persistent connections
, Apache::DBI prevents you from making persistent connections
before the parent process forks. If you don't use it, you should
check your code to make sure that it closes any handles it opens
during server startup.
Second, there's the issue of what happens when your code throws an
exception
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 j...@lariat.co wrote:
I can speak to your final point. I recently deployed PGBouncer into our
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 phark...@gmail.com wrote:
Thanks John. Were you using Apache::DBI before PgBouncer?
Apache::DBI would also eliminate the overhead of establishing new
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 removing Apache
, Perrin Harkins phark...@gmail.com 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 connection
On Fri, Nov 8, 2013 at 2:58 PM, Xinhuan Zheng xzh...@christianbook.comwrote:
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 process
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 phark...@gmail.commailto:phark...@gmail.com
Date: Monday
in Apache::DBI? Or something
else in your own code?
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.
Yes, it should be.
However, I guess we also defined a base class
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't find a cached
://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); };
local $SIG{__WARN__} = sub { return (0); };
# adapt the select
, since DRCP MAX_THINK_TIME is configured for 500. The $ok is undef. In
the case if the test does succeed (like the first select), $ok returns 0E0.
Since I changed DBD::Oracle subroutine ping to use 'select 1 from dual', the
code in Apache::DBI subroutine connect needs to be changed also. I
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 dual test. It returns a true
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) if it fails.
In both cases, the return value is evaluated
: mod_perl list modperl@perl.apache.orgmailto:modperl@perl.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
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
zero but true and undef. I don't know
To: Perrin Harkins phark...@gmail.com mailto:phark...@gmail.com
Cc: mod_perl list modperl@perl.apache.org
mailto:modperl@perl.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
@perl.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
zero but true and undef. I
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 phark
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 xzh...@christianbook.comwrote:
I only looked at Apache::DBI not DBI document.
My test program works. It reconnects to database OK. I
...@utoronto.camailto:adam.pr...@utoronto.ca,
modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto: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 debugging print statements
of or
instead of and?
- xinhuan
From: Perrin Harkins phark...@gmail.com
Date: Thursday, November 7, 2013 3:05 PM
To: Xinhuan Zheng xzh...@christianbook.com
Cc: Adam Prime adam.pr...@utoronto.ca, modperl@perl.apache.org
modperl@perl.apache.org
Subject: Re: Apache::DBI connect
Sorry
but 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
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 already connected
On Wed, Nov 6, 2013 at 4:07 PM, Xinhuan Zheng xzh...@christianbook.comwrote:
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
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 ping instead
That's unfortunate. Are you using it the same way, with a DBI connection
in a Perl 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 xzh...@christianbook.comwrote:
Hi Perrin,
Today I tested the Apache-DBI
...@gmail.commailto:phark...@gmail.com
Date: Thursday, June 13, 2013 11:03 AM
To: Xinhuan Zheng xzh...@christianbook.commailto:xzh...@christianbook.com
Cc: modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
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 phark...@gmail.com wrote:
That's great! I'll commit the patch and see about getting a new release out
to CPAN.
- Perrin
On Thu, Jun 6, 2013
Thanks Fred!
On Wed, Jun 12, 2013 at 3:29 AM, Fred Moyer f...@redhotpenguin.com 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 phark...@gmail.com wrote:
That's great! I'll commit
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
Author: phred
Date: Wed Jun 12 07:30:17 2013
New Revision: 1492090
URL: http://svn.apache.org/r1492090
Log:
fix release args
Modified:
perl/Apache-DBI/trunk/RELEASE
Modified: perl/Apache-DBI/trunk/RELEASE
URL:
http://svn.apache.org/viewvc/perl/Apache-DBI/trunk/RELEASE?rev=1492090r1
Author: phred
Date: Wed Jun 12 07:30:38 2013
New Revision: 1492091
URL: http://svn.apache.org/r1492091
Log:
tag 1.12
Added:
perl/Apache-DBI/tags/rel_1.12/
- copied from r1492090, perl/Apache-DBI/trunk/
Author: phred
Date: Wed Jun 12 07:31:09 2013
New Revision: 1492092
URL: http://svn.apache.org/r1492092
Log:
roll on to 1.13-dev
Modified:
perl/Apache-DBI/trunk/Changes
perl/Apache-DBI/trunk/README
perl/Apache-DBI/trunk/lib/Apache/AuthDBI.pm
perl/Apache-DBI/trunk/lib/Apache/DBI.pm
Author: perrin
Date: Fri Jun 7 13:41:23 2013
New Revision: 1490646
URL: http://svn.apache.org/r1490646
Log:
Fix detection of server startup to avoid caching connections in the parent
process
Modified:
perl/Apache-DBI/trunk/lib/Apache/DBI.pm
Modified: perl/Apache-DBI/trunk/lib/Apache
Author: perrin
Date: Fri Jun 7 13:46:30 2013
New Revision: 1490648
URL: http://svn.apache.org/r1490648
Log:
Update changes and version
Modified:
perl/Apache-DBI/trunk/Changes
perl/Apache-DBI/trunk/lib/Apache/DBI.pm
Modified: perl/Apache-DBI/trunk/Changes
URL:
http://svn.apache.org
...@christianbook.com
Cc: Jim Schueler jschue...@eloquency.commailto:jschue...@eloquency.com,
modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Tue, Jun 4, 2013 at 2:32 PM, Xinhuan
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng xzh...@christianbook.com
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
...@christianbook.commailto:xzh...@christianbook.com
Cc: modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng
xzh...@christianbook.commailto:xzh...@christianbook.com
good to me.
Thanks,
- xinhuan
From: Perrin Harkins phark...@gmail.com
Date: Thursday, June 6, 2013 3:02 PM
To: Xinhuan Zheng xzh...@christianbook.com
Cc: modperl@perl.apache.org modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Thu, Jun 6, 2013 at 12:22
, 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 about it. I should be able to send you
On Mon, Jun 3, 2013 at 4:36 PM, Dave Morgan dave.mor...@100.com 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
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-able will be discarded? Will this cached
On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng xzh...@christianbook.com
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
@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng
xzh...@christianbook.commailto:xzh...@christianbook.com wrote:
Will the new connection that's created be cached after then and the
connection that's
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 server
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
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 without
On Mon, Jun 3, 2013 at 2:36 PM, Dave Morgan dave.mor...@100.com 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
On Fri, May 31, 2013 at 5:45 PM, Xinhuan Zheng xzh...@christianbook.com
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
that error. Don't know why.
- xinhuan
On 5/30/13 8:31 AM, Jim Schueler jschue...@eloquency.com 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.
You
should just need
Schueler jschue...@eloquency.com
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.
You
should just need to disconnect
,
we still get that error. Don't know why.
- xinhuan
On 5/30/13 8:31 AM, Jim Schueler jschue...@eloquency.com
wrote:
Did this solve your problem?
-Jim
On Wed, 29 May 2013, Perrin Harkins wrote:
Hi,
Apache::DBI
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 subscribe
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 your log
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 replaced
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 Apache::DBI
, 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
response, I've concluded
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 their use case
. 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
response, I've concluded that Apache::DBI is no longer supported and has
been superceded
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 fact
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
number might be much higher
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 volunteers need those modules
to be functioning for own
,
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 matters) the
number might be much higher.
-Jim
On Fri, 31 May 2013, André Warnier wrote:
Just butting in, apologies
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 demonstrate
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 trying
CPAN (and now Github) works to a large degree.
On Fri, May 31, 2013 at 1:41 PM, Jim Schueler jschue...@eloquency.com 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
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 !!
2521 Apache
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 leaving
?
-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 leaving it open.
- Perrin
On Wed, May 29
Hi,
I have apache 2.2.23 statically compiled with mod_perl2 (prefork). perl binary
is 5.10.1. In startup.plhttp://startup.pl/ file there is call
Apache::DBI-connect_on_init.
code
use Apache::DBI;
Apache::DBI-connect_on_init( $DB_DRIVER, $DB_USER, $DB_PASSWORD );
use DBI;
/code
I need to call
with mod_perl2 (prefork). perl
binary is 5.10.1. In startup.pl file there is call
Apache::DBI-connect_on_init.
code
use Apache::DBI;
Apache::DBI-connect_on_init( $DB_DRIVER, $DB_USER, $DB_PASSWORD );
use DBI;
/code
I need to call DBI-connect to load some data during server startup stage.
There is problem
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 xzh
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
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
that for as long
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
handle IF you
amongst 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 putting
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 happens
On Thu, Jan 19, 2012 at 8:48 AM, Josh Narins jnar...@seniorbridge.com 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 actual
/
From: mike cardeiro mcarde...@yahoo.com
To: modper modperl@perl.apache.org
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
shared servers I
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 upl...@pause.perl.org
Reply To: cpan-uplo...@perl.org
To: Fred Moyer f...@redhotpenguin.com
Date: Friday
Author: phred
Date: Fri Oct 7 20:35:34 2011
New Revision: 1180208
URL: http://svn.apache.org/viewvc?rev=1180208view=rev
Log:
Release 1.11 with perl 5.14 fix
Modified:
perl/Apache-DBI/trunk/Changes
perl/Apache-DBI/trunk/lib/Apache/AuthDBI.pm
perl/Apache-DBI/trunk/lib/Apache/DBI.pm
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 more
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 database
On Wed, Aug 3, 2011 at 2:49 AM, Feng He short...@gmail.com 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
How about DBIx::Connector?
On Tue, Aug 2, 2011 at 6:30 AM, Feng He short...@gmail.com 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 clothes may be the latest
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.
On Tuesday, 02 August 2011 15:30:28 Feng He wrote:
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 ?
It depends. Apache::DBI provides a transparent connection cache. You can
forget the DB handle acquired at some
On Aug 2, 2011, at 6:30 AM, Feng He wrote:
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 ?
I recommend DBIx::Connector.
Best,
David
you paid for it
This was meant to refer to my opinion, not your code, sorry.
Ah, okay.
Never ran Bricolage in production. Did run a test system, ugh.
I suspect the issue was with the Bricolage code, not Apache::DBI.
Based on what evidence, exactly?
I have never used connect_cached
of why anymore. connect_cached()
worked much better for me (though it's kind of a PITA to set up).
Never ran Bricolage in production. Did run a test system, ugh.
I suspect the issue was with the Bricolage code, not Apache::DBI.
I have never used connect_cached, never had the need.
snip
Dave == Dave Morgan dave.mor...@borealescapes.ca writes:
You lost me. But really, I strongly recommend against the use of
Apache::DBI. Some discussion here:
http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description
Dave And having read that, I strongly recommend
Hi Randal,
You lost me. But really, I strongly recommend against the use of
Apache::DBI. Some discussion here:
http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description
Dave And having read that, I strongly recommend against the use of
DBIx-Connector.
Dave
On Mon, Jun 27, 2011 at 12:53 PM, Octavian Rasnita orasn...@gmail.com wrote:
Here is a comment that might be helpful, because it also explains why
DBIx::Class can work with Apache::DBI (and why it is not needed):
http://lists.scsys.co.uk/pipermail/dbix-class/2006-April/001153.html
DBIx
not working as they expected:
[Mon Jun 27 13:05:17 2011] [notice] Apache/2.2.17 (Unix)
mod_apreq2-20090110/2.8.0 mod_perl/2.0.5 Perl/v5.12.3 configured --
resuming normal operations
8879 Apache::DBI new connect to 'dbname='...
In my startup.pl (My::Model is DBIx::Class based
On 27/06/11 02:22 PM, David E. Wheeler wrote:
On Jun 27, 2011, at 1:13 PM, Fred Moyer wrote:
Snip .
You lost me. But really, I strongly recommend against the use of Apache::DBI.
Some discussion here:
http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description
be because I have
Apache::DBI setup differently than they do.
You lost me. But really, I strongly recommend against the use of Apache::DBI.
Some discussion here:
http://search.cpan.org/dist/DBIx-Connector/lib/DBIx/Connector.pm#Description
It seems like you are looking for a more feature rich db
1 - 100 of 649 matches
Mail list logo