diff options
author | Costa Tsaousis (ktsaou) <costa@tsaousis.gr> | 2015-11-25 01:46:50 +0200 |
---|---|---|
committer | Costa Tsaousis (ktsaou) <costa@tsaousis.gr> | 2015-11-25 01:46:50 +0200 |
commit | 62aac417f30aba33549f4e706b43f685d988a58d (patch) | |
tree | 5d8bb9877b8c0efa8d604d49ea1fb680b8cfd8f4 /charts.d/mysql.chart.sh | |
parent | f1153c39829ffc42e0fb35e411a7988e0066c569 (diff) |
added more values
Diffstat (limited to 'charts.d/mysql.chart.sh')
-rwxr-xr-x | charts.d/mysql.chart.sh | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/charts.d/mysql.chart.sh b/charts.d/mysql.chart.sh index 20bbbc6961..ffd635ff8e 100755 --- a/charts.d/mysql.chart.sh +++ b/charts.d/mysql.chart.sh @@ -75,6 +75,10 @@ mysql_get() { mysql_Innodb_data_written \ mysql_Innodb_data_reads \ mysql_Innodb_data_writes \ + mysql_Innodb_data_fsyncs \ + mysql_Innodb_data_pending_reads \ + mysql_Innodb_data_pending_writes \ + mysql_Innodb_data_pending_fsyncs \ mysql_Innodb_log_waits \ mysql_Innodb_log_write_requests \ mysql_Innodb_log_writes \ @@ -229,6 +233,12 @@ DIMENSION Innodb_data_written write incremental -1 $((1000 * mysql_update_every) CHART mysql_$m.innodb_io_ops '' "mysql InnoDB I/O Operations" "operations/s" mysql_$m mysql line 20015 $mysql_update_every DIMENSION Innodb_data_reads reads incremental 1 $((1 * mysql_update_every)) DIMENSION Innodb_data_writes writes incremental -1 $((1 * mysql_update_every)) +DIMENSION Innodb_data_fsyncs fsyncs incremental 1 $((1 * mysql_update_every)) + +CHART mysql_$m.innodb_io_pending_ops '' "mysql InnoDB Pending I/O Operations" "operations/s" mysql_$m mysql line 20015 $mysql_update_every +DIMENSION Innodb_data_pending_reads reads absolute 1 1 +DIMENSION Innodb_data_pending_writes writes absolute -1 1 +DIMENSION Innodb_data_pending_fsyncs fsyncs absolute 1 1 CHART mysql_$m.innodb_log '' "mysql InnoDB Log Operations" "operations/s" mysql_$m mysql line 20016 $mysql_update_every DIMENSION Innodb_log_waits waits incremental 1 $((1 * mysql_update_every)) @@ -387,6 +397,12 @@ END BEGIN mysql_$m.innodb_io_ops $1 SET Innodb_data_reads = $mysql_Innodb_data_reads SET Innodb_data_writes = $mysql_Innodb_data_writes +SET Innodb_data_fsyncs = $mysql_Innodb_data_fsyncs +END +BEGIN mysql_$m.innodb_io_pending_ops $1 +SET Innodb_data_pending_reads = $mysql_Innodb_data_pending_reads +SET Innodb_data_pending_writes = $mysql_Innodb_data_pending_writes +SET Innodb_data_pending_fsyncs = $mysql_Innodb_data_pending_fsyncs END BEGIN mysql_$m.innodb_log $1 SET Innodb_log_waits = $mysql_Innodb_log_waits |