[icinga-checkins] icinga.org: icinga-core/mfriedrich/core: idoutils: only insert service and host checks when they are finally processed, increase performance by replacing insert/update with single insert ( idea by Opsview/Opsera Ltd with mysql and servicechecks) #1100

git at icinga.org git at icinga.org
Thu Jan 20 10:25:30 CET 2011


Module: icinga-core
Branch: mfriedrich/core
Commit: 20b634378d431fa91362f0941aa6fdd18b438d2e
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=20b634378d431fa91362f0941aa6fdd18b438d2e

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Thu Jan 20 10:23:38 2011 +0100

idoutils: only insert service and host checks when they are finally processed, increase performance by replacing insert/update with single insert (idea by Opsview/Opsera Ltd with mysql and servicechecks) #1100

kudos and credits to Opsview for the idea and initial implementation.

this is extended for hostchecks and all 3 supported rdbms.

upgrade scripts are available for 1.3.0

massive performance increase!

fixes #1100

---

 Changelog                                          |    9 +
 module/idoutils/db/mysql/mysql-upgrade-1.3.0.sql   |    9 +
 module/idoutils/db/mysql/mysql.sql                 |   14 +-
 module/idoutils/db/oracle/oracle-upgrade-1.3.0.sql |   11 +
 module/idoutils/db/oracle/oracle.sql               |   12 +-
 module/idoutils/db/pgsql/pgsql-upgrade-1.3.0.sql   |    8 +
 module/idoutils/db/pgsql/pgsql.sql                 |   14 +-
 module/idoutils/include/dbqueries.h                |    4 +-
 module/idoutils/src/db.c                           |    8 +-
 module/idoutils/src/dbhandlers.c                   |   15 +-
 module/idoutils/src/dbqueries.c                    |  384 ++++++--------------
 module/idoutils/src/idomod.c                       |    8 +
 12 files changed, 183 insertions(+), 313 deletions(-)

Diff:   https://git.icinga.org/?p=icinga-core.git;a=commitdiff;h=20b634378d431fa91362f0941aa6fdd18b438d2e




More information about the icinga-checkins mailing list