Good day,
Any suggestion on how could I prevent running out of space? When space is full, web UI cannot be accessed. I already tried enabling the Cleanup Options and even change the values to 1. But nothing happens.
Thank you!
See this:
source: Support/Cleanup-options.md
# Cleanup Options
As the number of devices starts to grow in your LibreNMS install, so will things such as the RRD files, MySQL database containing eventlogs, Syslogs and performance data etc. Your LibreNMS install could become quite large so it becomes necessary to clean up those entries. With Cleanup Options, you can keep in crontrol.
These options rely on ```daily.sh``` running from cron as per the installation instructions.
Cleanup Options are set in ```config.php```
```php
$config['syslog_purge'] = 30;
$config['eventlog_purge'] = 30;
$config['authlog_purge'] = 30;
$config['perf_times_purge'] = 30;
$config['device_perf_purge'] = 7;
$config['rrd_purge'] = 90;// Not set by default
$config['ports_purge'] = true;// Set to false by default
```
These options will ensure data within LibreNMS over X days old is automatically purged. You can alter these individually, values are in days.
show original
Good day @Daniel_Schmidt ,
Already done that. Still monitoring if it will work. But for now do you have any way to manually conduct cleaning of DB?
laf
3 October 2018 17:18
4
Set those values and run ./daily.sh.
MySQL typically doesn’t free up space when you delete data, you might need to dump the large tables and reimport them. That’s a mysql thing so you can look up how to do that on google.
Hi @laf ,
I already run ./daily.sh command and yet nothing changed.
Have you run something like ncdu to see where your space is actually being used?
laf
3 October 2018 20:15
7
Then it’s got nothing to delete. See the rest of my response to gain disk space back from mysql.
How about the cleanup options? Will it help?
I already enable that option and set it up to 15 days.
@laf
Does clearing mysql logs help?
Rick
6 October 2018 12:03
10
Try with mysqltuner.pl, it will suggest you when there is space to free up…