Module: check_mk
Branch: master
Commit: 1da0a9af9c63da7069f6db6b98affadb7b227336
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=1da0a9af9c63da…
Author: Florian Heigl <fh(a)mathias-kettner.de>
Date: Tue Jun 5 13:21:34 2012 +0200
Corrections for postgres_sessions man page
---
checkman/postgres_sessions | 9 +++------
1 files changed, 3 insertions(+), 6 deletions(-)
diff --git a/checkman/postgres_sessions b/checkman/postgres_sessions
index 33d3f83..d415a6f 100644
--- a/checkman/postgres_sessions
+++ b/checkman/postgres_sessions
@@ -6,13 +6,11 @@ distribution: check_mk
description:
This check allows tracking of the session parameters for a PostgreSQL
database.
- It reports how many sessions there are in total, how many of them are
- active, and at what rate new sessions are generated.
+ It reports how many sessions there are in total and how many of them are
+ actively querying something.
It allows to set {WARN} and {CRIT} tresholds on any of these parameters.
- The data is gathered from the {show global status} query.
-
inventory:
The check generates one item for the sessions connected to the PostgreSQL
daemon.
@@ -24,5 +22,4 @@ inventory:
perfdata:
- The check generates perfdata for the total and running sessions, and the
- connection rate.
+ The check generates perfdata for the total and running sessions.
Module: check_mk
Branch: master
Commit: 2199cadfc5374c243ace9326c21e89f9373d9758
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=2199cadfc5374c…
Author: Florian Heigl <fh(a)mathias-kettner.de>
Date: Tue Jun 5 12:21:49 2012 +0200
Check man page for MySQL InnoDB IO rates
---
checkman/mysql.innodb_io | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/checkman/mysql.innodb_io b/checkman/mysql.innodb_io
new file mode 100644
index 0000000..9a0d00f
--- /dev/null
+++ b/checkman/mysql.innodb_io
@@ -0,0 +1,27 @@
+title: MySQL InnoDB engine IO statistics
+agents: linux
+author: Mathias Kettner <mk(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ This check tracks the IO rate of the InnoDB database
+ engine for MySQL.
+ The data is gathered from the {show global status} query.
+
+ It allows you plan IO device capacity by seeing how much
+ is read and written by InnoDB, or to proactively generate alerts if
+ something is generating far too much write IO.
+ The configuration of this check is internally done as a "disk check" but
+ presented in as an application monitoring in WATO.
+
+inventory:
+ The check generates one item, representing the InnoDB writers for a MySQL
+ Daemon.
+
+
+[configuration]
+ The check is configured like the {diskstat} check for block devices.
+
+
+perfdata:
+ The bytes read and written via InnoDB, along with the levels.
Module: check_mk
Branch: master
Commit: a54ae8260eb08da7e4a34eb9e368edf1f9b43687
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=a54ae8260eb08d…
Author: Florian Heigl <fh(a)mathias-kettner.de>
Date: Tue Jun 5 12:59:46 2012 +0200
Man page for PostgreSQL database statistics
---
checkman/postgres_stat_database | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/checkman/postgres_stat_database b/checkman/postgres_stat_database
new file mode 100644
index 0000000..a2c3b87
--- /dev/null
+++ b/checkman/postgres_stat_database
@@ -0,0 +1,29 @@
+title: Database statistics for PostgreSQL
+agents: linux
+author: Mathias Kettner <mk(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ This check handles the metrics returned from PostgreSQL's statistics
+ functions {pg_stat_database} and {pg_database_size}.
+ It allows monitoring of {disk blocks read}, but PostgreSQL seems to not
+ have a simple "written bytes" or "write IOs" counter, meaning this
+ information cannot be directly monitored.
+
+ Instead, the check allows more fine-grained monitoring of database activity
+ by tracking what the queries really do.
+ You can monitor both "read statements" like {fetches}, as well as
+ "write statements as {update/delete/insert}. Finally it allows monitoring of
+ {commits}, which PostgreSQL tracks down to the sub-transaction level.
+
+ You can then define levels on the per-second amount of the statements.
+
+inventory:
+ One item is generated per database.
+
+
+[configuration]
+
+perfdata:
+ The numbers for disk blocks read, and the number of transactions per
+ transaction type.
Module: check_mk
Branch: master
Commit: 71c7a0d699d0cb0b68d2b8ef31581e7090cabef2
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=71c7a0d699d0cb…
Author: Florian Heigl <fh(a)mathias-kettner.de>
Date: Tue Jun 5 12:32:14 2012 +0200
Man page for MySQL sessions
---
checkman/mysql.sessions | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/checkman/mysql.sessions b/checkman/mysql.sessions
new file mode 100644
index 0000000..b08064f
--- /dev/null
+++ b/checkman/mysql.sessions
@@ -0,0 +1,26 @@
+title: MySQL Database sessions
+agents: linux
+author: Mathias Kettner <mk(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ This check allows tracking of the session parameters for a MySQL database.
+ It reports how many sessions there are in total, how many of them are
+ active, and at what rate new sessions are generated.
+
+ It allows to set {WARN} and {CRIT} tresholds on any of these parameters.
+
+ The data is gathered from the {show global status} query.
+
+inventory:
+ The check generates one item for the sessions connected to the MySQL daemon.
+
+
+[configuration]
+ There is no preset level for this service, as the thresholds are dependant
+ on the application and usage of the MySQL databases.
+
+
+perfdata:
+ The check generates perfdata for the total and running sessions, and the
+ connection rate.
postgres_stat_database.size)
User-Agent: Heirloom mailx 12.4 7/29/08
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Module: check_mk
Branch: master
Commit: 628291cabdefdaa14c613c5a1c9034d38bd98011
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=628291cabdefda…
Author: Florian Heigl <fh(a)mathias-kettner.de>
Date: Tue Jun 5 12:42:48 2012 +0200
Man page for Postgres database size (postgres_stat_database.size)
---
checkman/postgres_stat_database.size | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/checkman/postgres_stat_database.size b/checkman/postgres_stat_database.size
new file mode 100644
index 0000000..fe5f6bb
--- /dev/null
+++ b/checkman/postgres_stat_database.size
@@ -0,0 +1,19 @@
+title: Database size check for PostgreSQL
+agents: linux
+author: Mathias Kettner <mk(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ This check tracks the space used by a PostgreSQL database
+ The check has no alarm levels since PostgreSQL databasizes don't have a
+ size limit. (Single table limit is 32TB, too)
+
+inventory:
+ The check generates one item per Database found.
+
+
+[configuration]
+ This check has no configuration.
+
+perfdata:
+ The check sends performance data for the size of the database.
Module: check_mk
Branch: master
Commit: 9d0cfbdb1a464bb98c1e6b0026b4d23df3e68556
URL: http://git.mathias-kettner.de/git/?p=check_mk.git;a=commit;h=9d0cfbdb1a464b…
Author: Florian Heigl <fh(a)mathias-kettner.de>
Date: Tue Jun 5 12:37:17 2012 +0200
Man page for PostgreSQL sessions
---
checkman/postgres_sessions | 28 ++++++++++++++++++++++++++++
1 files changed, 28 insertions(+), 0 deletions(-)
diff --git a/checkman/postgres_sessions b/checkman/postgres_sessions
new file mode 100644
index 0000000..33d3f83
--- /dev/null
+++ b/checkman/postgres_sessions
@@ -0,0 +1,28 @@
+title: PostgreSQL Database sessions
+agents: linux
+author: Mathias Kettner <mk(a)mathias-kettner.de>
+license: GPL
+distribution: check_mk
+description:
+ This check allows tracking of the session parameters for a PostgreSQL
+ database.
+ It reports how many sessions there are in total, how many of them are
+ active, and at what rate new sessions are generated.
+
+ It allows to set {WARN} and {CRIT} tresholds on any of these parameters.
+
+ The data is gathered from the {show global status} query.
+
+inventory:
+ The check generates one item for the sessions connected to the PostgreSQL
+ daemon.
+
+
+[configuration]
+ There is no preset level for this service, as the thresholds are dependant
+ on the application and usage of the PostgreSQL databases.
+
+
+perfdata:
+ The check generates perfdata for the total and running sessions, and the
+ connection rate.