Project

General

Profile

action #112946

coordination #109846: [epic] Ensure all our database tables accomodate enough data, e.g. bigint for ids

coordination #112961: [epic] Followup to "openqa.suse.de is not reachable anymore, response times > 30s, multiple alerts over the weekend"

Extend openQA documentation with best practices what to do after migration, e.g. look at pg_stats

Added by okurz about 2 months ago. Updated about 2 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Feature requests
Target version:
Start date:
2022-06-23
Due date:
% Done:

0%

Estimated time:
Difficulty:

Description

Motivation

We learned during #112718 that it's a good idea to look at pg_stats if there are any "slow queries", either as regression from the migration or just from other issues and we have not realized yet. We should make sure our openQA database migration guide includes best practices as well

Acceptance criteria

  • AC1: Our documentation reminds what to do after migration

Suggestions

Point to https://github.com/os-autoinst/openQA/pull/4716/files#diff-71734bf4d91118f92743c7d0db9218c4f24729410e020110884606b5ad6a3878R1201 in https://github.com/os-autoinst/openQA/blob/master/docs/Contributing.asciidoc#how-to-update-the-database-schema


Related issues

Copied to openQA Project - action #112949: Exercise to switch off non-critical features and conduct emergency drillsNew2022-06-23

History

#1 Updated by okurz about 2 months ago

  • Copied to action #112949: Exercise to switch off non-critical features and conduct emergency drills added

#2 Updated by okurz about 2 months ago

  • Description updated (diff)
  • Parent task changed from #112718 to #112961

Also available in: Atom PDF