Hi Sohail,
so a few questions, you upgraded from which version? is the /var partition
increased once after upgrade, or it keeps increasing every day?
In general we recommend configuring DWH+Greafana on a separate (remote)
machine, docs: Installing and Configuring Data Warehouse on a Separate
Machine
<https://ovirt.org/documentation/data_warehouse_guide/index.html#Installing_and_Configuring_Data_Warehouse_on_a_Separate_Machine_DWH_admin>
.
Thanks,
Aviv
On Mon, Aug 29, 2022 at 4:24 PM <sohail_akht...@hotmail.com> wrote:
> Hi,
>
> We have recently upgrade our oVirt environment to 4.5.2 version.
> Environment is based on hosted-engine. Since we have upgrade we noticed
> rapid incrase in /var partition in engine VM. It is increasing very
> rapidly. If we vacuum ovirt_engine_history db, /var size reduces but next
> day size will increase again upto 5-10%. We did db vacuuming couple of time
> but not sure we it is increasing so rapidly.
> Here is the partial output of vacuuming that was done on 26-08-22. Table
> "host_interface_hourly_history" had more entries to be removed. Rest of the
> table had not much entries. Previously table
> "host_interface_samples_history" had entries to be removed.
> Any Idea what can be the reason for that?
>
> # dwh-vacuum -f -v
> SELECT pg_catalog.set_config('search_path', '', false);
> vacuumdb: vacuuming database "ovirt_engine_history"
> RESET search_path;
> SELECT c.relname, ns.nspname FROM pg_catalog.pg_class c
> JOIN pg_catalog.pg_namespace ns ON c.relnamespace OPERATOR(pg_catalog.=)
> ns.oid
> LEFT JOIN pg_catalog.pg_class t ON c.reltoastrelid OPERATOR(pg_catalog.=)
> t.oid
> WHERE c.relkind OPERATOR(pg_catalog.=) ANY (array['r', 'm'])
> ORDER BY c.relpages DESC;
> SELECT pg_catalog.set_config('search_path', '', false);
> VACUUM (FULL, VERBOSE) public.host_interface_samples_history;
> INFO: vacuuming "public.host_interface_samples_history"
> INFO: "host_interface_samples_history": found 3135 removable, 84609901
> nonremovable row versions in 1564960 pages
> DETAIL: 0 dead row versions cannot be removed yet.
> CPU: user: 41.88 s, system: 14.93 s, elapsed: 422.83 s.
> VACUUM (FULL, VERBOSE) public.host_interface_hourly_history;
> INFO: vacuuming "public.host_interface_hourly_history"
> INFO: "host_interface_hourly_history": found 252422 removable, 39904650
> nonremovable row versions in 473269 pages
>
> Please let me know if any further information is required.
>
> Regards
> Sohail
> _______________________________________________
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/privacy-policy.html
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/users@ovirt.org/message/VD2ROVZY2TOLZHSK4HWHEENRP7BQLRYI/
>
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/KGKIWTX4C7VAUMHBPLRXVVT5R2ALBL2W/
