On 8 June 2017 at 13:53, <[email protected]> wrote:
> Author: mchassagneux
> Date: Thu Jun 8 12:53:52 2017
> New Revision: 1798053
>
> URL: http://svn.apache.org/viewvc?rev=1798053&view=rev
> Log:
> Add a Grafana Template
> Bugzilla Id: 61167
>
> Added:
> jmeter/trunk/extras/GrafanaJMeterTemplate.json (with props)
>
> Added: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> URL:
> http://svn.apache.org/viewvc/jmeter/trunk/extras/GrafanaJMeterTemplate.json?rev=1798053&view=auto
> ==============================================================================
> --- jmeter/trunk/extras/GrafanaJMeterTemplate.json (added)
> +++ jmeter/trunk/extras/GrafanaJMeterTemplate.json Thu Jun 8 12:53:52 2017
> @@ -0,0 +1,1459 @@
> +{
The characters before the '{' don't look right.
Maybe a spurious UTF BOM?
> + "id": 97,
> + "title": "JMeter Metric Template",
> + "tags": [],
> + "style": "dark",
> + "timezone": "browser",
> + "editable": true,
> + "sharedCrosshair": true,
> + "hideControls": false,
> + "time": {
> + "from": "2017-06-08T01:09:30.935Z",
> + "to": "2017-06-08T02:55:58.972Z"
> + },
> + "timepicker": {
> + "now": true,
> + "refresh_intervals": [
> + "10s",
> + "30s",
> + "1m",
> + "5m",
> + "15m",
> + "30m",
> + "1h",
> + "2h",
> + "1d"
> + ],
> + "time_options": [
> + "5m",
> + "15m",
> + "1h",
> + "6h",
> + "12h",
> + "24h",
> + "2d",
> + "7d",
> + "30d"
> + ]
> + },
> + "templating": {
> + "list": [
> + {
> + "allValue": ".*",
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": false,
> + "label": null,
> + "multi": true,
> + "name": "app",
> + "options": [],
> + "query": "SHOW TAG VALUES FROM \"process\" WITH KEY =
> \"application\"",
> + "refresh": 2,
> + "regex": "",
> + "sort": 1,
> + "tagValuesQuery": "",
> + "tagsQuery": "SHOW TAG VALUES FROM \"events\" WITH KEY = \"tags\"",
> + "type": "query"
> + },
> + {
> + "allFormat": "regex wildcard",
> + "auto": false,
> + "auto_count": 10,
> + "auto_min": "10s",
> + "current": {
> + "text": "1m",
> + "value": "1m"
> + },
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": true,
> + "label": "",
> + "multi": false,
> + "multiFormat": "glob",
> + "name": "granularity",
> + "options": [
> + {
> + "text": "1m",
> + "value": "1m",
> + "selected": true
> + },
> + {
> + "text": "5m",
> + "value": "5m",
> + "selected": false
> + },
> + {
> + "text": "1h",
> + "value": "1h",
> + "selected": false
> + },
> + {
> + "text": "5s",
> + "value": "5s",
> + "selected": false
> + },
> + {
> + "text": "15s",
> + "value": "15s",
> + "selected": false
> + },
> + {
> + "text": "30s",
> + "value": "30s",
> + "selected": false
> + }
> + ],
> + "query": "1m,5m,1h,5s,15s,30s",
> + "refresh": 2,
> + "regex": "",
> + "type": "interval"
> + },
> + {
> + "allValue": null,
> + "current": {
> + "text": "default",
> + "value": "default",
> + "tags": []
> + },
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": false,
> + "label": null,
> + "multi": false,
> + "name": "retention",
> + "options": [],
> + "query": "SHOW RETENTION POLICIES ON \"jmeterdb\"",
> + "refresh": 1,
> + "regex": "",
> + "sort": 0,
> + "tagValuesQuery": null,
> + "tagsQuery": null,
> + "type": "query"
> + },
> + {
> + "allValue": ".*",
> + "current": {
> + "value": [
> + "$__all"
> + ],
> + "text": "All"
> + },
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": true,
> + "label": null,
> + "multi": true,
> + "name": "transaction",
> + "options": [],
> + "query": "SHOW TAG VALUES FROM \"jmeter\" WITH KEY IN
> (\"transaction\",\"application\") where application =~ /$app/ and transaction
> !~ /all/",
> + "refresh": 2,
> + "regex": "",
> + "sort": 0,
> + "tagValuesQuery": null,
> + "tagsQuery": null,
> + "type": "query"
> + }
> + ]
> + },
> + "annotations": {
> + "list": [
> + {
> + "datasource": "jmeterdb",
> + "enable": true,
> + "iconColor": "rgb(237, 18, 18)",
> + "iconSize": 17,
> + "lineColor": "rgb(0, 21, 255)",
> + "name": "Annotation",
> + "query": "select text,tags,title from \"$retention\".\"events\"
> where application =~ /$app/ AND $timeFilter",
> + "showLine": true,
> + "textColumn": "text",
> + "titleColumn": "title",
> + "tagsColumn": "tags"
> + }
> + ]
> + },
> + "refresh": false,
> + "schemaVersion": 13,
> + "version": 0,
> + "links": [
> + {
> + "asDropdown": true,
> + "icon": "dashboard",
> + "includeVars": true,
> + "keepTime": true,
> + "tags": [],
> + "targetBlank": true,
> + "tooltip": "",
> + "type": "dashboards",
> + "url": ""
> + }
> + ],
> + "gnetId": null,
> + "rows": [
> + {
> + "title": "Jmeter Metrics",
> + "panels": [
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": false,
> + "colors": [
> + "rgba(245, 54, 54, 0.9)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(50, 172, 45, 0.97)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "none",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 19,
> + "interval": "$granularity",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": " users",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT last(\"startedT\") FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity)
> fill(null)",
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "meanAT"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "last"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + }
> + ]
> + }
> + ],
> + "thresholds": "",
> + "title": "Active Users",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "current"
> + },
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": false,
> + "colors": [
> + "rgba(245, 54, 54, 0.9)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(50, 172, 45, 0.97)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "none",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 17,
> + "interval": "",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": " TPS",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "default",
> + "query": "SELECT sum(\"hit\") / 30 FROM
> \"$retention\".\"jmeter\" WHERE \"application\" = '$app' AND \"transaction\"
> = 'all' AND $timeFilter GROUP BY time(30s)",
> + "rawQuery": true,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "hit"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "last"
> + },
> + {
> + "params": [
> + " / 5"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": "",
> + "title": "Currents hits per Second",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "current"
> + },
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": true,
> + "colors": [
> + "rgba(50, 172, 45, 0.97)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(245, 54, 54, 0.9)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "percentunit",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 21,
> + "interval": "$granularity",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": "",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT sum(\"countError\") / sum(\"count\") FROM
> \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND
> \"transaction\" = 'all' AND $timeFilter",
> + "rawQuery": true,
> + "refId": "B",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "countError"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / sum(\"count\")"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": "0.1,0.2",
> + "title": "% Errors",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "total"
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "id": 27,
> + "interval": "$granularity",
> + "legend": {
> + "avg": false,
> + "current": false,
> + "max": false,
> + "min": false,
> + "show": false,
> + "total": false,
> + "values": false
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "nullPointMode": "null as zero",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 4,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "Hits",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT last(\"hit\") / 5 FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity)
> fill(null)",
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "hit"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "last"
> + },
> + {
> + "params": [
> + " / 5"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Hits per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": true,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": false,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": 0,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": false,
> + "colors": [
> + "rgba(245, 54, 54, 0.9)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(50, 172, 45, 0.97)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "none",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 22,
> + "interval": "$granularity",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": "",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT \"hit\" FROM \"jmeter\" WHERE \"application\"
> =~ /$app$/ AND \"statut\" = 'all' AND $timeFilter",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "hit"
> + ],
> + "type": "field"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": "",
> + "title": "Total Hits",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "total"
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "id": 28,
> + "interval": "$granularity",
> + "legend": {
> + "avg": false,
> + "current": false,
> + "max": false,
> + "min": false,
> + "show": false,
> + "total": false,
> + "values": false
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 4,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "Errors",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "0"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT mean(\"countError\") / 5 FROM \"jmeter\"
> WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity)
> fill(0)",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "countError"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "mean"
> + },
> + {
> + "params": [
> + " / 5"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Errors per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": true,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": false,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": 0,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + }
> + ],
> + "showTitle": true,
> + "titleSize": "h6",
> + "height": "150px",
> + "repeat": null,
> + "repeatRowId": null,
> + "repeatIteration": null,
> + "collapse": false
> + },
> + {
> + "title": "Application Metrics",
> + "panels": [
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 25,
> + "interval": "$granularity",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": false,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + }
> + ],
> + "hide": false,
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT mean(\"avg\") FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity),
> \"transaction\"",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "avg"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "mean"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Average Response Time",
> + "tooltip": {
> + "msResolution": false,
> + "shared": false,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "ms",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 26,
> + "interval": "$granularity",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": false,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "sort": "current",
> + "sortDesc": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "30s"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT mean(\"count\") / 5 FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND \"transaction\" <> 'all' AND $timeFilter GROUP
> BY time($granularity), \"transaction\"",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "count"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / 30"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "<>",
> + "value": "all"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Transaction Per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": false,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "ops",
> + "label": "",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 29,
> + "interval": "$granularity",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": false,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "30s"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT last(\"count\") / 30 FROM
> \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" =
> 'ko' AND $timeFilter GROUP BY time(30s), \"transaction\" fill(null)",
> + "rawQuery": false,
> + "refId": "B",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "count"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / 30"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "ko"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Error Per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": false,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "ops",
> + "label": "",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 34,
> + "interval": "",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": true,
> + "hideZero": true,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 1,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction - $tag_responseCode :
> $tag_responseMessage",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "30s"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "responseMessage"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "responseCode"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT sum(\"count\") / 5 FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND \"statut\" = 'ko' AND $timeFilter GROUP BY
> time($granularity), \"responseCode\" fill(null)",
> + "rawQuery": false,
> + "refId": "B",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "count"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / 30"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "responseCode",
> + "operator": "!~",
> + "value": "/^0$|^$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "=~",
> + "value": "/$transaction/"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Error detail",
> + "tooltip": {
> + "msResolution": false,
> + "shared": true,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "none",
> + "label": "",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + }
> + ],
> + "showTitle": true,
> + "titleSize": "h6",
> + "height": "700px",
> + "repeat": null,
> + "repeatRowId": null,
> + "repeatIteration": null,
> + "collapse": false
> + }
> + ]
> +}
> \ No newline at end of file
>
> Propchange: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> ------------------------------------------------------------------------------
> svn:eol-style = native
>
>
