Project

General

Profile

Actions

action #100976

open

specific alert about the size of our database, maybe even database tables?

Added by okurz about 3 years ago. Updated about 3 years ago.

Status:
New
Priority:
Low
Assignee:
-
Category:
-
Target version:
QA (public, currently private due to #173521) - future
Start date:
2021-10-12
Due date:
% Done:

0%

Estimated time:

Description

Motivation

Over 80% space of /srv on OSD are used up. In #100859 we already identified that it's mostly our database with currently 72G out of 100G but /srv also stores system logs and "homes.img" and we can not easily distinguish which part grows in space. Can we have monitoring alerts for the database or even database tables directly?

Acceptance Criteria

AC1: We can monitor the growth of database, not just complete /srv

Suggestions

  • Research if there can be cool postgres specific telegraf queries that already provide this

Related issues 2 (1 open1 closed)

Copied from openQA Infrastructure (public) - action #100859: investigate how to optimize /srv data utilization on OSD size:SResolvedmkittler2021-10-12

Actions
Copied to openQA Infrastructure (public) - action #100979: configure better auto-vacuum for our database(s)New2021-10-12

Actions
Actions #1

Updated by okurz about 3 years ago

  • Copied from action #100859: investigate how to optimize /srv data utilization on OSD size:S added
Actions #2

Updated by okurz about 3 years ago

  • Copied to action #100979: configure better auto-vacuum for our database(s) added
Actions

Also available in: Atom PDF