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.

Thanks,
Aviv

On Mon, Aug 29, 2022 at 4:24 PM <sohail_akhter3@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-leave@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/