Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1086346

Summary: [RFE][Docs] Documentation specifying expected database usage for the rhevm_history database
Product: Red Hat Enterprise Virtualization Manager Reporter: Allie DeVolder <adevolder>
Component: DocumentationAssignee: Dong Zhao <dzhao>
Status: CLOSED CURRENTRELEASE QA Contact: rhev-docs <rhev-docs>
Severity: high Docs Contact:
Priority: high    
Version: 3.5.0CC: adevolder, ahecox, audgiri, dzhao, ecohen, emesika, iheim, lbopf, lnovich, lpeer, lsurette, rbalakri, sradco, yeylon, ylavi
Target Milestone: ---Keywords: FutureFeature
Target Release: 3.5.0   
Hardware: All   
OS: Linux   
Whiteboard: infra
Fixed In Version: Doc Type: Enhancement
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-03-04 01:26:06 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
History DB size estimate
none
History DB size estimate
none
History DB size estimate none

Description Allie DeVolder 2014-04-10 15:58:55 UTC 
[RFE] Documentation specifying expected database usage for the rhevm_history database
- Why does the customer need this? (List the business requirements here)
It should be possible to estimate how much space and resources will be used by the rhevm_history database based on the number of hosts, VMs, and other resources used.

- How would the customer like to achieve this? (List the functional
requirements here)

Documentation added to the Administration or Installation guide explaining how to estimate expected usage.
Comment 2 Yaniv Lavi 2014-05-07 09:15:46 UTC 
Eli any thoughts on how we can accomplish this?


Yaniv
Comment 3 Eli Mesika 2014-05-07 09:56:14 UTC 
(In reply to Yaniv Dary from comment #2)
> Eli any thoughts on how we can accomplish this?
> 
> 
> Yaniv

Well, first of all you need to know all the record sizes of each table in terms of Number of VMs, Number of Hosts etc.

Lets say that you have a table T which has NumberOfVMS records per hour 

to get the size of each record in T you should do in psql
> select pg_relation_size('T');
dividing this value with the count(*) of T will give you the number of bytes allocated to 1 record.

Now, you should give this a a formula for T, fo example if you are collecting info on one week and each row is 100 bytes you should give :

#VMs * 100 * 3600 * 24 * 7 => number of bytes

You should do that for each table T 
In you case, you should also consider table shrinks after aggregations
Comment 4 Yaniv Lavi 2014-05-18 14:13:26 UTC 
Moved this to sradco to provide details. Will move back to docs team member once we have this info.



Yaniv
Comment 5 Shirly Radco 2014-07-15 08:58:59 UTC 
Created attachment 918083 [details]
History DB size estimate
Comment 6 Shirly Radco 2014-07-15 09:08:27 UTC 
Hi,

Attached is the calculator that should give an estimation for the DWH history db after 5 years (The configured time to save daily statistics).

In the file there is a Mininmal and Maximal size values in GB.

The Maximal takes into account changes in the configurations and statuses.

The client should replace the numbers of the entities under the "example" with its planned configuration.

Also this is the size after 5 years. If he wants to see for less he can change the "Hours to save daily" column with the required hours.
Also if he decides to change the configuration of how long to save samples/hourly he can change these values as well.

Shirly
Comment 7 Laura Novich 2014-10-02 09:20:47 UTC 
Suggestion resulting from various meetings with Shirly, Arthur and SBR-Virt:
1. Put into the docs a XREF to a Kbase article about the reporting tool.

2. I will work with Shirly to make the database reporting calculator spreadsheet more user friendly.

3. You or I (Lucy or me) will create the KBase Article that describes the topic and the tool.

4. Once posted to the portal the calculator tool itself will reside in the labs section of the portal https://access.redhat.com/labs/

Lucy if you have any questions please ask me!

Laura
Comment 12 Andrew Hecox 2014-11-27 14:30:01 UTC 
adding Dong to the BZ. His team will build the tool and he can share when they'll start and what timelines we think it'll take to get them done.
Comment 13 Dong Zhao 2014-12-01 02:27:32 UTC 
Hi Allan, Lucy and Shirly,

Yes. My team will build this tool.  Can you let us know your timeline, so that I can arrange proper resource to work on the tool?

Thanks,
Dong
Comment 14 Shirly Radco 2014-12-01 14:02:34 UTC 
This should be ready for 3.5.
Comment 15 Dong Zhao 2014-12-02 02:02:06 UTC 
(In reply to Shirly Radco from comment #14)
> This should be ready for 3.5.

RHEV 3.5 is in beta now. what's the target date for release?
Comment 16 Shirly Radco 2014-12-03 10:03:39 UTC 
Created attachment 964073 [details]
History DB size estimate
Comment 17 Shirly Radco 2014-12-03 10:05:27 UTC 
The spreadsheet has been modified.
Please contact me if you need more info.
Comment 19 Shirly Radco 2014-12-15 10:02:43 UTC 
Created attachment 968873 [details]
History DB size estimate
Comment 20 Dong Zhao 2015-03-04 01:26:06 UTC 
The tool is released and can be accessed from this URL:
https://access.redhat.com/labs/rhevmhdsc/

Closing the bug.