On Fri, Aug 16, 2002 at 04:07:52PM -0700, Michael G Schwern wrote:
On Tue, Aug 13, 2002 at 10:22:35PM +0100, Tim Bunce wrote:
But how about a new method:
DBI-connect_method(connect);
DBI-connect_method(Apache::DBI::connect); # effectively what use
Apache::DBI; does now
On Tue, Jun 18, 2002 at 12:48:57PM +0200, Per Einar Ellefsen wrote:
Hi people,
Time for a post that's a little different than your usual New user and
New module e-mails :) I'm posting here since it seems like the most
appropriate place to discuss these issues.
I adressed an issue on
On Sun, Dec 30, 2001 at 02:12:47PM -0600, Steven Lembark wrote:
W/ current apache and mod_perl, perl-5.6.1, Solaris-2.8.
Been having problems with DBI dropping connections. One
suggestion was to override the default of no and use
the malloc that comes with perl-5.6.1.
Anyone know of
On Thu, Aug 23, 2001 at 11:19:22AM -0700, Kyle Oppenheim wrote:
3. Apache::DBI intercepts the connect(), looks in it's hash and sees that it
already has a connection. It pings the handle, fails, and deletes the entry
from the hash. That's the last refcount on the dbh, so DESTROY gets
On Thu, Aug 02, 2001 at 07:10:49PM +0300, raptor wrote:
This may be of interest:
http://search.cpan.org/doc/TIMB/DBI_Talk5_2001/sld059.htm
]- Where is $h-{FetchHashKeyName}, I didn't found it even in the source
perl -m DBI my version is 1.18
Umm, let's see... that talk was given
On Mon, Jul 30, 2001 at 03:30:48PM -0400, Philip Mak wrote:
On Mon, 30 Jul 2001, Scott Kister wrote:
uselargefiles=define
Have you tried turning off uselargefiles?
I might be off track here, but recently I tried to install mod_perl on
Solaris 5.8. It kept segfaulting until I turned
On Fri, Jul 27, 2001 at 05:38:12PM -0700, Adi Fairbank wrote:
Joshua Chamas wrote:
Castellon, Francisco wrote:
Hi I am running on Windows98SE, Apache 1.20, mod_perl 1.25, php 4.0.6, and
have the latest Apache::ASP installed and have Activestate's Perl installed
(build 626).
On Wed, Aug 01, 2001 at 01:19:58PM -0500, Dave Rolsky wrote:
On Wed, 1 Aug 2001, Kyle Dawkins wrote:
I've taken a look at many of them (Tangram? a few others) and haven't been
impressed with any of them. I think part of the problem is that they're all
being developed in a bit of a
On Wed, Aug 01, 2001 at 05:29:10AM -0700, Daniel wrote:
Nicely put Nick. There's already a Structured Query Language,
And there's an easy to use abstraction called DBI up on CPAN.
Feel free to use in application code thusly:
my $statement = qq~
SELECT field1, field2
FROM
On Wed, Apr 11, 2001 at 08:22:38PM -0700, Randal L. Schwartz wrote:
In an .htaccess, I place:
Options +ExecCGI
PerlFixupHandler "sub { -f $_[0]-filename and -x _ and
$_[0]-handler(q{cgi-script}) }"
Now any executable file in this directory (or below) is processed with
mod_cgi.
You would only get that message if AutoCommit was off.
It should not be off for DBD::mysql (since it doesn't yet support
the transaction features of newer versions).
Plus, disconnect doesn't do anything when using Apache::DBI
(by design).
Tim.
On Wed, Apr 04, 2001 at 11:49:17PM -0400, Alec
On Thu, Apr 05, 2001 at 05:00:40PM -0400, Daniel wrote:
Has anybody attempted to modify Apache::DBI to force a handle to disconnect?
eg. $dbh-forcibly_disconnect;
Fetch the latest - read the docs - if not found - implement yourself
- send a patch - help save the world.
Tim.
On Fri, Mar 09, 2001 at 12:44:59AM -0500, Bill Desjardins wrote:
Just as a FYI about something that caught my attention recently. This year
on Saturday September 8, 2001, the unix time stamp flips to 1 billion and
gets another digit going from 9 to 10 digits. Not sure if anyone else but
me
On Mon, Feb 19, 2001 at 03:23:10AM -0800, Ask Bjoern Hansen wrote:
Hi,
I had a volunteer to help out maintaining Apache::DBILogger (Jens
Kristian Soegaard - thanks!) so I finally got around to put it into
sourceforge instead of just in my own local repository.
I think that I have found
On Thu, Feb 15, 2001 at 09:04:43AM -0500, Pierre Phaneuf wrote:
Apache::Schedule let you register callbacks (per Apache child process)
that will be called after a given amount of time has passed, either once
or repeatedly. Callbacks will be called at the next request after the
required
On Tue, Feb 13, 2001 at 11:28:20AM +, Malcolm Beattie wrote:
you'll see that IBM reckons you can get down to $500 per server
(disk not included) by putting 2500 instances on a brand new fancy
$1.2 million z900.
Assuming all the virtual linux servers were fully loaded with tasks
(say
Last week I asked...
On Thu, Feb 01, 2001 at 01:51:56PM +, Tim Bunce wrote:
Can anyone recommend extra gcc options to squeeze the last ounce of
performance out of code (perl and apache in this case) on Intel?
I don't mind tying the code down to one cpu type or loosing the ability
I recall someone once created a whole bunch of gdb macros for debugging
perl. I've CC'd this to p5p in the hope that someone remembers.
Tim.
On Tue, Feb 06, 2001 at 12:32:45PM -0800, sterling wrote:
If you're looking for which piece of perl code being processed, there
are some gdb macros to
[Thanks for all the feedback on this from everyone.]
On Thu, Feb 01, 2001 at 05:20:11PM +, G.W. Haywood wrote:
The compiler isn't the place to look for performance gains. Look to
your system architecture, Perl code. See if you can code the things
that get executed the most in C. Use
Can anyone recommend extra gcc options to squeeze the last ounce of
performance out of code (perl and apache in this case) on Intel?
I don't mind tying the code down to one cpu type or loosing the ability
to debug etc. We're already doing -O6 and are looking for more.
I recall Malcom Beattie
On Mon, Jan 15, 2001 at 08:37:18PM -0800, Ask Bjoern Hansen wrote:
On Mon, 15 Jan 2001, Edmund Mergl wrote:
any comments ?
[count number of times a user has logged in and such things]
Other people would like to count / note / ... other things.
It would be neater if you made an API
On Thu, Jan 11, 2001 at 03:09:43PM +0100, Stas Bekman wrote:
* dbm.pod:
o reviewed/rewritten/corrected
Any volunteers to extend this, or at least suggest additions, in
relation to using Berkeley DB v3 in 'shared memory' configuration?
Tim.
On Wed, Jan 10, 2001 at 07:53:23PM -0500, Ed Park wrote:
John--
Another thing you may want to look into is just doing an
"alter session set current_schema" call at the top of your mod_perl page.
This is actually significantly faster than Tim's reauthenticate solution
(about 7X, according
On Thu, Dec 14, 2000 at 07:54:06PM +0100, Stas Bekman wrote:
On Thu, 14 Dec 2000, Tom Brown wrote:
On Thu, 14 Dec 2000, Stas Bekman wrote:
On Thu, 14 Dec 2000, Tim Bunce wrote:
On Thu, 14 Dec 2000, Stas Bekman wrote:
and the script was dying on that error
On Thu, Dec 14, 2000 at 11:47:58AM +1100, Jie Gao wrote:
On Thu, 14 Dec 2000, Stas Bekman wrote:
I think that this item from the guide is not relevant anymore. Can I
kill it?
=head3 The Morning Bug
Relational database server keeps a connection to the client open for a
limited
On Thu, Dec 14, 2000 at 09:34:58AM -0800, Michael Peppler wrote:
Tim Bunce writes:
Was there a problem with ping on DBD::Sybase?
Has it been resolved?
I believe that ping() was fixed in 0.90.
Thanks Michael.
Tim.
- Forwarded message from Jie Gao [EMAIL PROTECTED
The long time mythical
use less qw(memory);
pragma was always intended to address issues like that. It would be
fairly straightforward to implement (set a flag like use strict and
check it wherever memory could usefully be freed).
Tim.
On Sat, Dec 09, 2000 at 07:53:38PM +0300, Ivan E.
On Fri, Dec 08, 2000 at 05:47:00AM -0500, Ed Park wrote:
So far, I've written up a basic scaling framework, and I've posted a
particular development profiling tool that we wrote to capture, time, and
explain all SQL select queries that occur on a particular page of a mod_perl
+ DBD::Oracle
On Wed, Dec 06, 2000 at 04:24:24PM -0800, Perrin Harkins wrote:
On Wed, 6 Dec 2000, Paul wrote:
I was pointed to IPC::Sharable, IPC::Sharelite.
I'll look at those.
Take a look at IPC::MM for a shared memory hash implemented in C. Also,
File::Cache is sometimes faster than the IPC
On Fri, Dec 01, 2000 at 02:37:47AM +0100, Stas Bekman wrote:
It would be much easier for Tim to do it from the inside than any of us
doing the overloading hacking, but that's up to Tim to decide when if ever
this should go in :)
Things are changing for the better workwise now and I hope to
On Fri, Dec 01, 2000 at 09:48:34AM +, Matt Sergeant wrote:
On Fri, 1 Dec 2000, Tim Bunce wrote:
On Fri, Dec 01, 2000 at 02:37:47AM +0100, Stas Bekman wrote:
It would be much easier for Tim to do it from the inside than any of us
doing the overloading hacking, but that's up
On Fri, Dec 01, 2000 at 12:23:26PM +, Greg Cope wrote:
Tim Bunce wrote:
Although a bit OT, but I am sure everyone is interested, what changes
are you planning for DBI ?
There's a ToDo file in the dist. I've probably a few others rattling
around in my head.
Tim
On Wed, Nov 22, 2000 at 10:57:46AM -0800, Perrin Harkins wrote:
We got past these problems and then ran
into issues with db corruption. If Apache gets shut down with a SIGKILL
(and this seems to happen fairly often when using mod_perl),
Really? Why? I've not been aware of anyone needing to
On Wed, Nov 22, 2000 at 02:17:25PM +0300, Ruslan V. Sulakov wrote:
Hi, Tim!
I'd like to use BerkeleyDB! But have you test it in mod_perl environment?
Not yet, but I will be very soon. I'm sure others are using it.
May be I wrote scripts in wrong fasion.
I open $dbe and $db at startup.pl
On Mon, Nov 13, 2000 at 01:55:38PM -0500, Aaron wrote:
Don't get me wrong here, "but", it would be nice if the undocumented
somehow made it to the documented status.
yeah... but Apache::DBI and DBI are in cahoots! it's a secret love that
no documentation can break apart!
On Thu, Nov 09, 2000 at 11:54:42AM -0800, Ask Bjoern Hansen wrote:
On Wed, 11 Oct 2000, Matt Sergeant wrote:
If you're always looking stuff up on simple ID numbers and
"stuff" is a very simple data structure, then I doubt any DBMS can
beat
open D, "/data/1/12/123456" or ...
from a
On Thu, Nov 09, 2000 at 08:27:29PM +, Matt Sergeant wrote:
On Thu, 9 Nov 2000, Ask Bjoern Hansen wrote:
On Wed, 11 Oct 2000, Matt Sergeant wrote:
Most modern DBMS software should be able to handle 50 queries per second
on decent hardware, provided the conditions are right.
On Mon, Nov 06, 2000 at 09:19:04PM -0500, Thomas A. Lowery wrote:
On Mon, Nov 06, 2000 at 04:19:13PM +, Tim Bunce wrote:
On Thu, Nov 02, 2000 at 10:10:09PM -0800, Perrin Harkins wrote:
Tim Bunce wrote:
You could have a set of apache servers that are 'pure' DBI proxy servers
On Fri, Oct 27, 2000 at 12:26:44PM +0100, Matt Sergeant wrote:
Or, here's an odd thought that just crossed my mind...
You could have a set of apache servers that are 'pure' DBI proxy servers.
That is, they POST requests containing SQL (for prepare_cached) plus
bind parameter values
On Tue, Oct 24, 2000 at 03:09:47PM -0500, Jeff Horn wrote:
I basically want to do what the big TP monitors (Tuxedo/Encina/CICS) do with respect
to condensing connections to a database, but I'm not in need of features like
two-phase commit, cross database joins, heterogeneous database
It has promise but needs someone to polish it up.
(I didn't write it and have barely looked at the code.)
Tim.
On Tue, Sep 19, 2000 at 12:50:57PM -0700, Tom Lancaster wrote:
I know, seems promising, doesn't it, especially after the overview in
the DBI book. On the other hand, you can do most
On Tue, Sep 05, 2000 at 10:38:48AM -0700, Michael Peppler wrote:
The idea is to create a pool of connections during the main
apache/modperl startup. [...]
This technique works with Sybase connections using either
DBI/DBD::Sybase or Sybase::CTlib (I've not tested Sybase::DBlib, nor
any
On Tue, Aug 15, 2000 at 03:26:03PM +0400, Vladislav Safronov wrote:
Hi,
Could you have a look at the lines and answer the question ..
---
sub foo {
my $dbh = shift;
my $sql = ...
my $sth = $dbh-prepare($sql);
$sth-execute;
$sth-finish;
}
===
Do I
On Tue, Aug 15, 2000 at 12:22:46PM -0500, Jay Jacobs wrote:
On Tue, 15 Aug 2000, Tom Mornini wrote:
It is my understanding of the DBI docs that you only need to call
$sth-finish when you DON'T fetch all the rows that the $sth has ready to
return.
From "Writing Apache Modules
On Wed, Aug 16, 2000 at 08:26:09AM +0200, Henrik Tougaard wrote:
From: Jay Jacobs [mailto:[EMAIL PROTECTED]]
On Tue, 15 Aug 2000, Tom Mornini wrote:
It is my understanding of the DBI docs that you only need to call
$sth-finish when you DON'T fetch all the rows that the
$sth has
On Wed, Jul 26, 2000 at 01:54:51PM +0100, Tommy Wareing wrote:
On Wed, Jul 26, 2000 at 08:27:06AM -0400, Geoffrey Young wrote:
hi everyone...
I was just wondering if anyone has been able to get the newer releases of
DBD-Oracle to work under mod_perl?
that is, using DBD-Oracle
On Mon, Jun 05, 2000 at 12:49:46AM +0200, Eric Cholet wrote:
On Sun, Jun 04, 2000 at 08:58:11PM +0100, Tim Bunce wrote:
On Sun, Jun 04, 2000 at 10:57:57PM +0300, Stas Bekman wrote:
This all won't be possible without you and other great folks writing and
maintaining this amaizing
On Sat, Jun 03, 2000 at 02:49:47AM +0300, Stas Bekman wrote:
On Fri, 2 Jun 2000, Perrin Harkins wrote:
On Sat, 3 Jun 2000, Stas Bekman wrote:
* install_driver (2):
DBI-install_driver("mysql");
I've never seen that before,
There is always a first time :)
and it isn't in
On Sat, Jun 03, 2000 at 03:54:37AM +0300, Stas Bekman wrote:
Here is a complete version. comments are very welcome before it enters the
guide:
The first example is the CDBI module. As you know CDBI works with
many database drivers falling into the CDBD:: category,
e.g. CDBD::mysql. It's
On Sun, Jun 04, 2000 at 10:57:57PM +0300, Stas Bekman wrote:
This all won't be possible without you and other great folks writing and
maintaining this amaizing software... So the biggest thanks goes to you :)
I've not done much of either this last year, however, I'm hoping to get
a new beta
On Sat, May 20, 2000 at 08:01:36PM +0100, Malcolm Beattie wrote:
Matt Sergeant writes:
On Fri, 19 May 2000, David Larkin wrote:
I require a large array of ints in a real application, just stripped
problem down to bear bones for demo.
Is your array sparse by any chance? If not
On Thu, Feb 03, 2000 at 02:54:41PM -0600, Kent Perrier wrote:
"Randal L. Schwartz" wrote:
"John" == John Siracusa [EMAIL PROTECTED] writes:
John OTOH, it's a lot easier to track and respond to particular
John issues/problems in a threaded setting like Usenet.
Hmm. Get a
On Thu, Feb 03, 2000 at 01:01:43PM +0100, R. F. Lens wrote:
Hi,
We've been running a modperl environment 'on' a NetApp since dec 1997
and would't even dare to think about going back;). We've found no
gotcha's. Iff you can afford it I can really recommend it. The way we
use it is that we
On Wed, Feb 02, 2000 at 08:21:20PM +0200, Stas Bekman wrote:
This thread has drifted way off topic, but anyway...
my $do_sql = 'UNLOCK TABLES ';
$self-{sth} = $self-{dbh}-prepare($do_sql);
$self-{sth}-execute();
I'd express all that as:
$self-{dbh}-do("UNLOCK TABLES");
On Wed, Feb 02, 2000 at 08:21:20PM +0200, Stas Bekman wrote:
Oh, and while I'm being picky (nothing personal Stas!):
$self-{sth}-finish if defined $self-{sth} and $self-{sth};
$self-{dbh}-disconnect if defined $self-{dbh} and $self-{dbh};
There's no need to test for "defined" and
On Tue, Feb 01, 2000 at 10:29:30AM +0100, Elizabeth Mattijsen wrote:
At 11:16 1/31/00 -0800, siberian wrote:
My question is : Has anyone experienced any 'gotchas' in putting perl code
that modperl handlers use on a Network Attached file server like a network
appliance box ( www.netapp.com )?
On Mon, Jan 31, 2000 at 11:16:23AM -0800, siberian wrote:
Hi All-
I am building a pretty in depth architecture for our new service
using ModPerl. I've done a lot of large scale/high traffic apps in modperl
before but never in conjunction with a network attached file server. I am
On Mon, Jan 31, 2000 at 02:15:37PM -0800, Ian Struble wrote:
On Mon, 31 Jan 2000, Tim Bunce wrote:
On Mon, Jan 31, 2000 at 11:16:23AM -0800, siberian wrote:
Hi All-
I am building a pretty in depth architecture for our new service
using ModPerl. I've done a lot of large scale/high
On Fri, Jan 14, 2000 at 07:28:22PM -0500, Daniel Jacobowitz wrote:
The first really important one is a fix for the crashes I've been
seeing in boot_DBI. I can't find the exact message in the archive now,
but anyone who reported that a problem was fixed by setting
PERL_STARTUP_DONE_CHECK=1
On Tue, Jan 11, 2000 at 01:20:21PM -0800, Jeffrey W. Baker wrote:
Unfortunately, Oracle support is an ongoing criminal enterprise. Unless
you have the most expensive of all of their support contracts, and a
former Oracle VP on your staff, you will not get any support period. If
you
On Tue, Jan 11, 2000 at 02:50:52PM -0800, Ian Mahuron wrote:
Joshua but if you don't need transactions, go with MySQL...
Or sub-selects.. I can't live without sub-selects!
Sub-selects are high on the to-do list, and the rate that they're
advancing MySQL they'll be available quite soonish.
On Fri, Dec 03, 1999 at 12:00:38PM -0500, Young, Geoffrey S. wrote:
that's what I meant :)
Since %INC is a hash, and it's order unpredictable, it's possible that DBI
be re-required before Apache::DBI. But maybe something else is going on
too...
here's the code from the guide:
while
On Thu, Dec 02, 1999 at 06:59:26PM +, Michael Smith wrote:
I'm experiencing difficulties when using PerlFreshRestart modules that
depend on %INC. In my particular case I'm trying to use persistent
connections in DBI through Apache-DBI, and Apache/DBI is not in %INC
when PerlFreshRestart
On Mon, Nov 29, 1999 at 07:46:50PM -0500, Sam Tregar wrote:
On Mon, 29 Nov 1999, Tim Bunce wrote:
Ignoring 'thread' (unsafe for production use) and 'debug' modes, the
normal 'fork' mode means that each client gets a seperate ProxyServer
process. And because of that, clients have no way
On Mon, Nov 29, 1999 at 01:19:53PM -0800, Randal L. Schwartz wrote:
[watch the followups... this is going to both the modperl
and the DBI list...]
"Ed" == Ed Park [EMAIL PROTECTED] writes:
Ed each creates a network connection to DBI::ProxyServer, which
Ed creates a few persistent
On Fri, Nov 19, 1999 at 10:10:07AM -0800, Jeffrey Baker wrote:
if (defined @foo_in) {
Generally using defined() on aggregates is a bad idea.
Tim.
On Mon, Nov 01, 1999 at 09:01:48PM +, Tim Bunce wrote:
Has anyone experienced a situation where a process (httpd for example)
can't reconnect to Oracle after a "shutdown abort"?
Thanks for your replies.
The problem reported to me which prompted this email has actually
proven to
Has anyone experienced a situation where a process (httpd for example)
can't reconnect to Oracle after a "shutdown abort"?
Tim.
On Tue, Oct 26, 1999 at 03:57:09PM +0200, Gerald Richter wrote:
However, at the time of that test, I was using:
DBI 1.13
ApacheDBI 0.85
ModPerl 1.21
Apache 1.3.9
Perl 5.005_03 built for MSWin32-x86
I still have that machine, and I will willingly re-do the tests if
anybody
On Tue, Oct 26, 1999 at 11:59:07AM +0200, Victor Zamouline wrote:
I have been digging around in the FAQ and archives for information about
people running mod_perl on a windows box and also using Apache::DBI, but
have come up with nothing. I am under the impression that it is not
going to
On Sat, Oct 23, 1999 at 11:26:43PM +0200, Stas Bekman wrote:
Another similar request is scripts that dump core. I want to show gdb in
action, again with something useful in hand.
Here's one:
$ perl -e dump
Abort(coredump)
Thanks of course, Tim!
[I forgot to add a
On Mon, Oct 18, 1999 at 07:08:09AM -0700, Michael Peppler wrote:
Tim Bunce writes:
On Fri, Oct 15, 1999 at 11:42:29AM +0100, Matt Sergeant wrote:
On Fri, 15 Oct 1999, Perrin Harkins wrote:
On Thu, 14 Oct 1999, Jeffrey Baker wrote:
Zero optimization: 41.67 requests/second
72 matches
Mail list logo
