diff options
author | Oleksii Kravchenko <kamikaze.ua@gmail.com> | 2019-05-27 11:50:09 +0300 |
---|---|---|
committer | Chris Akritidis <43294513+cakrit@users.noreply.github.com> | 2019-05-27 10:50:09 +0200 |
commit | dfa3c9064eafaeb0b93be0ba73c63f6088ba7597 (patch) | |
tree | d6b2949a8131494df61897f08a1a991c6a8bc17a | |
parent | 47d0c8854c8d737b6b1b3bb3d73b59fa3b389c43 (diff) |
add mysql deadlock chart (#6115)
-rw-r--r-- | collectors/python.d.plugin/mysql/mysql.chart.py | 9 | ||||
-rw-r--r-- | web/gui/dashboard_info.js | 4 |
2 files changed, 13 insertions, 0 deletions
diff --git a/collectors/python.d.plugin/mysql/mysql.chart.py b/collectors/python.d.plugin/mysql/mysql.chart.py index 139fac158f..9d8c456da7 100644 --- a/collectors/python.d.plugin/mysql/mysql.chart.py +++ b/collectors/python.d.plugin/mysql/mysql.chart.py @@ -90,6 +90,7 @@ GLOBAL_STATS = [ 'Innodb_buffer_pool_write_requests', 'Innodb_buffer_pool_reads', 'Innodb_buffer_pool_wait_free', + 'Innodb_deadlocks', 'Qcache_hits', 'Qcache_lowmem_prunes', 'Qcache_inserts', @@ -178,6 +179,7 @@ ORDER = [ 'innodb_os_log_fsync_writes', 'innodb_os_log_io', 'innodb_cur_row_lock', + 'innodb_deadlocks', 'innodb_rows', 'innodb_buffer_pool_pages', 'innodb_buffer_pool_flush_pages_requests', @@ -382,6 +384,13 @@ CHARTS = { ['Innodb_row_lock_current_waits', 'current_waits', 'absolute'] ] }, + 'innodb_deadlocks': { + 'options': [None, 'InnoDB Deadlocks', 'operations/s', 'innodb', + 'mysql.innodb_deadlocks', 'area'], + 'lines': [ + ['Innodb_deadlocks', 'deadlocks', 'incremental'] + ] + }, 'innodb_rows': { 'options': [None, 'InnoDB Row Operations', 'operations/s', 'innodb', 'mysql.innodb_rows', 'area'], 'lines': [ diff --git a/web/gui/dashboard_info.js b/web/gui/dashboard_info.js index 7d471689f9..6c85d76a11 100644 --- a/web/gui/dashboard_info.js +++ b/web/gui/dashboard_info.js @@ -1163,6 +1163,10 @@ netdataDashboard.context = { '</ul>' }, + 'mysql.innodb_deadlocks': { + info: 'A deadlock happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. For more information about <a href="https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html" target="_blank">how to minimize and handle deadlocks</a>.' + }, + // ------------------------------------------------------------------------ // POSTGRESQL |