Feature #20028

Need Katello size estimation script

Added by Andrew Kofink 11 months ago. Updated 8 months ago.

Status:Duplicate
Priority:High
Assigned To:Andrew Kofink
Category:Upgrades
Target version:Team Brad - Backlog
Difficulty: Pull request:
Bugzilla link:1390694
Story points-
Velocity based estimate-
ReleaseKatello Recycle BinRelease relationshipAuto

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1390694
We need a simple script that users can run that can collect the following information:

1) Disk consumption and availability of the following directories:
/var/lib/pulp/
/var/lib/mongodb/
/var/lib/pgsql/
2) Disk speed using hdparm:
  1. hdparm -tT /dev/sda
/dev/sda:
Timing cached reads: 31332 MB in 2.00 seconds = 15689.05 MB/sec
Timing buffered disk reads: 466 MB in 3.01 seconds = 154.99 MB/sec
Not all Katello servers will have this installed so just automatically install it if you have to
3) Table sizes:
https://gist.github.com/mccun934/e93358be72902aa67dc450cb4f7c4574
cat tablesizes.sql | sudo -u postgres psql -d foreman
4) Table counts:
select count() from hosts;
select count(
) from dynflow_actions;
select count() from dynflow_steps;
select count(
) from katello_repositories;
A second phase would be to take these #s and calculate an estimated upgrade time but just gathering this data will be helpful and can be included in foreman-debug if possible.
A name like:
  1. katello-size-report
would be easy to remember

Related issues

Duplicates Foreman Maintain - Feature #20267: Need Foreman size estimation script New 07/10/2017

History

#1 Updated by Andrew Kofink 11 months ago

  • Subject changed from Need Katello size estimation script to Need Katello size estimation script
  • Assigned To set to Andrew Kofink
  • Target version set to Team Brad - Iteration 16

#2 Updated by Justin Sherrill 11 months ago

  • Release set to Katello 3.5.0

#3 Updated by Brad Buckingham 11 months ago

  • Target version changed from Team Brad - Iteration 16 to Team Brad - Backlog

#4 Updated by Mike McCune 11 months ago

  • Status changed from New to Closed

closing this out in favor of:

http://projects.theforeman.org/issues/20267

#5 Updated by Andrew Kofink 8 months ago

  • Release deleted (Katello 3.5.0)

#6 Updated by Justin Sherrill 8 months ago

  • Status changed from Closed to Duplicate
  • Release set to Katello Recycle Bin

#7 Updated by Justin Sherrill 8 months ago

  • Duplicates Feature #20267: Need Foreman size estimation script added

Also available in: Atom PDF