Re: [Sqlgrey-users] Memory Leak?

[Lionel B. <lio...@bo...>]

Matteo Niccoli wrote the following on 03.05.2007 18:45 :
> I'm running sqlgrey 1.7.4 with mysql support on a gentoo linux server
> with postfix 2.3.8
> I have 3 mysql server, 1 is master and the other are slaves.
>
> I see that each time I restart sqlgrey it uses about 12Mbyte of RAM.
> Afterk some days,
> 3-4, it uses 110Mbyte of RAM. If I don't restart it in a 3 week, it uses
> something like
> 1.1Gbyte of RAM :)
>
> At the moment I use a workaround based on a simple restart of sqlgrey
> once a week.
>
> Anyone of you can help me to find the solution to this problem?
>   

The problem is usually a bad version of DBI or the MySQL DBD driver. I
tried various methods in SQLgrey to avoid some code I suspected to leak
memory but never managed to solve the problem (in fact I could only make
it worse).
The only thing to do is to try newer or older versions of these perl
libraries (I managed to solve the same problem by reverting to an older
version of the PostgreSQL driver once).

Lionel