From dev-return-41651-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Mon Nov 12 11:25:51 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id F2E0A180660 for ; Mon, 12 Nov 2018 11:25:50 +0100 (CET) Received: (qmail 60671 invoked by uid 500); 12 Nov 2018 10:25:50 -0000 Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list dev@ignite.apache.org Received: (qmail 60659 invoked by uid 99); 12 Nov 2018 10:25:49 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Nov 2018 10:25:49 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id E6CB3183E76 for ; Mon, 12 Nov 2018 10:25:48 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.445 X-Spam-Level: X-Spam-Status: No, score=0.445 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-1.458, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FROM_EXCESS_BASE64=0.105, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id JtWSRAaPhrVJ for ; Mon, 12 Nov 2018 10:25:47 +0000 (UTC) Received: from mail-vk1-f179.google.com (mail-vk1-f179.google.com [209.85.221.179]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 21B7D5FAF4 for ; Mon, 12 Nov 2018 10:25:47 +0000 (UTC) Received: by mail-vk1-f179.google.com with SMTP id t127so1835153vke.8 for ; Mon, 12 Nov 2018 02:25:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=oF+YW1N579R+72pX9D9HgWopwHAoz8ORpMLv7ARZ6qc=; b=IFmbGuNGLuIAWtUJsK9lZWEj0CzE5TUdokf8kxOKYN0j0Y5KTXawbM9ssCos2+iMN7 KGg4+KZwP2/Qh/Dg3lAsndMYKwOlcPl4e3fuWabfkMkA3xZbhYCyiWiehK0nYaFESnyD RjZ636iZvCvRdr2Bmg0qSGH8NQwgT40JbzCXN+ckYlD0aMQvzQSi67pyJcvXX8lpKdtG eo2x9RbXPIZJ4Wzjo5jw+JeZLpP2QltpPBchrS4wT/aA0fSACNP/kqkGoDdjono8lIPd aEPJdsuhoKPb1Gx1ZCshaCm0K6i3YBWtxQc9XVC/p9BRtJEcrExxViZHFCPQhlzizzb0 jo2w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=oF+YW1N579R+72pX9D9HgWopwHAoz8ORpMLv7ARZ6qc=; b=aASovGkHvD4gLMbN5JJ2XJpOoHXcd5+XhiQ1XN3AMuzUMaFw1GBoQ3vcwmDNbbYCvh UJsudSLjff9JMScvphn73DwDpVfTZRdgeMXJCugEMtRto71st7sc1/H2Yh0EIxsLYtii JHjseIWy/ycbhUnTKQu1Jb7xqzK4NLQNhEgzz2X5NALvOKZAuPQlXJDEmIflQIypUSMK GoYo8ld9ZKCeTKW9Y8eq2CsaE7aDChdiegkEKMqKIdJH15kEbuZT0Q7/bbZMtNSj1Q0K cLZS4UuYqKDCuxcA60K3Qs7zQ5ojaqnNn9B7zStkr3oOOAB2uV+JGYMCPLf2G1B4u/qM h7rw== X-Gm-Message-State: AGRZ1gJNa6WAcFiLN8Uls+T6X+gY9+yO5FpGFCh+mcu7YAGgBjVFgqBE bQcffPWkp6ICi3GyfvMgOof3uj8L5+bKN27+Phlt38LkxmU= X-Google-Smtp-Source: AJdET5drxy+tzp44g4F3KW3dCfG/M84lOhiQb4GA4h3dz1Dq8yAnIByIoDfclE4UFv53R8rQhWTFy5bxzGPUGE9lj7s= X-Received: by 2002:a1f:91cb:: with SMTP id t194mr148212vkd.74.1542018339509; Mon, 12 Nov 2018 02:25:39 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?B?0K7RgNC40Lk=?= Date: Mon, 12 Nov 2018 13:25:28 +0300 Message-ID: Subject: Re: SQL management and monitoring improvements To: dev@ignite.apache.org Content-Type: multipart/alternative; boundary="0000000000005d1a09057a751f51" --0000000000005d1a09057a751f51 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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? =D0=BF=D1=82, 9 =D0=BD=D0=BE=D1=8F=D0=B1. 2018 =D0=B3. =D0=B2 0:37, Alex Pl= ehanov : > 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? > > > =D1=87=D1=82, 8 =D0=BD=D0=BE=D1=8F=D0=B1. 2018 =D0=B3. =D0=B2 0:06, Denis= Magda : > > > 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 feasibl= e > > and just not covered. > > > > -- > > Denis > > > > > > > > On Wed, Nov 7, 2018 at 2:01 AM =D0=AE=D1=80=D0=B8=D0=B9 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+manageme= nt+and+monitoring > > > > > > > . > > > > > > What do you think about it? May be do you have some additional > > suggestions? > > > > > > > > > -- > > > =D0=96=D0=B8=D0=B2=D0=B8 =D1=81 =D1=83=D0=BB=D1=8B=D0=B1=D0=BA=D0=BE= =D0=B9! :D > > > > > > --=20 =D0=96=D0=B8=D0=B2=D0=B8 =D1=81 =D1=83=D0=BB=D1=8B=D0=B1=D0=BA=D0=BE=D0=B9!= :D --0000000000005d1a09057a751f51--