[rt-devel] RT still open too many connections to mysql

Joseph W. Breu breu at cfu.net
Tue Apr 1 02:25:32 EST 2003


If using the Apache::DBI module, then the connections are cached via
apache.  Just increase your max_connections, are set max_server in
httpd.conf to something reasonable.



> Hi,
>
> I still believe it's the problem that I tracked once few months ago.
> Adding DESTROY handler to DBIx::SearchBuilder
> with disconnect() in it actually helped.
> Perhaps it's seen on some special Perl/OS/DBI versions only.
> Normally DBI should disconnect by itself, shouldn't it?
>
> Mine was FreeBSD + Perl 5.6.1. I can't check the version of DBI.pm,
> since that server is no longer in use...
>
> Regards,
> Stan
>
>
> --- Jesse Vincent <jesse at bestpractical.com> wrote:
>> You need to have your apache start fewer processes than your mysqld will
>> allow to connect.
>>
>>
>> On Mon, Mar 31, 2003 at 06:30:32PM +0200, Peter Mikeska wrote:
>> > Hi,
>> > I have problem and not sure if it has something to do with rt.
>> > I have runnig rt3, when browsing pages on rt it opens still more and
>> > more connections to mysql, all threads in mysql get to sleep and after
>> > reaching max_connections its blocking any other request. I lie this
>> > by  setting wait_timeout=600 and max connection=300 but I feel its not
>> > right solution. Does any1 have clue what problam can be? It looks to
>> > me like not proper handling of making connections to mysql (when its
>> > full i get error mesage in apache log .. in RT.pm line 124)
>
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
>




More information about the Rt-devel mailing list