MySQL-db "exploded" in size

I got a bit further… It seems that the daily cleanup of the Syslog-entries is broken for some reason. The entries do not get removed by the ./daily.sh script.

I just fired the command lnms maintenance:cleanup-syslog manually and it’s already running for ages. I will update this ticket when it’s finished.

EDIT: It just finished after nearly one hour runtime! :open_mouth:
Cleared syslog entries older than 7 days (33198601 rows)

Checking daily.sh I can not find any reference to the syslog-cleanup. Was it removed accidentally or was it never added?

And does anything speak against creating a PR containing the missing line for also cleaning syslog-entries by the daily job? If not, I’d do so.

Also, after running a mysqlcheck -o librenms the size on disk further went from now 21GB to 4.1GB! Should we also have a scheduled optimize in a cron-job? Or at least add some “best practice” notes so that the admins take care of this themselves?

        cleanup)
            # Cleanups
            options=("refresh_alert_rules"
                           "refresh_device_groups"
                           "recalculate_device_dependencies"
                           "eventlog"
                           "authlog"
                           "callback"
                           "purgeusers"
                           "bill_data"
                           "alert_log"
                           "rrd_purge"
                           "ports_fdb"
                           "ports_nac"
                           "route"
                           "ports_purge")
            call_daily_php "${options[@]}"
        ;;