Hi again Nick,

I used a great program, called Sinatica (http://www.sinatica.com/). This
program show lots of stuff in realtime, and also some pseudo-trace stuff
(not complete like the real trace feature in FB 2.5).

It became obvious that when the sweep process started, the disk access
became saturated, as well as CPU usage. This problem seems to happen in the
2 archs (super and classic).

In small databases was not so impactful, but in the large ones, it really
became a problem. Disabling auto sweep and running it at the dawn was not
exactly what i call "problem solved", because my program receives
information from lots of probes in real time, but at least there is no user
working with the system.

Hope i could help you. Sorry for my poor english =)

On Tue, Jan 15, 2013 at 2:04 PM, Nick Upson <nu@...> wrote:

> Hi Leonardo,
>
> thats the symptom I'm seeing, intermittently a process will almost stop and
> will stay that way for several hours
>
> how did you prove that was the cause?
>
>
> On 15 January 2013 15:59, Leonardo Carneiro <chesterman86@...>
> wrote:
>
> > **
> >
> >
> > Hi Nick. I've found that my applications ALMOST hang when sweep is
> running
> > in big databases (100GB+).
> >
> > I say almost because once in a while the application give a sign of life.
> > To "solve" the problem, i disabled the autosweep and run in a scheduled
> > task every dawn.
> >
> > Best regards.
> >
> >
> > On Tue, Jan 15, 2013 at 12:29 PM, Nick Upson nu@...> wrote:
> >
> > > Hi,
> > >
> > > (firebird 2.1.5 on centos) 50Gb database
> > >
> > > Is there any reason why a process, upon noticing the transaction gap
> is >
> > > 20000 & hence a sweep is required, should 'hang' (for hours), as if
> > waiting
> > > for the sweep to complete.
> > >
> > > Is there any way I can tell (logging or process monitoring perhaps)
> when
> > an
> > > automatic sweep is initiated, running or completed?
> > >
> > > --
> > > Nick Upson, Telensa Ltd
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Visit http://www.firebirdsql.org and click the Resources item
> > > on the main (top) menu. Try Knowledgebase and FAQ links !
> > >
> > > Also search the knowledgebases at http://www.ibphoenix.com
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
>
> --
> Nick Upson, Telensa Ltd
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]