Nagios Support Forum

This is a multi-part message in MIME format.
--------------000407050502010701060006
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Frassinelli, Marco wrote the following on 17.09.2009 17:11:
>
>
>
>
> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_PROGRAMSTATUS]);
>
>
> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_HOSTSTATUS]);
>
>
> ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_SERVICESTATUS]);
>
What makes you believe that this cleanup is wrong? Did you do a deeper
look at the conditional statement above which makes sure that old data
compared to real time data won't stay in the database?

Of course, it causes a heavy load on the database throwing big delete
statements. Worst case scenario, that the queries take too long and
everythings screws up.

Kind regards,
Michael

--
DI (FH) Michael Friedrich
[email protected]
Tel: +43 1 4277 14359

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


--------------000407050502010701060006
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit







Hi,

Frassinelli, Marco wrote the following on 17.09.2009 17:11:


 
      
         ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_PROGRAMSTATUS]);
               
ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_HOSTSTATUS]);
               
ndo2db_db_clear_table(idi,ndo2db_db_tablenames[NDO2DB_DBTABLE_SERVICESTATUS]);


What makes you believe that this cleanup is wrong? Did you do a
deeper look at the conditional statement above which makes sure that
old data compared to real time data won't stay in the database?

Of course, it causes a heavy load on the database throwing big delete
statements. Worst case scenario, that the queries take too long and
everythings screws up.

Kind regards,
Michael

--
DI (FH) Michael Friedrich
[email protected]
Tel: +43 1 4277 14359

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




--------------000407050502010701060006--





This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]