Re: [Sqlrelay-discussion] Busy listeners counter patch

[Cal H. <ca...@fb...>]

Oh ok, I picked just the status_more_info patch and applied that, I had
compilation errors with trying to access a private member in rudiments.

I'm also working up a patch of my own, to do dynamically allocated cursors.
I tried to compile the CVS version of relay, but realized it needed a new
function in the CVS version of rudiments, which wouldn't compile.  I gave up
on that venture.

A few dusty corners of my web application consume a lot of statement
handles, so as a result I needed to crank up my cursors to 1320 in the
config file.  Each server side connection consumed around 50 - 100MB of
memory.  Multiply that by around 200 concurrent connections on a machine
with 16GB of memory results in bad behavior.

By dropping the initial cursors array to 10, each connection only consumes
around 14MB of memory.  I have an initial test running now, using malloc()
and realloc() to resize the sqlrcursor_svr array and it seems to be
operating correctly.

Before I go any futher though, has anyone already implemented this?  Or do
you guys foresee any problems with what I'm trying to do?

Thanks,

--Cal


On Tue, May 18, 2010 at 2:19 PM, Renat Sabitov <sr...@st...> wrote:

>  18.05.2010 19:24, Cal Heldenbrand пишет:
>
> Are your patches against the 0.41 release, or the CVS code?  I'd like to
> give a few of these a try.
>
>  They are against the 0.41, but some of them depends on others so you
> can't just apply the latest to the original 0.41 code.
>
> I have posted all patches to this list, but it might be better to get them
> from this location:
>
> http://www.srr.pp.ru/www/sqlrelay/
>
> Be aware that 05_exit_on_broken_socket.patch requires patch to rudiments (
> poll.FULL.patch.gz<http://www.srr.pp.ru/www/sqlrelay/rudiments-0.32/poll.FULL.patch.gz>
> )
>
>
>
>
> ------------------------------------------------------------------------------
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>