MySQL Forums
Forum List  »  Perl

Re: memory leak in 32-bit DBD::mysql on a 64-bit Linux host
Posted by: Moshe Sharon
Date: September 20, 2008 04:50AM

Hello

I know you posted this message a while a ago but I just stumbled your problem and had a similar issue.
you can solve this by using mysql_use_result in your connection string. this will set the client to allocate less memory then the store_result default settings.

in your perl script
- DBI->connect("DBI:mysql:test;mysql_use_result=1", "root", "");
- $dbh->{'mysql_use_result'}=0; #disable
- $dbh->{'mysql_use_result'}=1; #enable

reference:
http://dev.mysql.com/doc/refman/5.0/en/mysql-use-result.html

best regards
Moshe Sharon
http://www.centerity.com

Options: ReplyQuote


Subject
Written By
Posted
Re: memory leak in 32-bit DBD::mysql on a 64-bit Linux host
September 20, 2008 04:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.