Project

General

Profile

Actions
Copy link

action #94705

open

coordination #80142: [saga][epic] Scale out: Redundant/load-balancing deployments of openQA, easy containers, containers on kubernetes

coordination #92854: [epic] limit overload of openQA webUI by heavy requests

Monitor number of SQL queries in grafana

Added by tinita over 3 years ago. Updated over 1 year ago.

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

0%

Estimated time:
Tags:
infra

Description

Currently we are monitoring the number of returned, fetched, inserted, deleted and updated rows:
https://stats.openqa-monitor.qa.suse.de/d/WebuiDb/webui-summary?orgId=1&viewPanel=89&from=now-9d&to=now&refresh=10s

It can also be helpful to monitor the number of queries. Maybe postgres even provides statistics of cache hits/misses.

Monitoring the number of SQL queries can help analyzing performance, and also possibly find accidental code changes, e.g. a removed prefetch in DBIx::Class (like this one: https://github.com/os-autoinst/openQA/pull/3969)

Related issues 1 (0 open — 1 closed)

Related to openQA Infrastructure (public) - coordination #112718: [alert][osd] openqa.suse.de is not reachable anymore, response times > 30s, multiple alerts over the weekendResolvedokurz2022-06-22

Actions
Actions
Copy link
 #1

Updated by tinita over 3 years ago

  • Parent task set to #92854
Actions
Copy link
 #2

Updated by okurz over 2 years ago

  • Related to coordination #112718: [alert][osd] openqa.suse.de is not reachable anymore, response times > 30s, multiple alerts over the weekend added
Actions
Copy link
 #3

Updated by okurz over 1 year ago

  • Tags set to infra
Actions
Copy link

Also available in: Atom PDF