{
  "tags": [],
  "title": "MySQL Overview",
  "widgets": [
    {
      "layout": {
        "x": 0,
        "y": 0,
        "width": 12,
        "height": 1
      },
      "definition": {
        "type": "group",
        "title": " ",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 3,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "MySQL Uptime",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_global_status_uptime{$host}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar",
                  "conditional_formats": [
                    {
                      "value": 300,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    },
                    {
                      "value": 3600,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    }
                  ]
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "s"
            }
          },
          {
            "layout": {
              "x": 3,
              "y": 0,
              "width": 3,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Current QPS",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.queries{$host}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar",
                  "conditional_formats": [
                    {
                      "value": 35,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    },
                    {
                      "value": 75,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    }
                  ]
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 3,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "InnoDB Buffer Pool Size",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.innodb.buffer_pool_size{$host}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar",
                  "conditional_formats": [
                    {
                      "value": 90,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    },
                    {
                      "value": 95,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    }
                  ]
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "B"
            }
          },
          {
            "layout": {
              "x": 9,
              "y": 0,
              "width": 3,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Buffer Pool Size of Total RAM",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.innodb.buffer_pool_size{$host}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:system.mem.total{$host}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "(query1 * 100) / (query2 * 1048576)"
                    }
                  ],
                  "response_format": "scalar",
                  "conditional_formats": [
                    {
                      "value": 40,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    },
                    {
                      "value": 80,
                      "palette": "white_on_gray",
                      "comparator": ">="
                    }
                  ]
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "%"
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 1,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Connections",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Connections",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "max:mysql.performance.threads_connected{$host}.rollup(max, 300)",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.net.max_connections{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql.net.max_connections_available{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Connections",
                      "formula": "query1"
                    },
                    {
                      "alias": "Max Used Connections",
                      "formula": "query2"
                    },
                    {
                      "alias": "Max Connections",
                      "formula": "query3"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Client Thread Activity",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.threads_connected{$host}.rollup(max, 300)",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.threads_running{$host}.rollup(max, 300)",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql.performance.threads_running{$host}.rollup(avg, 300)",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Peak Threads Connected",
                      "formula": "query1"
                    },
                    {
                      "alias": "Peak Threads Running",
                      "formula": "query2"
                    },
                    {
                      "alias": "Avg Threads Running",
                      "formula": "query3"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 3,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Table Locks",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Questions",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.questions{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Questions",
                      "formula": "query1"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Thread Cache",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.thread_cache_size{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.threads_cached{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql.performance.threads_created{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Thread Cache Size",
                      "formula": "query1"
                    },
                    {
                      "alias": "Threads Cached",
                      "formula": "query2"
                    },
                    {
                      "alias": "Threads Created",
                      "formula": "query3"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 5,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Temporary Objects",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Temporary Objects",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.created_tmp_tables{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.created_tmp_disk_tables{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql.performance.created_tmp_files{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Created Tmp Tables",
                      "formula": "query1"
                    },
                    {
                      "alias": "Created Tmp Disk Tables",
                      "formula": "query2"
                    },
                    {
                      "alias": "Created Tmp Files",
                      "formula": "query3"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Select Types",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.select_full_join{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.select_full_range_join{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql.performance.select_range{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:mysql.performance.select_range_check{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query5",
                      "query": "avg:mysql.performance.select_scan{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Select Full Join",
                      "formula": "query1"
                    },
                    {
                      "alias": "Select Full Range Join",
                      "formula": "query2"
                    },
                    {
                      "alias": "Select Range",
                      "formula": "query3"
                    },
                    {
                      "alias": "Select Range Check",
                      "formula": "query4"
                    },
                    {
                      "alias": "Select Scan",
                      "formula": "query5"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 7,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Sorts",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Sorts",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.sort_rows{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.sort_range{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql.performance.sort_merge_passes{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:mysql.performance.sort_scan{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Sort Rows",
                      "formula": "query1"
                    },
                    {
                      "alias": "Sort Range",
                      "formula": "query2"
                    },
                    {
                      "alias": "Sort Merge Passes",
                      "formula": "query3"
                    },
                    {
                      "alias": "Sort Scan",
                      "formula": "query4"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Slow Queries",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.slow_queries{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Slow Queries",
                      "formula": "query1"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 9,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Aborted",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Aborted Connections",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.net.aborted_connects{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.net.aborted_clients{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Aborted Connects (attempts)",
                      "formula": "query1"
                    },
                    {
                      "alias": "Aborted Clients (timeout)",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Table Locks",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.table_locks_immediate{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.table_locks_waited{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Table Locks Immediate",
                      "formula": "query1"
                    },
                    {
                      "alias": "Table Locks Waited",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 11,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Network",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Network Traffic",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.bytes_received{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.bytes_sent{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Inbound",
                      "formula": "query1"
                    },
                    {
                      "alias": "Outbound",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Network Usage Hourly",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.bytes_received{$host}.rollup(avg, 3600)",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.bytes_sent{$host}.rollup(avg, 3600)",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Received",
                      "formula": "query1 * 3600"
                    },
                    {
                      "alias": "Sent",
                      "formula": "query2 * 3600"
                    }
                  ],
                  "display_type": "bars",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 13,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Memory",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Internal Memory Overview",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:system.mem.total{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.innodb.buffer_pool_data{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql_global_variables_innodb_log_buffer_size{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:mysql_global_variables_innodb_additional_mem_pool_size{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query5",
                      "query": "avg:mysql_global_status_innodb_mem_dictionary{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query6",
                      "query": "avg:mysql.performance.key_buffer_size{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query7",
                      "query": "avg:mysql.performance.query_cache_size{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query8",
                      "query": "avg:mysql.innodb.mem_adaptive_hash{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query9",
                      "query": "avg:mysql_global_variables_tokudb_cache_size{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "System Memory",
                      "formula": "query1 * 1048576"
                    },
                    {
                      "alias": "InnoDB Buffer Pool Data",
                      "formula": "query2"
                    },
                    {
                      "alias": "InnoDB Log Buffer Size",
                      "formula": "query3"
                    },
                    {
                      "alias": "InnoDB Additional Memory Pool Size",
                      "formula": "query4"
                    },
                    {
                      "alias": "InnoDB Dictionary Size",
                      "formula": "query5"
                    },
                    {
                      "alias": "Key Buffer Size",
                      "formula": "query6"
                    },
                    {
                      "alias": "Query Cache Size",
                      "formula": "query7"
                    },
                    {
                      "alias": "Adaptive Hash Index Size",
                      "formula": "query8"
                    },
                    {
                      "alias": "TokuDB Cache Size",
                      "formula": "query9"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 15,
        "width": 12,
        "height": 12
      },
      "definition": {
        "type": "group",
        "title": "Command, Handlers, Processes",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Top Command Counters",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_global_status_commands.count{$host} by {command}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "top(query1, 5, 'mean', 'desc')"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 2,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Top Command Counters Hourly",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_global_status_commands.count{$host} by {command}.as_count()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "top(query1, 5, 'mean', 'desc')"
                    }
                  ],
                  "display_type": "bars",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 4,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Handlers",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_global_status_handlers.count{$host AND handler NOT IN (commit,rollback,prepare)} by {handler}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 6,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Transaction Handlers",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_global_status_handlers.count{$host AND handler IN (commit,rollback,prepare)} by {handler}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 8,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Process States",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": false
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_info_schema_threads{$host} by {state}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "display_type": "line",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 10,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Top Process States Hourly",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_info_schema_threads{$host} by {state}.rollup(avg, 3600)",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "top(query1, 5, 'mean', 'desc')"
                    }
                  ],
                  "display_type": "bars",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 27,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Query Cache",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Query Cache Memory",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.qcache_free_memory{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.query_cache_size{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Free Memory",
                      "formula": "query1"
                    },
                    {
                      "alias": "Query Cache Size",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Query Cache Activity",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.qcache_hits{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql.performance.qcache_inserts{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql.performance.qcache_not_cached{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:mysql.performance.qcache_lowmem_prunes{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query5",
                      "query": "avg:mysql.performance.qcache_queries_in_cache{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Hits",
                      "formula": "query1"
                    },
                    {
                      "alias": "Inserts",
                      "formula": "query2"
                    },
                    {
                      "alias": "Not Cached",
                      "formula": "query3"
                    },
                    {
                      "alias": "Prunes",
                      "formula": "query4"
                    },
                    {
                      "alias": "Queries in Cache",
                      "formula": "query5"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 29,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Files and Tables",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL File Openings",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_global_status_opened_files{$host}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Openings",
                      "formula": "query1"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Open Files",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.open_files{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql_global_variables_open_files_limit{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql_global_status_innodb_num_open_files{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Open Files",
                      "formula": "query1"
                    },
                    {
                      "alias": "Open Files Limit",
                      "formula": "query2"
                    },
                    {
                      "alias": "InnoDB Open Files",
                      "formula": "query3"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 31,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "Table Openings",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Table Open Cache Status",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.opened_tables{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql_global_status_table_open_cache_hits{$host}.as_rate()",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql_global_status_table_open_cache_misses{$host}.as_rate()",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:mysql_global_status_table_open_cache_overflows{$host}.as_rate()",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query5",
                      "query": "avg:mysql_global_status_table_open_cache_hits{$host}.as_rate()",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query6",
                      "query": "avg:mysql_global_status_table_open_cache_misses{$host}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Openings",
                      "formula": "query1"
                    },
                    {
                      "alias": "Hits",
                      "formula": "query2"
                    },
                    {
                      "alias": "Misses",
                      "formula": "query3"
                    },
                    {
                      "alias": "Misses due to Overflows",
                      "formula": "query4"
                    },
                    {
                      "alias": "Table Open Cache Hit Ratio",
                      "formula": "query5 / (query5 + query6)"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 6,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Open Tables",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql.performance.open_tables{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql_global_variables_table_open_cache{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Open Tables",
                      "formula": "query1"
                    },
                    {
                      "alias": "Table Open Cache",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 33,
        "width": 12,
        "height": 2
      },
      "definition": {
        "type": "group",
        "title": "MySQL Table Definition Cache",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 12,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "MySQL Table Definition Cache",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:mysql_global_status_open_table_definitions{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:mysql_global_variables_table_definition_cache{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:mysql_global_status_opened_table_definitions{$host}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Open Table Definitions",
                      "formula": "query1"
                    },
                    {
                      "alias": "Table Definitions Cache Size",
                      "formula": "query2"
                    },
                    {
                      "alias": "Opened Table Definitions",
                      "formula": "query3"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 35,
        "width": 12,
        "height": 4
      },
      "definition": {
        "type": "group",
        "title": "System Charts",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "I/O Activity",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:node_vmstat_pgpgin{$host}.as_rate()",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:node_vmstat_pgpgout{$host}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Page In",
                      "formula": "query1 * 1024"
                    },
                    {
                      "alias": "Page Out",
                      "formula": "query2 * 1024"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 0,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Memory Distribution",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:system.mem.total{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:system.mem.free{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:system.mem.buffered{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:system.mem.cached{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query5",
                      "query": "avg:system.mem.free{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query6",
                      "query": "avg:system.mem.buffered{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query7",
                      "query": "avg:system.mem.cached{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Used",
                      "formula": "(query1 - (query2 + query3 + query4)) * 1048576"
                    },
                    {
                      "alias": "Free",
                      "formula": "query5 * 1048576"
                    },
                    {
                      "alias": "Buffers",
                      "formula": "query6 * 1048576"
                    },
                    {
                      "alias": "Cached",
                      "formula": "query7 * 1048576"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 0,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "CPU Usage / Load",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:system.cpu.user{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:system.cpu.system{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:system.cpu.iowait{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:system.cpu.stolen{$host}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query5",
                      "query": "avg:system.load.1{$host}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "clamp_max(query1 + query2 + query3 + query4, 100)"
                    },
                    {
                      "alias": "Load 1m",
                      "formula": "query5"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 2,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Disk Latency",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "sum:system.io.r_await{$host,!device:dm-*}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "sum:system.io.w_await{$host,!device:dm-*}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Read",
                      "formula": "query1"
                    },
                    {
                      "alias": "Write",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 2,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Network Traffic",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "sum:system.net.bytes_rcvd{$host,!device:lo}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "sum:system.net.bytes_sent{$host,!device:lo}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Inbound",
                      "formula": "query1"
                    },
                    {
                      "alias": "Outbound",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 2,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Swap Activity",
              "yaxis": {
                "max": "auto",
                "min": "auto",
                "label": "",
                "scale": "linear",
                "include_zero": true
              },
              "requests": [
                {
                  "style": {
                    "palette": "dog_classic",
                    "line_type": "solid",
                    "line_width": "normal"
                  },
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:node_vmstat_pswpin{$host}.as_rate()",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:node_vmstat_pswpout{$host}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Swap In (Reads)",
                      "formula": "query1 * 4096"
                    },
                    {
                      "alias": "Swap Out (Writes)",
                      "formula": "query2 * 4096"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    }
  ],
  "description": "Converted from Grafana dashboard https://grafana.com/grafana/dashboards/7362 (by nasskach). Dashboard from Percona Monitoring and Management project. ",
  "layout_type": "ordered",
  "reflow_type": "fixed",
  "template_variables": [
    {
      "name": "host",
      "prefix": "host",
      "default": "*",
      "available_values": []
    }
  ]
}