ISUCON12で使ったDatadogダッシュボード
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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, | |