Hi, I have sizeable installation of nagios server. I have two server with failover setup. Since I am using ndo, my server takes a long time to start up. While my primary servers doing initial insertion and deletion, my backup thinks primary is not in service so it starts notifications instead of primary. I am trying to see how I can resolve this issue. I have downloaded the newer version of ndo but it did not help. I think it has to do with my indexing. I have read the following thread which talks about reducing the table size by lowering the retention time. <a href="http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg23938.html">http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg23938.html</a> However my requirement is that I have to keep most of hostchecks, servicechecks and events for longtime. Also, in another post Jim Avery mentioned the following. innodb_flush_log_at_trx_commit = 2 What does innodb flush means when it comes to master-master replication between primary and secondary. Please advise on this. Thanks Following are my current indexes -- mysql> show indexes from nagios_objects; +----------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +----------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+ | nagios_objects | 0 | PRIMARY | 1 | object_id | A | 26095 | NULL | NULL | | BTREE | | | nagios_objects | 1 | objecttype_id | 1 | objecttype_id | A | 3 | NULL | NULL | | BTREE | | | nagios_objects | 1 | objecttype_id | 2 | name1 | A | 26095 | NULL | NULL | | BTREE | | | nagios_objects | 1 | objecttype_id | 3 | name2 | A | 26095 | NULL | NULL | YES | BTREE | | +----------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+ 4 rows in set (0.01 sec) mysql> show indexes from nagios_hostchecks; +-------------------+------------+-------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-------------------+------------+-------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+ | nagios_hostchecks | 0 | PRIMARY | 1 | hostcheck_id | A | 12532724 | NULL | NULL | | BTREE | | | nagios_hostchecks | 0 | instance_id | 1 | instance_id | A | 16 | NULL | NULL | | BTREE | | | nagios_hostchecks | 0 | instance_id | 2 | host_object_id | A | 16 | NULL | NULL | | BTREE | | | nagios_hostchecks | 0 | instance_id | 3 | start_time | A | 12532724 | NULL | NULL | | BTREE | | | nagios_hostchecks | 0 | instance_id | 4 | start_time_usec | A | 12532724 | NULL | NULL | | BTREE | | +-------------------+------------+-------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+ 5 rows in set (0.14 sec) mysql> show indexes from nagios_servicechecks; +----------------------+------------+-------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +----------------------+------------+-------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+ | nagios_servicechecks | 0 | PRIMARY | 1 | servicecheck_id | A | 19555522 | NULL | NULL | | BTREE | | | nagios_servicechecks | 0 | instance_id | 1 | instance_id | A | 17 | NULL | NULL | | BTREE | | | nagios_servicechecks | 0 | instance_id | 2 | service_object_id | A | 17 | NULL | NULL | | BTREE | | | nagios_servicechecks | 0 | instance_id | 3 | start_time | A | 19555522 | NULL | NULL | | BTREE | | | nagios_servicechecks | 0 | instance_id | 4 | start_time_usec | A | 19555522 | NULL | NULL | | BTREE | | +----------------------+------------+-------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+ 5 rows in set (0.32 sec) show indexes from nagios_timedevents; +--------------------+------------+-------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +--------------------+------------+-------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+ | nagios_timedevents | 0 | PRIMARY | 1 | timedevent_id | A | 0 | NULL | NULL | | BTREE | | | nagios_timedevents | 0 | instance_id | 1 | instance_id | A | 0 | NULL | NULL | | BTREE | | | nagios_timedevents | 0 | instance_id | 2 | event_type | A | 0 | NULL | NULL | | BTREE | | | nagios_timedevents | 0 | instance_id | 3 | scheduled_time | A | 0 | NULL | NULL | | BTREE | | | nagios_timedevents | 0 | instance_id | 4 | object_id | A | 0 | NULL | NULL | | BTREE | | +--------------------+------------+-------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+ 5 rows in set (0.00 sec) -- Cordially, Shadhin Rahman