Project

General

Profile

Actions
Copy link

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) - 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 open — 1 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
Copy link

Also available in: Atom PDF