Others on this list may be able to direct you to an oVirt tool / script for the job, otherwise I believe there's an option in the installer/updater to vacuum the engine and/or datastore databases.

From: ziyi Liu <lzy19930211@gmail.com>
Sent: 13 March 2024 08:21
To: users@ovirt.org <users@ovirt.org>
Subject: [ovirt-users] The table in the database is too large

numa_node 6.39GB
vds_interface_statistics 3.08GB
vm_statistics 2.64GB
vds_statistics 1.72GB
vm_interface_statistics 1.54GB
audit_log 1.44GB
disk_image_dynamic 1.22GB
vm_dynamic 1GB
These tables basically have more than 200 rows, how should I reduce the data?
I have 111 hosts and 175 virtual machines
_______________________________________________
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/3FHOSWBN2DWH2RD5EGHU3RBVZXCKEA26/