Details
Minor Description
We've been running billing for a few years now for about 150 bills. The DB is growing and the bill_data table is responsible for most of the growth. I can't find anything in the Global settings for this and the housekeeping.php script doesn't seem to address this either.
The billing calculation cronjob was taking more then an hour so we needed to delete old bills and run optimize on the DB to speed this up a bit.
This improvement would be very much appreciated.
Attachments
Activity
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Pending Response [ 10000 ] | New: Resolved [ 5 ] |
| Comment |
[ _*General questions and device support can be discussed in [our Discord channel, click here to join|https://discord.gg/GjpNXKWm8W].*_ ---- Please make and attach additional information about the device: * full snmp dump from device: {noformat} snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1 > myagent.snmpwalk snmpwalk -v2c -c <community> -t 3 -Cc --hexOutputLength=0 -Ih -ObentxU <hostname> .1.3.6.1.4.1 >> myagent.snmpwalk {noformat} _If device not support SNMP version 2c, replace -v2c with -v1._ * If you have problems with discovery or poller processes, please do and attach these debugs: {noformat} ./discovery.php -d -h <device> ./poller.php -d -h <device> {noformat} * additionally attach device and/or vendor specific MIB files ---- {color:#505F79}_This comment is added automatically._{color} ] |
| Status | Original: Open [ 1 ] | New: Pending Response [ 10000 ] |