Project

General

Profile

Actions

action #100988

closed

ask for OSD /srv to be enlarged (was: investigate how to optimize /srv data utilization on OSD) size:S

Added by okurz over 2 years ago. Updated over 1 year ago.

Status:
Resolved
Priority:
Low
Assignee:
Category:
-
Target version:
Start date:
2021-10-12
Due date:
% Done:

0%

Estimated time:
Tags:

Description

Motivation

Over 80% space of /srv on OSD are used up. Most of this data is used by our postgresql database.
I raised this concern in slack where some possible reasons where discussed. One of them is to figure out why postgresql uses so much data. @mkittler mentioned that a fresh database import lowers disk space consumption drastically.

Also see poo#89821 for some history about the alert itself.

Acceptance Criteria

AC1: Alert does not trigger any longer
AC2: Understand why our production database uses the space it uses

Suggestions


Related issues 1 (1 open0 closed)

Copied from openQA Infrastructure - action #100985: Come up with a way to regularly check job group configs for outliers and misconfiguration, e.g. overly long result retention periodsNew2021-10-12

Actions
Actions #1

Updated by okurz over 2 years ago

  • Copied from action #100985: Come up with a way to regularly check job group configs for outliers and misconfiguration, e.g. overly long result retention periods added
Actions #2

Updated by okurz over 2 years ago

  • Subject changed from investigate how to optimize /srv data utilization on OSD size:S to ask for OSD /srv to be enlarged (was: investigate how to optimize /srv data utilization on OSD) size:S
Actions #3

Updated by okurz over 2 years ago

  • Status changed from New to Workable
Actions #4

Updated by okurz over 2 years ago

  • Priority changed from High to Low
  • Target version changed from Ready to future

with recent manual cleanup work by coolo /srv went to 62% (62G) usage so this task is less important right now

Actions #5

Updated by okurz over 2 years ago

With vacuuming the top-2 database tables we are now on 44% usage of /srv, i.e. 44G used, 57G free

Actions #6

Updated by okurz over 1 year ago

  • Tags set to infra
  • Status changed from Workable to Resolved
  • Assignee set to okurz

meanwhile space was increased, /srv is now 200G, currently 37% used

Actions

Also available in: Atom PDF