SQL statements monitoring and statistics.

[Alexey Kuznetsov <ak...@gridgain.com>]

I'm going to implement support for SQL statements monitoring and statistics
in Web Console.

For this feature we need API that will allow to collect info about what
statements were executed in cluster and their metrics.

@Sergi Vladykin, as you one of the most experts for SQL subsystem, could
you tell me,
where and how to implement such API?

Thanks!

-- 
Alexey Kuznetsov
GridGain Systems
www.gridgain.com

Re: SQL statements monitoring and statistics.

[Sergey Kozlov <sk...@gridgain.com>]

What's about to use more general approach and collect statistics into
special read-only caches ?

It gives more advantages like using data from such caches for other (user)
queries, track statistics without coding, behavior is closer to RDBMS, no
new API.

p.s. For  instance take a look on
http://www.postgresql.org/docs/current/static/pgstatstatements.html

On Wed, Apr 27, 2016 at 9:37 PM, Dmitriy Setrakyan <ds...@apache.org>
wrote:

> Ideally, it would be good to provide average time for every SQL statement.
> Do we track it anywhere?
>
> On Wed, Apr 27, 2016 at 7:01 AM, Sergi Vladykin <se...@gmail.com>
> wrote:
>
> > I'm not sure I understand, what kind of statistics do you need. Probably
> we
> > could fire events for slow queries (I don't think it is a good idea to
> > generate an even for any query due to performance reasons) and then
> you'll
> > be able to add any listeners you want.
> >
> > Sergi
> >
> > 2016-04-27 3:39 GMT+03:00 Alexey Kuznetsov <ak...@gridgain.com>:
> >
> > > I'm going to implement support for SQL statements monitoring and
> > statistics
> > > in Web Console.
> > >
> > > For this feature we need API that will allow to collect info about what
> > > statements were executed in cluster and their metrics.
> > >
> > > @Sergi Vladykin, as you one of the most experts for SQL subsystem,
> could
> > > you tell me,
> > > where and how to implement such API?
> > >
> > > Thanks!
> > >
> > > --
> > > Alexey Kuznetsov
> > > GridGain Systems
> > > www.gridgain.com
> > >
> >
>



-- 
Sergey Kozlov
GridGain Systems
www.gridgain.com

Re: SQL statements monitoring and statistics.

[Dmitriy Setrakyan <ds...@apache.org>]

Ideally, it would be good to provide average time for every SQL statement.
Do we track it anywhere?

On Wed, Apr 27, 2016 at 7:01 AM, Sergi Vladykin <se...@gmail.com>
wrote:

> I'm not sure I understand, what kind of statistics do you need. Probably we
> could fire events for slow queries (I don't think it is a good idea to
> generate an even for any query due to performance reasons) and then you'll
> be able to add any listeners you want.
>
> Sergi
>
> 2016-04-27 3:39 GMT+03:00 Alexey Kuznetsov <ak...@gridgain.com>:
>
> > I'm going to implement support for SQL statements monitoring and
> statistics
> > in Web Console.
> >
> > For this feature we need API that will allow to collect info about what
> > statements were executed in cluster and their metrics.
> >
> > @Sergi Vladykin, as you one of the most experts for SQL subsystem, could
> > you tell me,
> > where and how to implement such API?
> >
> > Thanks!
> >
> > --
> > Alexey Kuznetsov
> > GridGain Systems
> > www.gridgain.com
> >
>

Re: SQL statements monitoring and statistics.

[Sergi Vladykin <se...@gmail.com>]

I'm not sure I understand, what kind of statistics do you need. Probably we
could fire events for slow queries (I don't think it is a good idea to
generate an even for any query due to performance reasons) and then you'll
be able to add any listeners you want.

Sergi

2016-04-27 3:39 GMT+03:00 Alexey Kuznetsov <ak...@gridgain.com>:

> I'm going to implement support for SQL statements monitoring and statistics
> in Web Console.
>
> For this feature we need API that will allow to collect info about what
> statements were executed in cluster and their metrics.
>
> @Sergi Vladykin, as you one of the most experts for SQL subsystem, could
> you tell me,
> where and how to implement such API?
>
> Thanks!
>
> --
> Alexey Kuznetsov
> GridGain Systems
> www.gridgain.com
>