Updated by mfriedrich on 2010-07-19 14:01:56 +00:00

so to speak the db is on a seperate host, but not ido2db itsself right? you could consider setting up

g5 icinga core with idomod+tcp socket
g3 ido2db+tcp socket with mysql rdbms

Maybe the altinity patch for extended hashslots was not that good for your setup. but i did not change that much in idoutils between those 2 releases except the database.. hmm.

Updated by crsp on 2010-07-19 14:24:53 +00:00

You're so right, this is exactly my setup:

g5 icinga core with idomod+tcp socket
g3 ido2db+tcp socket with mysql rdbms

Updated by mfriedrich on 2010-07-27 16:55:36 +00:00

hm, what are your config_output_options in idomod.cfg?

Updated by crsp on 2010-07-28 08:34:25 +00:00

it's set to 1: config_output_options=1

Updated by mfriedrich on 2010-08-06 18:27:26 +00:00

hm, show me

select * from icinga_instances;

select count(*) as cnt from icinga_objects where is_ative=0;

select count(*) as cnt from icinga_objects join icinga_instances on icinga_objects.instance_id=icinga_instances.instance_id where icinga_objects.is_ative=0 and icinga_instances.instance_name='YOUR CURRENT INSTANCE NAME IN IDOMOD.CFG';

Updated by crsp on 2010-08-06 19:14:15 +00:00

here you are:

select * from icinga_instances;

------------~~------------------------------------~~
| instance_id | instance_name | instance_description |

------------~~------------------------------------~~
| 1 | default | |

------------~~------------------------------------~~
1 row in set (0.01 sec)

select count(*) as cnt from icinga_objects where is_ative=0;

ERROR 1054 (42S22): Unknown column 'is_ative' in 'where clause'

select count(*) as cnt from icinga_objects join icinga_instances on icinga_objects.instance_id=icinga_instances.instance_id where icinga_objects.is_ative=0 and icinga_instances.instance_name='YOUR CURRENT INSTANCE NAME IN IDOMOD.CFG';

mysql> select count(*) as cnt from icinga_objects join icinga_instances on icinga_objects.instance_id=icinga_instances.instance_id where icinga_objects.is_ative=0 and icinga_instances.instance_name='default';
ERROR 1054 (42S22): Unknown column 'icinga_objects.is_ative' in 'where clause'

Updated by mfriedrich on 2010-08-07 10:17:47 +00:00

hach gottchen bisschen mitdenken :P

typo => is_ative == is_active

(show create table icinga_objects)

Updated by crsp on 2010-08-07 15:06:14 +00:00

Mitdenken nu auch noch? :P
Ich vertraue immer dem Entwickler! :)

Aber hier:

mysql> select * from icinga_instances;
+-------------+---------------+----------------------+
| instance_id | instance_name | instance_description |
+-------------+---------------+----------------------+
|           1 | default       |                      |
+-------------+---------------+----------------------+
1 row in set (0.00 sec)

mysql>select count(*) as cnt from icinga_objects where is_active=0;

+-----+
| cnt |
+-----+
|  68 |
+-----+
1 row in set (0.01 sec)

mysql>select count(*) as cnt from icinga_objects join icinga_instances on icinga_objects.instance_id=icinga_instances.instance_id where icinga_objects.is_active=0 and icinga_instances.instance_name='default';

+-----+
| cnt |
+-----+
|  68 |
+-----+
1 row in set (0.02 sec)

Updated by mfriedrich on 2010-09-17 15:32:50 +00:00

• Status changed from New to Feedback

i can't reproduce that. can you recheck with 1.0.3 or the latest git master?

Updated by crsp on 2010-09-30 17:22:28 +00:00

Updated today to the latest stuff from GIT. so far not too bad!
a restart produces about 40% load on the Mysql host. this is ways less than some time ago.
i test some more days, otherwise i think we are done.

mni tnx!!!

Updated by mfriedrich on 2010-09-30 18:31:26 +00:00

ok very nice :)

Updated by mfriedrich on 2011-01-10 17:20:24 +00:00

• Status changed from Feedback to Closed

before i'll close the ticket - make sure you are using some way of ramdisk for pnp/perfdata. and put the mysql data stuff on an extended volume (like /var/lib), not on the same as /var/log and icinga.log reside.

but i think you'll find out yourself. closed for now.