From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <jplsek@iol.unh.edu>
Received: from mail-oi1-f179.google.com (mail-oi1-f179.google.com
 [209.85.167.179]) by dpdk.org (Postfix) with ESMTP id 6BF811DB9
 for <ci@dpdk.org>; Tue, 20 Nov 2018 17:05:27 +0100 (CET)
Received: by mail-oi1-f179.google.com with SMTP id x23so1920905oix.3
 for <ci@dpdk.org>; Tue, 20 Nov 2018 08:05:27 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iol.unh.edu; s=unh-iol;
 h=mime-version:from:date:message-id:subject:to;
 bh=P5xfDmTh+y8gOQMWaotnpfzvmbQfhsPn3TmM6jnTi3E=;
 b=czv4Mk88DnfYoFp8SkG0N7epMNuboYdmJro95s2RZ7gm9O2rPEohs9R4fAS+/IY75M
 Cp9mvDc1UdrOC0dRXkdTYoR1o1yiuX6dXI4yMUy0ljaDRIOszWCRw993HcQExjz+34lN
 CD6vgMCe1lRY7RFlIkyk9tgzg7SuqJpKheCoI=
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20161025;
 h=x-gm-message-state:mime-version:from:date:message-id:subject:to;
 bh=P5xfDmTh+y8gOQMWaotnpfzvmbQfhsPn3TmM6jnTi3E=;
 b=f77Mw7XtKmf5hcP1/+J22klAfKuovJBEazWciohisltLuBi4bHdgqj3emCrmfe4FBr
 1uE61la1xb1MN2A17D4Hg4/o1P/X4HbcnWYF+eMmrk8Tfg5iRticuoEvuKfTjXeeyvAu
 iAN3WotTT28x2+SRwnOqQVhYC2mfwg/T8k+dj+pDC+fXwa7NBAtdGJ+FXUt6j2xIz5VD
 N6PBs0PDof9TLl8SZMug/YyZpQU/rLiwL9H/cHs7TBjOf6LQhYWzYPbZU0JAoH8qT6oj
 Z3XcC6+VRT17eOCmOPDUOjDGbTMRBybyy71jCnxkc6ZYCmNyhS5wvYAKVSUwhXQ+CFRq
 EP6Q==
X-Gm-Message-State: AGRZ1gKN6VKfxD8SQLmSCHbyWDnj5Ox+IEn+QbfxhVbPOYMMcL5Jxrhz
 MTAok48qsPMzEbnlclOFE3HL32+Y1Qj7cy0DBimYdylrJjM=
X-Google-Smtp-Source: AJdET5cMnxE43F5TwgxsuNwIyJP5Mpsv0ty/nIxGyDLPdVqoVaw07LjlNJHn28nyvGPuUDVWLArLtcACF5pJhIQ7FCo=
X-Received: by 2002:aca:5205:: with SMTP id g5mr1462247oib.149.1542729926429; 
 Tue, 20 Nov 2018 08:05:26 -0800 (PST)
MIME-Version: 1.0
From: Jeremy Plsek <jplsek@iol.unh.edu>
Date: Tue, 20 Nov 2018 11:04:50 -0500
Message-ID: <CA+xUZB6HXk_8qK9U-un3BcFyu_z9jxgSB9-vh=HtjaYod3vEHw@mail.gmail.com>
To: ci@dpdk.org
Content-Type: text/plain; charset="UTF-8"
Subject: [dpdk-ci] Dashboard Graphs
X-BeenThere: ci@dpdk.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: DPDK CI discussions <ci.dpdk.org>
List-Unsubscribe: <https://mails.dpdk.org/options/ci>,
 <mailto:ci-request@dpdk.org?subject=unsubscribe>
List-Archive: <http://mails.dpdk.org/archives/ci/>
List-Post: <mailto:ci@dpdk.org>
List-Help: <mailto:ci-request@dpdk.org?subject=help>
List-Subscribe: <https://mails.dpdk.org/listinfo/ci>,
 <mailto:ci-request@dpdk.org?subject=subscribe>
X-List-Received-Date: Tue, 20 Nov 2018 16:05:28 -0000

Hi all,

Based on the discussion in the meeting today, these are the following
changes we will be making to the graphs:

- Remove right hand side cumulative graphs
- Add units (Mpps delta)
- Add explanation to the graphs (The plot contains the delta points over time)
- Make the titles more readable
- Make sure that members can sign into Grafana and make their own graphs

Most of these items should be done today.

The query for the graphs were also asked for, which is:

select
  UNIX_TIMESTAMP(timestamp) as time_sec,
  difference as value,
  'difference' as value
from results_testrun
  inner join results_tarball on results_testrun.tarball_id = results_tarball.id
  inner join results_testresult on results_testresult.run_id =
results_testrun.id
where
  results_tarball.job_name='Get-Latest-Git-Master'
  and results_testrun.environment_id='7'
  and timestamp is not null;

(The database being used is a duplicate database that only contains
public results, which gets synced once a day.)

Thanks
-- 
Jeremy Plsek
UNH InterOperability Laboratory