Nagios Support Forum

> ndo2db.cfg currently does have an option for trimming service=20
> checks table, but apparently not for trimming the external=20
> commands table.
>=20
> In our case our master server is receiving up to 40k passive=20
> checks/5 min as external commands, resulting in the mysql=20
> databasefile growing by 100-200 megabytes an hour.
>=20
> We use the following workaround for now:
>=20
> #!/bin/sh
>=20
> # Workaround, no option in ndo2db.cfg for trimming the=20
> nagios_externalcommands table in ndoutils 1.4b7 # Reported to=20
> mailinglist medio feb 2008
>=20
> /usr/bin/mysql -unagiosuser -pnagiospw \
> -e 'USE master_ndo; DELETE FROM nagios_externalcommands WHERE
> unix_timestamp(entry_time) (unix_timestamp(date_add(now(), interval -30 minute))); '


FYI: Even after this, unfortunately our nagios_externalcommands table
file just kept growing anyway - seems that an additional

OPTIMIZE TABLE nagios_externalcommands

was needed to reclaim the space for re-use (we just added it as #2 sql
command in the cronjob).

Best regards,
Steffen Poulsen





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