Ad Widget

Collapse

/var/lib/pgsql/12/data/base/ folder growing constantly

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • neomustwin
    Junior Member
    • Nov 2020
    • 3

    #1

    /var/lib/pgsql/12/data/base/ folder growing constantly

    The /var/lib/pgsql/12/data/base/ folder has become too large. It grows 10 GB in 1 week. folders name for example ; 16385 folder has become too large. 30 GB. file name for example 17520 file 1 TB. what is this problem. how can he solve. I constantly have to increase the size of the var folder
  • NilsA
    Senior Member
    • Sep 2020
    • 102

    #2
    If you hold data from many items for a long time, you need to expect to require a large amount of disk space for the database. What is your nvps? How long are your items configured to keep their data (history storage period)?

    Comment

    • soumya
      Junior Member
      • Nov 2013
      • 21

      #3
      @neomustwin

      what is the standard polling interval you've defined for your items. If it's below 5min (with very large no of items), there is possibility of DB size increase. apart check whether housekeeping is happening properly or not. that might be another reason.

      Comment

      • neomustwin
        Junior Member
        • Nov 2020
        • 3

        #4
        Thank you for your answer. how can i increase this 5m time. i just started zabbix.

        Comment

        • neomustwin
          Junior Member
          • Nov 2020
          • 3

          #5
          Originally posted by NilsA
          If you hold data from many items for a long time, you need to expect to require a large amount of disk space for the database. What is your nvps? How long are your items configured to keep their data (history storage period)?
          sorry
          Zabbix server is running Yes localhost:10051
          Number of hosts (enabled/disabled) 1480 1480 / 0
          Number of templates 150
          Number of items (enabled/disabled/not supported) 64480 60467 / 0 / 4013
          Number of triggers (enabled/disabled [problem/ok]) 1815 1815 / 0 [54 / 1761]
          Number of users (online) 3 1
          Required server performance, new values per second 814.93

          Comment

          Working...