You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by Юрий <ju...@gmail.com> on 2018/11/07 10:01:14 UTC
SQL management and monitoring improvements
Hi Igniters!
I think we can improve Ignite management and monitoring instruments related
to SQL.
I've prepared draft of IEP-29: SQL management and monitoring
<https://cwiki.apache.org/confluence/display/IGNITE/IEP-29%3A+SQL+management+and+monitoring>
.
What do you think about it? May be do you have some additional suggestions?
--
Живи с улыбкой! :D
Re: SQL management and monitoring improvements
Posted by Vladimir Ozerov <vo...@gridgain.com>.
Yuri,
Do you have any ideas in mind?
On Mon, Nov 12, 2018 at 1:25 PM Юрий <ju...@gmail.com> wrote:
> Hi Alex,
>
> Thanks for the ideas! It will be useful.
> However, from my side, Oracle like syntax looks excess. Will be good if
> someone else say opinion opinion about syntax.
>
> Igniters, what do you think which syntax of Ignite management via SQL will
> be prefer?
>
>
> пт, 9 нояб. 2018 г. в 0:37, Alex Plehanov <pl...@gmail.com>:
>
> > Yuri,
> >
> > I think it will be useful if we extend in future management via SQL tool
> to
> > cover not only queries but also other parts of Ignite (for example: for
> > canceling tasks, for killing transactions, activation/deactivation,
> > baseline topology change, etc.).
> >
> > Maybe, in this case, we should use a common prefix for such management
> > commands (like Oracle do: "ALTER SYSTEM ...")?
> >
> > Something like:
> > ALTER GRID KILL QUERY ... [ON NODE ...]
> > ALTER GRID KILL TRANSACTION ... [ON NODE ...]
> > ALTER GRID ACTIVATE
> > etc.
> >
> > What do you think about it?
> >
> >
> > чт, 8 нояб. 2018 г. в 0:06, Denis Magda <dm...@apache.org>:
> >
> > > Yuri,
> > >
> > > That's an excellent idea, thank you for driving it.
> > >
> > > What is not explained is how to leverage from all that stat. For
> > instance,
> > > how can I know a total number of SELECTs, or a total number of SELECTs
> > > happened yesterday for specific data sets. Do believe that it's
> feasible
> > > and just not covered.
> > >
> > > --
> > > Denis
> > >
> > >
> > >
> > > On Wed, Nov 7, 2018 at 2:01 AM Юрий <ju...@gmail.com>
> wrote:
> > >
> > > > Hi Igniters!
> > > >
> > > > I think we can improve Ignite management and monitoring instruments
> > > related
> > > > to SQL.
> > > > I've prepared draft of IEP-29: SQL management and monitoring
> > > > <
> > > >
> > >
> >
> https://cwiki.apache.org/confluence/display/IGNITE/IEP-29%3A+SQL+management+and+monitoring
> > > > >
> > > > .
> > > >
> > > > What do you think about it? May be do you have some additional
> > > suggestions?
> > > >
> > > >
> > > > --
> > > > Живи с улыбкой! :D
> > > >
> > >
> >
>
>
> --
> Живи с улыбкой! :D
>
Re: SQL management and monitoring improvements
Posted by Юрий <ju...@gmail.com>.
Hi Alex,
Thanks for the ideas! It will be useful.
However, from my side, Oracle like syntax looks excess. Will be good if
someone else say opinion opinion about syntax.
Igniters, what do you think which syntax of Ignite management via SQL will
be prefer?
пт, 9 нояб. 2018 г. в 0:37, Alex Plehanov <pl...@gmail.com>:
> Yuri,
>
> I think it will be useful if we extend in future management via SQL tool to
> cover not only queries but also other parts of Ignite (for example: for
> canceling tasks, for killing transactions, activation/deactivation,
> baseline topology change, etc.).
>
> Maybe, in this case, we should use a common prefix for such management
> commands (like Oracle do: "ALTER SYSTEM ...")?
>
> Something like:
> ALTER GRID KILL QUERY ... [ON NODE ...]
> ALTER GRID KILL TRANSACTION ... [ON NODE ...]
> ALTER GRID ACTIVATE
> etc.
>
> What do you think about it?
>
>
> чт, 8 нояб. 2018 г. в 0:06, Denis Magda <dm...@apache.org>:
>
> > Yuri,
> >
> > That's an excellent idea, thank you for driving it.
> >
> > What is not explained is how to leverage from all that stat. For
> instance,
> > how can I know a total number of SELECTs, or a total number of SELECTs
> > happened yesterday for specific data sets. Do believe that it's feasible
> > and just not covered.
> >
> > --
> > Denis
> >
> >
> >
> > On Wed, Nov 7, 2018 at 2:01 AM Юрий <ju...@gmail.com> wrote:
> >
> > > Hi Igniters!
> > >
> > > I think we can improve Ignite management and monitoring instruments
> > related
> > > to SQL.
> > > I've prepared draft of IEP-29: SQL management and monitoring
> > > <
> > >
> >
> https://cwiki.apache.org/confluence/display/IGNITE/IEP-29%3A+SQL+management+and+monitoring
> > > >
> > > .
> > >
> > > What do you think about it? May be do you have some additional
> > suggestions?
> > >
> > >
> > > --
> > > Живи с улыбкой! :D
> > >
> >
>
--
Живи с улыбкой! :D
Re: SQL management and monitoring improvements
Posted by Alex Plehanov <pl...@gmail.com>.
Yuri,
I think it will be useful if we extend in future management via SQL tool to
cover not only queries but also other parts of Ignite (for example: for
canceling tasks, for killing transactions, activation/deactivation,
baseline topology change, etc.).
Maybe, in this case, we should use a common prefix for such management
commands (like Oracle do: "ALTER SYSTEM ...")?
Something like:
ALTER GRID KILL QUERY ... [ON NODE ...]
ALTER GRID KILL TRANSACTION ... [ON NODE ...]
ALTER GRID ACTIVATE
etc.
What do you think about it?
чт, 8 нояб. 2018 г. в 0:06, Denis Magda <dm...@apache.org>:
> Yuri,
>
> That's an excellent idea, thank you for driving it.
>
> What is not explained is how to leverage from all that stat. For instance,
> how can I know a total number of SELECTs, or a total number of SELECTs
> happened yesterday for specific data sets. Do believe that it's feasible
> and just not covered.
>
> --
> Denis
>
>
>
> On Wed, Nov 7, 2018 at 2:01 AM Юрий <ju...@gmail.com> wrote:
>
> > Hi Igniters!
> >
> > I think we can improve Ignite management and monitoring instruments
> related
> > to SQL.
> > I've prepared draft of IEP-29: SQL management and monitoring
> > <
> >
> https://cwiki.apache.org/confluence/display/IGNITE/IEP-29%3A+SQL+management+and+monitoring
> > >
> > .
> >
> > What do you think about it? May be do you have some additional
> suggestions?
> >
> >
> > --
> > Живи с улыбкой! :D
> >
>
Re: SQL management and monitoring improvements
Posted by Юрий <ju...@gmail.com>.
Denis,
I mentioned about it, may be it's not so clear now. I'll try add more
explanation about it into IEP. It should be some SQL systems views and JMX
interfaces.
Deeper details will be covered in a tasks during more detailed analyze.
Thanks for your feedback.
чт, 8 нояб. 2018 г. в 0:06, Denis Magda <dm...@apache.org>:
> Yuri,
>
> That's an excellent idea, thank you for driving it.
>
> What is not explained is how to leverage from all that stat. For instance,
> how can I know a total number of SELECTs, or a total number of SELECTs
> happened yesterday for specific data sets. Do believe that it's feasible
> and just not covered.
>
> --
> Denis
>
>
>
> On Wed, Nov 7, 2018 at 2:01 AM Юрий <ju...@gmail.com> wrote:
>
> > Hi Igniters!
> >
> > I think we can improve Ignite management and monitoring instruments
> related
> > to SQL.
> > I've prepared draft of IEP-29: SQL management and monitoring
> > <
> >
> https://cwiki.apache.org/confluence/display/IGNITE/IEP-29%3A+SQL+management+and+monitoring
> > >
> > .
> >
> > What do you think about it? May be do you have some additional
> suggestions?
> >
> >
> > --
> > Живи с улыбкой! :D
> >
>
--
Живи с улыбкой! :D
Re: SQL management and monitoring improvements
Posted by Denis Magda <dm...@apache.org>.
Yuri,
That's an excellent idea, thank you for driving it.
What is not explained is how to leverage from all that stat. For instance,
how can I know a total number of SELECTs, or a total number of SELECTs
happened yesterday for specific data sets. Do believe that it's feasible
and just not covered.
--
Denis
On Wed, Nov 7, 2018 at 2:01 AM Юрий <ju...@gmail.com> wrote:
> Hi Igniters!
>
> I think we can improve Ignite management and monitoring instruments related
> to SQL.
> I've prepared draft of IEP-29: SQL management and monitoring
> <
> https://cwiki.apache.org/confluence/display/IGNITE/IEP-29%3A+SQL+management+and+monitoring
> >
> .
>
> What do you think about it? May be do you have some additional suggestions?
>
>
> --
> Живи с улыбкой! :D
>