Hi!

What i also screwed up was not reading change logs... In my case, i had two brokers defined. One in icinga.cfg the other in <icinga conf>/modules/idomod.cfg, which meant that i was doing twice the work i intended... *donk*

As Michael suggested, try to look at your MYSQL setup, i've heard of Icinga installs way beyond what we have here and everything is working as it should.

another option would be to test the asynchronous ring buffer i have for now implemented in git head test/ido - this affects both, idomod and ido2db with asynchronous inserts and a default queue size of 50k. the main problem i still see is the config dump either on startup or restart/reload which causes the long lasting interval. i am thinking of adding a secondary socket just for the config dump, and having a single ido2db child working with it's own db connection on the config tables. but still, i'm interested in further tests of the ringbuffer itsself.

$ git clone git://git.icinga.org/icinga-core.git
$ cd icinga-core
$ git pull
$ git branch test/ido origin/test/ido
$ git checkout test/ido
$ .... configure ... make all ... make fullinstall

best is to add the startup delay check to localhost too - https://wiki.icinga.org/display/howtos/Check+Icinga+Startup+Delay

if this does not resolve the performance issues known with the bulk queries, i might revert that for the future releases.


If you figure out a good MYSQL config i'd sure be interested...






Regards,
D.

On 10/05/2011 11:46 AM, M. Diemel wrote:
Alexander and others,

Thanks for your reply.
If MySQL is the problem, removing it is of course a way of solving. Because MySQL is our main database, using an another introduces others problems we might not prefer (we simply have more knowledge with MySQL). Icinga states it supports MySQL, PostgreSQL and Oracle (and states it in this order). Does it really? Is there a preferred or best tested databases? And is it not MySQL? I'm curious in what other people use as a database back-end and the experiences with it.

Regards,
Maarten


On 5-10-2011 9:09, David Gerbec wrote:
Hi!

We have had the same issues with 1.5.x and MYSQL while on 1.4.x and MYSQL on the same amount of hosts/services things were running smooth.

Even tho the hardware stayed the same, the core OS has changed meaning the MYSQL version changed also so i can't really point a finger @Icinga for the issues.

I solved my problem with ditching MYSQL and using PostgreSQL. Things now work as they should.




Regards,
D.

On 10/05/2011 08:38 AM, alexander.hofm...@dfs.de wrote:
Hi,

we have the same problem at our site. It occurred the first time as we updated Icinga
to 1.5 and _loaded_ idomod. Without idomod everything works fine.



Mit freundlichen Grüßen

Alexander Hofmann, TM/SID
Datacenter
Tel.: (+49)6103 707 4505




Maarten Diemel <m.die...@hva.nl> schrieb am 04.10.2011 16:17:55:

> Von: Maarten Diemel <m.die...@hva.nl>
> An: icinga-users@lists.sourceforge.net
> Datum: 04.10.2011 16:52
> Betreff: [icinga-users] 442 seconds 'Status data OUTDATED' after reload
>
> Dear Icinga users and developers,
>
>
> After doing a 'service icinga reload'
> it looks like it takes about 442 seconds before the status data is 'updated'.
>
>
> Current Network Status
>
> Last Updated: Tue Oct 4 12:54:38 CEST 2011 - Updated every 90 seconds [pause]
>
> Icinga 1.5.1 - Logged in as Uncle.X
>
> Warning: Status data OUTDATED! Last status data update was 442 seconds ago!
>
>
> Should it take so long? Is this normal behavior for Icinga?
>
>
>
> System: HP blade 460c G7, with 2 Six-Core Intel Xeon, 2267 MHz and
> 8192 Mb memory.
> OS: Red Hat Enterprise Linux Server release 6.1 (Santiago)
> Icinga version 1.5.1 , RPM installation (RPM's are locally made from
> icinga.spec found in the official tarball)
> DB: MySQL 5.1.52
>
> Configuration is kept as close to the defaults as possible.
> Only icinga.cfg attached, other config files (ido stuff) unchanged
> except for db_socket and password.
>
> 476 hosts and
> 1691 services are being checked
>
> Machine seems not really busy, neither does our old server with
> exact configuration doing Nagios, running on a HP DL-385 (AMD), 2048
> Mb mem, on RHEL4.
>
> sar output of Icinga machine (period of reloading Icinga):
>
>                  CPU     %user     %nice   %system   %iowait    %
> steal     %idle
> 12:40:01 PM     all      1.71      0.00      0.60      1.09      0.
> 00     96.60
> 12:45:01 PM     all      1.80      0.00      0.63      1.24      0.
> 00     96.33
> 12:50:01 PM     all      1.16      0.00      0.37      2.34      0.
> 00     96.13
> 12:55:01 PM     all      0.61      0.00      0.08      2.43      0.
> 00     96.88
>
>
> Regards,
> Maarten
>
>
>
>
> [Anhang "icinga.cfg" gelöscht von Alexander Hofmann/DFS]
> ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2dcopy1
> _______________________________________________
> icinga-users mailing list
> icinga-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users


DFS Deutsche Flugsicherung GmbH
Am DFS-Campus 10
D - 63225 Langen

Tel.: +49-(0)6103-707-0

Sitz der Gesellschaft: Langen/Hessen
Zuständiges Registergericht: AG Offenbach am Main, HRB 34977
Vorsitzender des Aufsichtsrates: Prof. Klaus-Dieter Scheurle
Geschäftsführer: Dieter Kaden (Vors.), Ralph Riedle, Jens Bergmann

Internet: http://www.dfs.de
Public-Key der DFS: http://www.dfs.de/dfs/public_key.asc


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users

--
David Gerbec, sistemska podpora

Predlog! Obis(c(ite prenovljeno spletno stranhttp://www.agenda.si

ODPRTA KODA IN LINUX
STORITVE : POSLOVNE RESITVE : UPRAVLJANJE IT : INFRASTRUKTURA IT : 
IZOBRAZEVANJE : PROGRAMSKA OPREMA

Visit our updated web page athttp://www.agenda.si

OPEN SOURCE AND LINUX
SERVICES : BUSINESS SOLUTIONS : IT MANAGEMENT : IT INFRASTRUCTURE : TRAINING : 
SOFTWARE

"Windows is a 32-bit shell for a 16-bit extension to an 8-bit operating system 
designed for a 4-bit microprocessor by a 2-bit company that can't stand one bit of 
competition."


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users


--
Maarten Diemel
ITS - Stichting Hogeschool van Amsterdam
Amsteldijk 166
1079 LH Amsterdam
The Netherlands
+31 20 595 37 42


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users

--
David Gerbec, sistemska podpora

Predlog! Obis(c(ite prenovljeno spletno stranhttp://www.agenda.si

ODPRTA KODA IN LINUX
STORITVE : POSLOVNE RESITVE : UPRAVLJANJE IT : INFRASTRUKTURA IT : 
IZOBRAZEVANJE : PROGRAMSKA OPREMA

Visit our updated web page athttp://www.agenda.si

OPEN SOURCE AND LINUX
SERVICES : BUSINESS SOLUTIONS : IT MANAGEMENT : IT INFRASTRUCTURE : TRAINING : 
SOFTWARE

"Windows is a 32-bit shell for a 16-bit extension to an 8-bit operating system 
designed for a 4-bit microprocessor by a 2-bit company that can't stand one bit of 
competition."


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1


_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users


--
DI (FH) Michael Friedrich

Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria

email:  michael.friedr...@univie.ac.at
phone:  +43 1 4277 14359
mobile: +43 664 60277 14359
fax:    +43 1 4277 14338
web:    http://www.univie.ac.at/zid
        http://www.aco.net

Icinga Core&  IDOUtils Developer
http://www.icinga.org

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users

Reply via email to