| 1 | taxonomy_version: 1 |
| 2 | plugin_name: go.d.plugin |
| 3 | module_name: mysql |
| 4 | placements: |
| 5 | - id: mysql |
| 6 | section_id: applications.mysql |
| 7 | title: MySQL |
| 8 | icon: mysql |
| 9 | items: |
| 10 | - type: grid |
| 11 | id: mysql-heads |
| 12 | title: mysql-heads |
| 13 | items: |
| 14 | - type: context |
| 15 | title: No. of Slow Queries |
| 16 | contexts: [mysql.queries] |
| 17 | chart_library: number |
| 18 | group_by: [selected] |
| 19 | selected_dimensions: [slow_queries] |
| 20 | colors: ["#3366CC", "#66AA00"] |
| 21 | layout: { left: 0, top: 0, width: 3, height: 4 } |
| 22 | - type: context |
| 23 | title: Total No. of Deadlocks |
| 24 | contexts: [mysql.innodb_deadlocks] |
| 25 | chart_library: number |
| 26 | group_by: [selected] |
| 27 | colors: ["#DC3912", "#FE3912"] |
| 28 | layout: { left: 3, top: 0, width: 3, height: 4 } |
| 29 | - type: context |
| 30 | title: Galera Cluster Status |
| 31 | contexts: [mysql.galera_cluster_status] |
| 32 | chart_library: bars |
| 33 | dimensions_sort: valueDesc |
| 34 | colors: ["#109618", "#3366CC"] |
| 35 | layout: { left: 6, top: 0, width: 3, height: 4 } |
| 36 | - type: context |
| 37 | title: Total Open Transactions |
| 38 | contexts: [mysql.galera_open_transactions] |
| 39 | chart_library: easypiechart |
| 40 | group_by: [selected] |
| 41 | colors: ["#FF9900", "#D66300"] |
| 42 | layout: { left: 9, top: 0, width: 3, height: 4 } |
| 43 | - type: context |
| 44 | title: MySQL Join Operation Issues |
| 45 | contexts: [mysql.join_issues] |
| 46 | chart_library: bars |
| 47 | dimensions_sort: valueDesc |
| 48 | layout: { left: 0, top: 4, width: 3, height: 4 } |
| 49 | - type: context |
| 50 | title: Number of MySQL threads |
| 51 | contexts: [mysql.threads_created] |
| 52 | chart_library: number |
| 53 | group_by: [selected] |
| 54 | colors: ["#990099", "#0099C6"] |
| 55 | layout: { left: 3, top: 4, width: 3, height: 4 } |
| 56 | - type: context |
| 57 | title: InnoDB Buffer Pool Read Ahead |
| 58 | contexts: [mysql.innodb_buffer_pool_read_ahead] |
| 59 | chart_library: bars |
| 60 | dimensions_sort: valueDesc |
| 61 | colors: ["#3B3EAC", "#5054e6"] |
| 62 | layout: { left: 6, top: 4, width: 3, height: 4 } |
| 63 | - type: context |
| 64 | title: Longest Query Duration |
| 65 | contexts: [mysql.process_list_longest_query_duration] |
| 66 | chart_library: number |
| 67 | group_by: [selected] |
| 68 | aggregation_method: max |
| 69 | colors: ["#66AA00", "#EE9911"] |
| 70 | layout: { left: 9, top: 4, width: 3, height: 4 } |
| 71 | - type: context |
| 72 | id: mysql-servers |
| 73 | title: List MySQL Servers |
| 74 | contexts: |
| 75 | - mysql.connections_active |
| 76 | - mysql.queries_type |
| 77 | - mysql.net |
| 78 | chart_library: table |
| 79 | group_by: [dimension, label, node, context] |
| 80 | group_by_label: [_collect_job] |
| 81 | table_columns: [context, dimension] |
| 82 | labels: |
| 83 | mysql.connections_active: Connections |
| 84 | mysql.queries_type: Queries |
| 85 | mysql.net: Network |
| 86 | - type: group |
| 87 | id: queries |
| 88 | title: Queries |
| 89 | properties: { grouping: true } |
| 90 | items: |
| 91 | - type: group |
| 92 | id: statistics |
| 93 | title: Statistics |
| 94 | items: |
| 95 | - mysql.queries |
| 96 | - mysql.queries_type |
| 97 | - mysql.process_list_queries_count |
| 98 | - mysql.process_list_longest_query_duration |
| 99 | - mysql.process_list_fetch_query_duration |
| 100 | - type: group |
| 101 | id: cache |
| 102 | title: Cache |
| 103 | items: |
| 104 | - mysql.qcache_ops |
| 105 | - mysql.qcache |
| 106 | - mysql.qcache_freemem |
| 107 | - mysql.qcache_memblocks |
| 108 | - type: group |
| 109 | id: issues |
| 110 | title: Issues |
| 111 | items: |
| 112 | - mysql.join_issues |
| 113 | - mysql.sort_issues |
| 114 | - mysql.tmp |
| 115 | - type: group |
| 116 | id: resources |
| 117 | title: Resources |
| 118 | properties: { grouping: true } |
| 119 | items: |
| 120 | - type: group |
| 121 | id: handlers |
| 122 | title: Handlers |
| 123 | items: |
| 124 | - mysql.handlers |
| 125 | - type: group |
| 126 | id: connections-and-threads |
| 127 | title: Connections & Threads |
| 128 | items: |
| 129 | - mysql.connections |
| 130 | - mysql.connections_active |
| 131 | - mysql.connection_errors |
| 132 | - mysql.threads |
| 133 | - mysql.threads_created |
| 134 | - mysql.thread_cache_misses |
| 135 | - type: group |
| 136 | id: network |
| 137 | title: Network |
| 138 | items: |
| 139 | - mysql.net |
| 140 | - type: group |
| 141 | id: files-and-tables |
| 142 | title: Files & Tables |
| 143 | items: |
| 144 | - mysql.files |
| 145 | - mysql.files_rate |
| 146 | - mysql.open_tables |
| 147 | - mysql.opened_tables |
| 148 | - mysql.table_open_cache_overflows |
| 149 | - mysql.table_locks |
| 150 | - type: group |
| 151 | id: storage-engine |
| 152 | title: Storage Engine |
| 153 | properties: { grouping: true } |
| 154 | items: |
| 155 | - type: group |
| 156 | id: innodb |
| 157 | title: InnoDB |
| 158 | properties: { grouping: true } |
| 159 | items: |
| 160 | - type: group |
| 161 | id: buffer-pool |
| 162 | title: Buffer Pool |
| 163 | items: |
| 164 | - mysql.innodb_buffer_pool_pages |
| 165 | - mysql.innodb_buffer_pool_bytes |
| 166 | - mysql.innodb_buffer_pool_ops |
| 167 | - mysql.innodb_buffer_pool_read_ahead |
| 168 | - mysql.innodb_buffer_pool_pages_flushed |
| 169 | - mysql.innodb_buffer_pool_read_ahead_rnd |
| 170 | - type: group |
| 171 | id: io |
| 172 | title: I/O |
| 173 | items: |
| 174 | - mysql.innodb_io |
| 175 | - mysql.innodb_io_ops |
| 176 | - mysql.innodb_io_pending_ops |
| 177 | - type: group |
| 178 | id: transactions-and-locks |
| 179 | title: Transactions & Locks |
| 180 | items: |
| 181 | - mysql.innodb_rows |
| 182 | - mysql.innodb_cur_row_lock |
| 183 | - mysql.innodb_deadlocks |
| 184 | - type: group |
| 185 | id: logging |
| 186 | title: Logging |
| 187 | items: |
| 188 | - mysql.innodb_log |
| 189 | - mysql.innodb_os_log |
| 190 | - mysql.innodb_os_log_fsync_writes |
| 191 | - mysql.innodb_os_log_io |
| 192 | - mysql.innodb_redo_log_activity |
| 193 | - mysql.innodb_redo_log_checkpoint_age |
| 194 | - mysql.innodb_redo_log_occupancy |
| 195 | - type: group |
| 196 | id: myisam |
| 197 | title: MyISAM |
| 198 | items: |
| 199 | - mysql.key_blocks |
| 200 | - mysql.key_requests |
| 201 | - mysql.key_disk_ops |
| 202 | - type: group |
| 203 | id: replication |
| 204 | title: Replication |
| 205 | properties: { grouping: true } |
| 206 | items: |
| 207 | - type: group |
| 208 | id: slave-status |
| 209 | title: Slave Status |
| 210 | items: |
| 211 | - mysql.slave_status |
| 212 | - mysql.slave_behind |
| 213 | - type: group |
| 214 | id: binary-logging |
| 215 | title: Binary Logging |
| 216 | items: |
| 217 | - mysql.binlog_cache |
| 218 | - mysql.binlog_stmt_cache |
| 219 | - type: group |
| 220 | id: galera-cluster |
| 221 | title: Galera Cluster |
| 222 | properties: { grouping: true } |
| 223 | items: |
| 224 | - type: group |
| 225 | id: cluster-status |
| 226 | title: Cluster Status |
| 227 | items: |
| 228 | - mysql.galera_cluster_status |
| 229 | - mysql.galera_cluster_state |
| 230 | - mysql.galera_cluster_size |
| 231 | - mysql.galera_cluster_weight |
| 232 | - mysql.galera_connected |
| 233 | - mysql.galera_ready |
| 234 | - type: group |
| 235 | id: galera-replication |
| 236 | title: Replication |
| 237 | items: |
| 238 | - mysql.galera_writesets |
| 239 | - mysql.galera_bytes |
| 240 | - mysql.galera_queue |
| 241 | - type: group |
| 242 | id: conflicts-and-flow-control |
| 243 | title: Conflicts & Flow Control |
| 244 | items: |
| 245 | - mysql.galera_conflicts |
| 246 | - mysql.galera_flow_control |
| 247 | - type: group |
| 248 | id: galera-resources |
| 249 | title: Resources |
| 250 | items: |
| 251 | - mysql.galera_open_transactions |
| 252 | - mysql.galera_thread_count |
| 253 | - type: group |
| 254 | id: user-statistics |
| 255 | title: User Statistics |
| 256 | properties: { grouping: true } |
| 257 | items: |
| 258 | - type: context |
| 259 | id: mysql-users |
| 260 | title: List MySQL Users |
| 261 | contexts: |
| 262 | - mysql.userstats_cpu |
| 263 | - mysql.userstats_rows |
| 264 | - mysql.userstats_commands |
| 265 | - mysql.userstats_created_transactions |
| 266 | - mysql.userstats_empty_queries |
| 267 | chart_library: table |
| 268 | group_by: [dimension, label, node, context] |
| 269 | group_by_label: [user] |
| 270 | table_columns: [context, dimension] |
| 271 | labels: |
| 272 | mysql.userstats_cpu: Cpu |
| 273 | mysql.userstats_rows: Rows |
| 274 | mysql.userstats_commands: Commands |
| 275 | mysql.userstats_created_transactions: Transactions |
| 276 | mysql.userstats_empty_queries: Empty Queries |
| 277 | - type: group |
| 278 | id: resource-usage |
| 279 | title: Resource Usage |
| 280 | short_name: Rusage |
| 281 | items: |
| 282 | - mysql.userstats_cpu |
| 283 | - mysql.userstats_rows |
| 284 | - type: group |
| 285 | id: commands |
| 286 | title: Commands |
| 287 | items: |
| 288 | - mysql.userstats_commands |
| 289 | - mysql.userstats_denied_commands |
| 290 | - type: group |
| 291 | id: user-connections |
| 292 | title: Connections |
| 293 | items: |
| 294 | - mysql.userstats_connections |
| 295 | - mysql.userstats_lost_connections |
| 296 | - mysql.userstats_denied_connections |
| 297 | - type: group |
| 298 | id: transactions |
| 299 | title: Transactions |
| 300 | items: |
| 301 | - mysql.userstats_created_transactions |
| 302 | - mysql.userstats_binlog_written |
| 303 | - mysql.userstats_empty_queries |