RE: DBD::mysql quote() memory leak - Clinton Gormley - com.mysql.lists.perl

4 messages in com.mysql.lists.perlRE: DBD::mysql quote() memory leak

From	Sent On	Attachments
Jochen Wiedmann	22 Aug 1999 05:20
Clinton Gormley	23 Aug 1999 01:58
Clinton Gormley	23 Aug 1999 02:54
Jochen Wiedmann	23 Aug 1999 03:21

Subject:	RE: DBD::mysql quote() memory leak
From:	Clinton Gormley (cli...@drtech.co.uk)
Date:	08/23/1999 02:54:10 AM
List:	com.mysql.lists.perl

in fact, the fix is :

In Makefile.PL, change these lines (17-19)

use ExtUtils::PerlPP (); use Cwd (); use lib "lib";

to :

use lib "lib"; use ExtUtils::PerlPP (); use Cwd ();

-----Original Message----- From: Clinton Gormley Sent: 23 August 1999 09:59 To: 'Jochen Wiedmann' Cc: Msql...@lists.mysql.com; modperl Subject: RE: DBD::mysql quote() memory leak

hi jochen

I've downloaded the 1.2203 version of the Msql-MySQL modules, but I can't create a Makefile - seems Makefile.PL doesn't set @INC correctly. (1.2202 works correctly)

Failing when looks for ExtUtils/PerlPP.pm

Thanks

-----Original Message----- From: Jochen Wiedmann [mailto:jo...@ispsoft.de] Sent: 22 August 1999 13:21 To: abha...@srv1dilurb.er.usgs.gov Cc: gd...@imsa.edu; Msql...@lists.mysql.com; modperl Subject: Re: DBD::mysql quote() memory leak

We've located and fixed a memory leak associated with $dbh->quote(). In dbd/dbd.xs.in, within the quote() function, we changed this line: SV* quoted = dbd_db_quote(dbh, str, type); to: SV* quoted = sv_2mortal(dbd_db_quote(dbh, str, type));

When I was uploading about 62MB of data, my perl process peaked at about 500MB in size. Now with this fix, it's sticking to about 4MB.

Thanks, Arun, this is updated in Msql-Mysql-modules 1.2203, which I am uploading to CPAN right now.

Anyone using DBD::mysql or DBD::mSQL in a daemon (for example mod_perl) is strongly suggested to upgrade.

Bye,

--- Jochen Wiedmann jo...@ispsoft.de Life has brown and green eyes. :-) +49 7123 14887