I just did a health check on my bandwidth db (~1GB size) and spotted a few index issues.
Trying to repair via dump to sql and then read into a new db.
This read takes ages OK a few days so I moved it to my fastest machine Ryzen 59 with nvme raid 0 setup but even there it is now running since hours and and disk utlization is ~40%.
the node is handling ~20TB data and was running more than 3 years.
Is there any way to speed this up?
Any plans to move to a proper DB ?
Can I let the storage node running and replace the bandwith.db later (with a version that then will be ~1 day old)? what might be consequences?
for 1.:
First idea put everything into a ram disk. Should even be faster then raid0 nvme.
I just find it strange that this kind of mini db read takes ages and loading disk like hell.
Note: running it in RAM will still take hours - currently running
You will loose some history, and there would be a discrepancy between accounted on the node’s side and on the satellite’s side. The satellite’s information is collected from orders sent by your node, so you will be paid for what is submitted. So usage from the satellite’s point of view will be greater than from storagenode’s point of view.