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/