[icinga-users] Problems with MySQL Icinga and NagVis

Fritjof mailing at alokat.org
Wed Sep 16 23:16:03 CEST 2009


Michael Zeiler wrote:
> Hi,
>
> i didn't use the installscript for the database. I
> installed the database manuell by using:
>
> mysql -u <user> < script.sql from the database.
> so in this way mysql use the default (myisam)
> or you change the installscript.
>
> After then i used some change from the nagios-forum for
> creating some additional indexes in some tables for the
> fields with date.
>
> I hope you can understand my english ...
>
> 2009/9/16 Fritjof <mailing at alokat.org>
>
>   
>>  Michael Zeiler wrote:
>>
>> Hi,
>>
>> first i use innodb and i had the same problems.
>> after i changed all tables to myisam its running very faster.
>>
>> Michael
>>
>> 2009/9/14 Fritjof <mailing at alokat.org> <mailing at alokat.org>
>>
>>     Michael Friedrich wrote:
>>
>> Hi,
>>
>> Fritjof wrote:
>>
>>
>>  Hi,
>>
>> since a few days I'm using icinga with nagvis, idoutils and mysql.
>> The thing is, that the system causes a high load: 8 - 10.
>> But I'm only writing into the database what's necessary for nagvis. I
>> don't have the config files here, sorry.
>>
>>
>>  Did you set the appropriate values to the eventbroker needed for IDOMOD
>> in the cfg or just the db trimming options?
>>
>>
>>
>>  I monitor 80 Hosts and 2k Services.
>> If I deaktivate idoutils the load goes down 1 - 2.
>>
>> Does someone else have the problem or would it better work with postgresql?
>>
>>
>>  It's a "feature" that IDOUtils first writes everything defined in the
>> configs to the database. Afterwards, there some kind of housekeeper that
>> runs and trims entries older than defined in ido2db.cfg.
>>
>> You're are welcome to test it with Postgres ... I've run several stress
>> tests letting the database trim every minute (that's just for testing
>> though) and Postgres has a lot of trouble with insert/update and then a
>> following delete. But beware that's just for testing. I would recommend
>> that you set the db trimming options e.g. those values:
>>
>> max_timedevents_age=1440
>> max_systemcommands_age=2880
>> max_servicechecks_age=50
>> max_eventhandlers_age=44640
>>
>> (we are using only live servicestatus...)
>>
>> and make sure that the timed_events are not handed over (event broker
>> options).
>>
>> In any case if you try Postgres please get the latest GIT master from git.icinga.org (or the next release which has the bugfixes applied) -
>> testing and reporting feedback is very welcome! :-)
>>
>> Kind regards,
>> Michael
>>
>> ------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
>> trial. Simplify your report design, integration and deployment - and focus on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> icinga-users mailing listicinga-users at lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/icinga-users
>>
>>  Hi Michael,
>>
>> thanks for your help.
>>
>> I'm going to test your configuration... and post the results.
>>
>> I will test icinga + postgresql with another icinga installation and give
>> you feedback how it works.
>>
>>
>> Greetings,
>>
>> Fritjof
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
>> trial. Simplify your report design, integration and deployment - and focus
>> on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> _______________________________________________
>> icinga-users mailing listicinga-users at lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/icinga-users
>>
>>
>>        ------------------------------
>>
>> ------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
>> trial. Simplify your report design, integration and deployment - and focus on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>>
>> ------------------------------
>>
>> _______________________________________________
>> icinga-users mailing listicinga-users at lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/icinga-users
>>
>>  Hi Michael,
>>
>> how did you change your storage engine to myisam - only skipping innodb?
>> Or have you done something else?
>>
>> Greetings,
>>
>> Fritjof
>>
>>
>> ------------------------------------------------------------------------------
>> Come build with us! The BlackBerry® Developer Conference in SF, CA
>> is the only developer event you need to attend this year. Jumpstart your
>> developing skills, take BlackBerry mobile applications to market and stay
>> ahead of the curve. Join us from November 9-12, 2009. Register now!
>> http://p.sf.net/sfu/devconf
>> _______________________________________________
>> icinga-users mailing list
>> icinga-users at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/icinga-users
>>
>>
>>     
>
>   
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay 
> ahead of the curve. Join us from November 9-12, 2009. Register now!
> http://p.sf.net/sfu/devconf
> ------------------------------------------------------------------------
>
> _______________________________________________
> icinga-users mailing list
> icinga-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users
>   
Hi,

thanks for your answer.

Btw: Your English is very good ... :-)


Greetings,

Fritjof
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.icinga.org/pipermail/icinga-users/attachments/20090916/a2bcf369/attachment-0001.html>


More information about the icinga-users mailing list