I just noticed that the eventlog.ibd which was located in /var/lib/mysql/librenms occupied most of disk space, and the size not reduced after I added eventlog_purge purge function in config.php, and performed daily.sh.
Does anyone faced this issue before?
Use Setting in WEB UI … Global Settings -> System -> Cleanup -> Event log entries older than (days).
If you need to clean out eventlog immediately go to the mysql console like:
TRUNCATE TABLE eventlog;
Thank you for your information! I tried both methods on my server, but the storage was 100% full, so I can not change anything, then I tried to expanded the storage and it’s working.