Re: DBD::mysql::st execute failed: Out of memory

I'm not sure how to help you with this.  If you don't get a reply 
that's satisfactory
try [email protected]



Boysenberry

boysenberrys.com | habitatlife.com | selfgnosis.com

On Mar 16, 2006, at 4:30 PM, Dustin Tenney wrote:

> So I have a query joining two large tables - about 4 million rows each 
> that
> is throwing this error.  The query will work fine from the mysql cli, 
> but
> when being called from perl I get this:
>
> DBD::mysql::st execute failed: Out of memory (Needed 56657250 bytes) at
> ./find.pl line 22.
> DBD::mysql::st fetchrow_array failed: fetch() without execute() at 
> ./find.pl
> line 23.
>
>
> A restart of mysql fixes the problem for a week or so.  The error log 
> for
> mysql also shows an error of:
>
> [ERROR] /mysql/libexec/mysqld: Sort aborted
>
>
> So it would appear to be running out of sort space.  The machine has 
> 4G of
> ram and mysql is only using about 3G.  I have adjusted the sort 
> buffers way
> up and it has not helped.  When it fails it always complains that it 
> needs
> around the exact same amount (54M).  The perl script was on a different
> machine with virtually 4G to its disposal.
>
> I asked on the forums and got no replies.  Any help would be 
> appreciated.
> Thank you.


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]