Skip to content

Instantly share code, notes, and snippets.

@sue445
Last active July 24, 2022 01:16
Show Gist options
  • Save sue445/05e139f07a6de340e8acac7e337c01ec to your computer and use it in GitHub Desktop.
Save sue445/05e139f07a6de340e8acac7e337c01ec to your computer and use it in GitHub Desktop.
ISUCON12で使ったDatadogダッシュボード
{
"title": "ISUCON",
"description": "https://app.datadoghq.com/dash/integration/30268/ruby-runtime-metrics?tpl_var_service=isucon\nhttps://app.datadoghq.com/dashboard/dzb-2ps-nyf?tpl_var_service=isucon\n\n* [Continuos Profiler](https://app.datadoghq.com/profiling/aggregation?query=service%3Aisucon)\n* [Database Monitoring](https://app.datadoghq.com/databases/queries?query=service%3Aisucon%20-query_signature%3A%2829e4c5d3e6caa593%20OR%20f8ae1cfee57d2d0b%20OR%20946d3a847b4979d5%20OR%203d26034e89167423%20OR%20dfa53796cd30e3e7%29&dbType=MySQL)\n",
"widgets": [
{
"id": 3153889567518422,
"definition": {
"title": "sinatra",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 8587763768710926,
"definition": {
"title": "isucon-sinatra",
"type": "trace_service",
"env": "production",
"service": "isucon-sinatra",
"span_name": "sinatra.request",
"show_hits": false,
"show_errors": false,
"show_latency": true,
"show_breakdown": true,
"show_distribution": false,
"show_resource_list": true,
"size_format": "medium",
"display_format": "one_column"
},
"layout": {
"x": 0,
"y": 0,
"width": 7,
"height": 11
}
}
]
},
"layout": {
"x": 0,
"y": 0,
"width": 7,
"height": 12
}
},
{
"id": 8295443589177700,
"definition": {
"title": "sidekiq",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 3400562376538248,
"definition": {
"title": "isucon-sidekiq",
"type": "trace_service",
"env": "production",
"service": "isucon-sidekiq",
"span_name": "sidekiq.job",
"show_hits": false,
"show_errors": false,
"show_latency": true,
"show_breakdown": true,
"show_distribution": false,
"show_resource_list": true,
"size_format": "medium",
"display_format": "one_column"
},
"layout": {
"x": 0,
"y": 0,
"width": 5,
"height": 9
}
},
{
"id": 4976235014768894,
"definition": {
"title": "Job summary",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"alias": "enqueued",
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:sidekiq.enqueued{$service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"alias": "busy",
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:sidekiq.busy{$service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "orange",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"alias": "retries",
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:sidekiq.retries{$service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"alias": "dead",
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:sidekiq.dead{$service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 9,
"width": 5,
"height": 2
}
}
]
},
"layout": {
"x": 7,
"y": 0,
"width": 5,
"height": 12
}
},
{
"id": 2543348934408390,
"definition": {
"title": "System",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 674310835723544,
"definition": {
"title": "CPU usage (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"alias": "CPU usage",
"formula": "query2 + query3 + query4 + query5"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:system.cpu.system{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query2"
},
{
"query": "avg:system.cpu.iowait{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query3"
},
{
"query": "avg:system.cpu.user{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query4"
},
{
"query": "avg:system.cpu.stolen{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query5"
},
{
"query": "avg:system.cpu.idle{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 0,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 7235137532240766,
"definition": {
"title": "Memory breakdown (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "(query2 - query3) / query4 * 100"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:system.mem.used{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query2"
},
{
"query": "avg:system.mem.cached{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query3"
},
{
"query": "avg:system.mem.total{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query4"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 4,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 4870109846536158,
"definition": {
"title": "Memory breakdown",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query4"
},
{
"alias": "used - cached",
"formula": "query2 - query3"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:system.mem.used{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query2"
},
{
"query": "avg:system.mem.cached{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query3"
},
{
"query": "avg:system.mem.total{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query4"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 8,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 3968080783919988,
"definition": {
"title": "Disk usage by device (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1 * 100"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "max:system.disk.in_use{$service,$host} by {device,host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"label": "full",
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 0,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 1887416596769210,
"definition": {
"title": "Network traffic (bytes/sec)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.net.bytes_rcvd{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "0 - query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.net.bytes_sent{$service,$host} by {host}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 5178053558086406,
"definition": {
"title": "Available Swap",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
},
{
"formula": "query2"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:system.swap.free{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query1"
},
{
"query": "avg:system.swap.used{$service,$host} by {host}",
"data_source": "metrics",
"name": "query2"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 3819700460613142,
"definition": {
"title": "Disk latency (by device)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "max:system.io.await{$service,$host} by {device,host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 4,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 12,
"width": 12,
"height": 7
}
},
{
"id": 7573256236705474,
"definition": {
"title": "サーバ毎の主要プロセス",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 1473778271763258,
"definition": {
"type": "note",
"content": "[isucon-01](https://app.datadoghq.com/dash/host/6418944654)\n",
"background_color": "white",
"font_size": "36",
"text_align": "center",
"vertical_align": "center",
"show_tick": false,
"tick_pos": "50%",
"tick_edge": "left",
"has_padding": true
},
"layout": {
"x": 0,
"y": 0,
"width": 4,
"height": 1
}
},
{
"id": 7561549554066608,
"definition": {
"type": "note",
"content": "[isucon-02](https://app.datadoghq.com/dash/host/6957643003)\n",
"background_color": "white",
"font_size": "36",
"text_align": "center",
"vertical_align": "center",
"show_tick": false,
"tick_pos": "50%",
"tick_edge": "left",
"has_padding": true
},
"layout": {
"x": 4,
"y": 0,
"width": 4,
"height": 1
}
},
{
"id": 7982525785338340,
"definition": {
"type": "note",
"content": "[isucon-03](https://app.datadoghq.com/dash/host/6957660719)\n",
"background_color": "white",
"font_size": "36",
"text_align": "center",
"vertical_align": "center",
"show_tick": false,
"tick_pos": "50%",
"tick_edge": "left",
"has_padding": true
},
"layout": {
"x": 8,
"y": 0,
"width": 4,
"height": 1
}
},
{
"id": 6774156820222834,
"definition": {
"title": "[isucon-01] CPU (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1 / query2"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.processes.cpu.pct{host:isucon-01} by {process_name}",
"data_source": "metrics",
"name": "query1"
},
{
"query": "avg:system.cpu.num_cores{host:isucon-01}",
"data_source": "metrics",
"name": "query2"
}
],
"style": {
"palette": "warm",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 0,
"y": 1,
"width": 4,
"height": 2
}
},
{
"id": 4700737277192206,
"definition": {
"title": "[isucon-02] CPU (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1 / query2"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.processes.cpu.pct{host:isucon-02} by {process_name}",
"data_source": "metrics",
"name": "query1"
},
{
"query": "avg:system.cpu.num_cores{host:isucon-02}",
"data_source": "metrics",
"name": "query2"
}
],
"style": {
"palette": "warm",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 4,
"y": 1,
"width": 4,
"height": 2
}
},
{
"id": 456044797347454,
"definition": {
"title": "[isucon-03] CPU (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1 / query2"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.processes.cpu.pct{host:isucon-03} by {process_name}",
"data_source": "metrics",
"name": "query1"
},
{
"query": "avg:system.cpu.num_cores{host:isucon-03}",
"data_source": "metrics",
"name": "query2"
}
],
"style": {
"palette": "warm",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 8,
"y": 1,
"width": 4,
"height": 2
}
},
{
"id": 8656987085426124,
"definition": {
"title": "[isucon-01] memory (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.processes.mem.pct{host:isucon-01} by {process_name}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 0,
"y": 3,
"width": 4,
"height": 2
}
},
{
"id": 3576704368032430,
"definition": {
"title": "[isucon-02] memory (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.processes.mem.pct{host:isucon-02} by {process_name}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 4,
"y": 3,
"width": 4,
"height": 2
}
},
{
"id": 5393825012634470,
"definition": {
"title": "[isucon-03] memory (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.processes.mem.pct{host:isucon-03} by {process_name}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"min": "0"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 8,
"y": 3,
"width": 4,
"height": 2
}
},
{
"id": 2954774058449244,
"definition": {
"title": "[isucon-01] Processes memory usage",
"type": "treemap",
"requests": [
{
"q": "processes{host:isucon-01}"
}
],
"size_by": "pct_mem",
"color_by": "user",
"group_by": "family"
},
"layout": {
"x": 0,
"y": 5,
"width": 4,
"height": 2
}
},
{
"id": 2371263527101478,
"definition": {
"title": "[isucon-02] Processes memory usage",
"type": "treemap",
"requests": [
{
"q": "processes{host:isucon-02}"
}
],
"size_by": "pct_mem",
"color_by": "user",
"group_by": "family"
},
"layout": {
"x": 4,
"y": 5,
"width": 4,
"height": 2
}
},
{
"id": 3095625145803226,
"definition": {
"title": "[isucon-03] Processes memory usage",
"type": "treemap",
"requests": [
{
"q": "processes{host:isucon-03}"
}
],
"size_by": "pct_mem",
"color_by": "user",
"group_by": "family"
},
"layout": {
"x": 8,
"y": 5,
"width": 4,
"height": 2
}
},
{
"id": 4796770162883732,
"definition": {
"title": "[isucon-01] Processes CPU usage",
"type": "treemap",
"requests": [
{
"q": "processes{host:isucon-01}"
}
],
"size_by": "pct_cpu",
"color_by": "user",
"group_by": "family"
},
"layout": {
"x": 0,
"y": 7,
"width": 4,
"height": 2
}
},
{
"id": 6940680315095528,
"definition": {
"title": "[isucon-02] Processes CPU usage",
"type": "treemap",
"requests": [
{
"q": "processes{host:isucon-02}"
}
],
"size_by": "pct_cpu",
"color_by": "user",
"group_by": "family"
},
"layout": {
"x": 4,
"y": 7,
"width": 4,
"height": 2
}
},
{
"id": 8505668502783716,
"definition": {
"title": "[isucon-03] Processes CPU usage",
"type": "treemap",
"requests": [
{
"q": "processes{host:isucon-03}"
}
],
"size_by": "pct_cpu",
"color_by": "user",
"group_by": "family"
},
"layout": {
"x": 8,
"y": 7,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 19,
"width": 12,
"height": 10
}
},
{
"id": 4297374929473028,
"definition": {
"title": "nginx (alp like)",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 6983338060618896,
"definition": {
"title": "nginx alp table",
"title_size": "16",
"title_align": "left",
"type": "query_table",
"requests": [
{
"formulas": [
{
"alias": "COUNT",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query1"
},
{
"alias": "MAX",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query3"
},
{
"alias": "AVG",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query2"
},
{
"alias": "P95",
"conditional_formats": [],
"limit": {
"count": 500,
"order": "desc"
},
"cell_display_mode": "bar",
"formula": "query4"
},
{
"alias": "MEDIAN",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query5"
},
{
"alias": "MAX(BODY)",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query6"
},
{
"alias": "AVG(BODY)",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query7"
},
{
"alias": "P95(BODY)",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query8"
},
{
"alias": "MEDIAN(BODY)",
"conditional_formats": [],
"cell_display_mode": "bar",
"formula": "query9"
}
],
"response_format": "scalar",
"queries": [
{
"query": "avg:custom.nginx.request_count{$service,$host} by {method,uri_formatted}.as_count()",
"data_source": "metrics",
"name": "query1",
"aggregator": "sum"
},
{
"query": "avg:custom.nginx.reqtime.max{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query3",
"aggregator": "avg"
},
{
"query": "avg:custom.nginx.reqtime.avg{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query2",
"aggregator": "avg"
},
{
"query": "avg:custom.nginx.reqtime.95percentile{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query4",
"aggregator": "avg"
},
{
"query": "avg:custom.nginx.reqtime.median{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query5",
"aggregator": "avg"
},
{
"query": "avg:custom.nginx.size.max{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query6",
"aggregator": "avg"
},
{
"query": "avg:custom.nginx.size.avg{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query7",
"aggregator": "avg"
},
{
"query": "avg:custom.nginx.size.95percentile{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query8",
"aggregator": "avg"
},
{
"query": "avg:custom.nginx.size.median{$service,$host} by {method,uri_formatted}",
"data_source": "metrics",
"name": "query9",
"aggregator": "avg"
}
]
}
],
"has_search_bar": "auto"
},
"layout": {
"x": 0,
"y": 0,
"width": 12,
"height": 4
}
},
{
"id": 516521043355146,
"definition": {
"title": "nginx request count (rps)",
"title_size": "16",
"title_align": "left",
"show_legend": false,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "per_second(query1)"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:custom.nginx.request_count{$service,$host} by {uri_formatted,method,status_class}.as_count()",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 4,
"width": 4,
"height": 2
}
},
{
"id": 3840401488576252,
"definition": {
"title": "nginx request time (sec)",
"title_size": "16",
"title_align": "left",
"show_legend": false,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:custom.nginx.reqtime.95percentile{$service,$host} by {uri_formatted,method,status_class}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 4,
"width": 4,
"height": 2
}
},
{
"id": 10684458763940,
"definition": {
"title": "nginx app time (sec)",
"title_size": "16",
"title_align": "left",
"show_legend": false,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:custom.nginx.apptime.95percentile{$service,$host} by {uri_formatted,method,status_class}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 4,
"width": 4,
"height": 2
}
},
{
"id": 2734927755024284,
"definition": {
"title": "nginx run time (sec)",
"title_size": "16",
"title_align": "left",
"show_legend": false,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:custom.nginx.runtime.95percentile{$service,$host} by {uri_formatted,method,status_class}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 6,
"width": 4,
"height": 2
}
},
{
"id": 7787432864606708,
"definition": {
"title": "nginx response body size (bytes/sec)",
"title_size": "16",
"title_align": "left",
"show_legend": false,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "per_second(query1)"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:custom.nginx.size.95percentile{$service,$host} by {uri_formatted,method,status_class}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 6,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 29,
"width": 12,
"height": 9
}
},
{
"id": 5840129286833320,
"definition": {
"title": "nginx",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 5744584624937712,
"definition": {
"type": "note",
"content": "https://app.datadoghq.com/dash/integration/21/nginx---overview\nhttps://app.datadoghq.com/dash/integration/20/nginx---metrics\n* [nginx logs](https://app.datadoghq.com/logs?saved_view=713961)"
},
"layout": {
"x": 0,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 2526514674424326,
"definition": {
"title": "Requests per second",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:nginx.net.request_per_s{$service,$host} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 39907113895698,
"definition": {
"title": "Active connections per second",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:nginx.net.connections{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 6239413868453180,
"definition": {
"title": "Connections: reading,writing,waiting",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:nginx.net.reading{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"response_format": "timeseries",
"queries": [
{
"query": "sum:nginx.net.writing{$host,$service}",
"data_source": "metrics",
"name": "query1"
}
]
},
{
"response_format": "timeseries",
"queries": [
{
"query": "sum:nginx.net.waiting{$host,$service}",
"data_source": "metrics",
"name": "query1"
}
]
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 2,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 38,
"width": 12,
"height": 5
}
},
{
"id": 7916426989050056,
"definition": {
"title": "puma",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 6406455274224304,
"definition": {
"title": "puma workers",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query2"
},
{
"formula": "query3"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.workers{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query2"
},
{
"query": "avg:puma.booted_workers{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query3"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 5976776947428940,
"definition": {
"title": "puma threads (per hosts)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.max_threads{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "dotted",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.running{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.backlog{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.pool_capacity{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 8110065513938326,
"definition": {
"title": "puma threads (total)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:puma.max_threads{$host,$service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "red",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.running{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.backlog{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "blue",
"line_type": "solid",
"line_width": "thin"
},
"display_type": "area"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:puma.pool_capacity{$host,$service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "warm",
"line_type": "dotted",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 7964807079514468,
"definition": {
"title": "puma memory (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1 + query2"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:system.processes.mem.pct{$host,$service,process_name:puma_worker} by {host,service}",
"data_source": "metrics",
"name": "query1"
},
{
"query": "sum:system.processes.mem.pct{$host,$service,process_name:puma_master} by {host,service}",
"data_source": "metrics",
"name": "query2"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 0,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 6544941628057372,
"definition": {
"title": "puma requests (rps)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "per_second(query1)"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.requests_count{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 5120577368114898,
"definition": {
"title": "puma threads (running vs max)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.max_threads{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "red",
"line_type": "dotted",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:puma.running{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 2,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 43,
"width": 12,
"height": 5
}
},
{
"id": 5385731108460346,
"definition": {
"title": "MySQL",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 555046060619886,
"definition": {
"type": "note",
"content": "https://app.datadoghq.com/dash/integration/12/mysql\nhttps://app.datadoghq.com/dash/integration/30404/mysql\n\n* [Slow Logs](https://app.datadoghq.com/logs?saved_view=703381)"
},
"layout": {
"x": 0,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 8275885294944272,
"definition": {
"title": "MySQL reads and writes (per sec)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:mysql.innodb.data_reads{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:mysql.innodb.data_writes{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 82269419328152,
"definition": {
"title": "MySQL fsync op count (per sec)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:mysql.innodb.os_log_fsyncs{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 5805335255573790,
"definition": {
"title": "MySQL connections",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:mysql.net.connections{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:mysql.net.max_connections{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
},
{
"formulas": [
{
"formula": "query0"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:mysql.net.max_connections_available{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query0"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 698180545285792,
"definition": {
"title": "MySQL connections (%)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1 / query2 * 100"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:mysql.net.connections{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
},
{
"query": "avg:mysql.net.max_connections_available{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query2"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 4,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 5609327792910170,
"definition": {
"title": "MySQL locking rate (per sec)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "rate(query1)"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:mysql.performance.table_locks_waited{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 7026236894840928,
"definition": {
"title": "MySQL locking rate (per sec)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "rate(query1)"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:mysql.performance.table_locks_waited{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 4,
"width": 4,
"height": 2
}
},
{
"id": 6197782804368886,
"definition": {
"title": "MySQL slow queries",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:mysql.performance.slow_queries{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 4,
"width": 4,
"height": 2
}
},
{
"id": 3226148203391980,
"definition": {
"title": "MySQL CPU time (per sec)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:mysql.performance.user_time{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": [
{
"value": "y = 100",
"display_type": "error dashed"
}
]
},
"layout": {
"x": 8,
"y": 4,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 48,
"width": 12,
"height": 7
}
},
{
"id": 2728143548425474,
"definition": {
"title": "redis",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 3619830646296770,
"definition": {
"type": "note",
"content": "https://app.datadoghq.com/dash/integration/15/redis---overview?tpl_var_scope=service%3Aisucon",
"background_color": "white",
"font_size": "14",
"text_align": "left",
"vertical_align": "top",
"show_tick": false,
"tick_pos": "50%",
"tick_edge": "left",
"has_padding": true
},
"layout": {
"x": 0,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 4516802912023972,
"definition": {
"title": "Keys",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:redis.keys{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 6238018435875534,
"definition": {
"title": "Redis key length by name",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:redis.key.length{$host,$service} by {host,service,key}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 7401357801597698,
"definition": {
"title": "Redis key length by name (rps)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "per_second(query1)"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "sum:redis.key.length{$host,$service} by {host,service,key}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 8287469662004666,
"definition": {
"title": "Cache hit rate",
"show_legend": false,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"alias": "hit %",
"formula": "(query1 / (query1 + query2)) * 100"
}
],
"response_format": "timeseries",
"on_right_yaxis": false,
"queries": [
{
"query": "avg:redis.stats.keyspace_hits{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
},
{
"query": "avg:redis.stats.keyspace_misses{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query2"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": [
{
"label": "Ideal hit rate",
"value": "y = 100",
"display_type": "ok dashed"
},
{
"label": "Investigate",
"value": "y = 75",
"display_type": "warning dashed"
}
]
},
"layout": {
"x": 4,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 7352465710323930,
"definition": {
"title": "Slowlog",
"show_legend": true,
"legend_layout": "horizontal",
"legend_columns": [
"avg",
"min",
"max",
"value"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "top(query1 / 1000, 10, 'mean', 'desc')"
}
],
"response_format": "timeseries",
"on_right_yaxis": false,
"queries": [
{
"query": "sum:redis.slowlog.micros.95percentile{$host,$service} by {name,command}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "orange",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 7635300316098962,
"definition": {
"title": "Connected clients",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"max",
"avg",
"min"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"alias": "Connected clients",
"formula": "query1"
}
],
"response_format": "timeseries",
"on_right_yaxis": false,
"queries": [
{
"query": "sum:redis.net.clients{$host,$service} by {host,service}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "cool"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 0,
"y": 4,
"width": 4,
"height": 2
}
},
{
"id": 1898487274981928,
"definition": {
"title": "Commands per second",
"show_legend": false,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"alias": "Processed commands",
"formula": "query1"
}
],
"response_format": "timeseries",
"on_right_yaxis": false,
"queries": [
{
"query": "sum:redis.net.commands{$host,$service} by {service,host}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "orange"
},
"display_type": "line"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 4,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 55,
"width": 12,
"height": 7
}
},
{
"id": 7013733749803484,
"definition": {
"title": "fluentd",
"type": "group",
"background_color": "vivid_green",
"show_title": true,
"layout_type": "ordered",
"widgets": [
{
"id": 1174786884590816,
"definition": {
"type": "note",
"content": "https://app.datadoghq.com/dash/integration/72/fluentd---metrics?tpl_var_scope=service%3Aisucon",
"background_color": "white",
"font_size": "14",
"text_align": "left",
"vertical_align": "top",
"show_tick": false,
"tick_pos": "50%",
"tick_edge": "left",
"has_padding": true
},
"layout": {
"x": 0,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 7712147744133776,
"definition": {
"title": "fluentd.flowcounter.count",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:fluentd.flowcounter.count{$host,$service} by {host,service}.as_count()",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "bars"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 4,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 1588559900405252,
"definition": {
"title": "fluentd.flowcounter.bytes",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:fluentd.flowcounter.bytes{$host,$service} by {host,service}.as_count()",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "bars"
}
],
"yaxis": {
"include_zero": true,
"scale": "linear",
"label": "",
"min": "auto",
"max": "auto"
},
"markers": []
},
"layout": {
"x": 8,
"y": 0,
"width": 4,
"height": 2
}
},
{
"id": 5177789662198726,
"definition": {
"title": "Fluentd - Retry count",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:fluentd.retry_count{$service} by {host}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
]
},
"layout": {
"x": 0,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 6368128432170018,
"definition": {
"title": "Fluentd - Buffer queue length (chunks)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:fluentd.buffer_queue_length{$service} by {host}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "line"
}
]
},
"layout": {
"x": 4,
"y": 2,
"width": 4,
"height": 2
}
},
{
"id": 7700615557747014,
"definition": {
"title": "Fluentd - Buffer total size (bytes)",
"show_legend": true,
"legend_layout": "auto",
"legend_columns": [
"avg",
"min",
"max",
"value",
"sum"
],
"type": "timeseries",
"requests": [
{
"formulas": [
{
"formula": "query1"
}
],
"response_format": "timeseries",
"queries": [
{
"query": "avg:fluentd.buffer_total_queued_size{$service} by {host}",
"data_source": "metrics",
"name": "query1"
}
],
"style": {
"palette": "dog_classic",
"line_type": "solid",
"line_width": "normal"
},
"display_type": "area"
}
]
},
"layout": {
"x": 8,
"y": 2,
"width": 4,
"height": 2
}
}
]
},
"layout": {
"x": 0,
"y": 62,
"width": 12,
"height": 5
}
}
],
"template_variables": [
{
"name": "service",
"default": "isucon",
"prefix": "service",
"available_values": []
},
{
"name": "host",
"default": "*",
"prefix": "host",
"available_values": []
}
],
"layout_type": "ordered",
"is_read_only": false,
"notify_list": [],
"reflow_type": "fixed",
"id": "kzc-x7x-5yt"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment