matters-server icon indicating copy to clipboard operation
matters-server copied to clipboard

Published 20 hours ago • verified publisher icon thematters

Investigate why the database storage usage keeps increasing

Open robertu7 opened this issue 2 years ago • 3 comments

References

robertu7 avatar Sep 27 '22 12:09 robertu7

Notes

  • According to meeting, we still need to dig problem out
  • Charlie will review the logs

devformatters avatar Oct 12 '22 13:10 devformatters

Notes

  • According to meeting, need @Carolusian make a documentation about contingency plan

devformatters avatar Oct 19 '22 15:10 devformatters

Below graph shows the accumulated stats of temp files: around 500GB will be generated and deleted for daily sessions.

Image

So the fluctuation of disk space is normal.

The persistent usage of the DB now is around 46GB as of 20 Oct 2022.

Since auto-scaling is enabled now, if insufficient disk usage happens again, can enlarge the threshold of autoscaling. The autoscaling threshold can be set between 176GB to 65TB.

Carolusian avatar Oct 20 '22 04:10 Carolusian