Just run the DB vacuum scripts:
/usr/share/ovirt-engine/bin/engine-vacuum.sh -a -f -v
/usr/share/ovirt-engine-dwh/bin/dwh-vacuum.sh -a -f -v
You may want to change options, check its help descriptions.
Marcos
-----Original Message-----
From: ziyi Liu <lzy19930211(a)gmail.com>
Sent: Wednesday, March 13, 2024 5:22 AM
To: users(a)ovirt.org
Subject: [External] : [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(a)ovirt.org
To unsubscribe send an email to users-leave(a)ovirt.org Privacy Statement:
https://urldefense.com/v3/__https://www.ovirt.org/privacy-policy.html__;!...
oVirt Code of Conduct:
https://urldefense.com/v3/__https://www.ovirt.org/community/about/communi...
List Archives:
https://urldefense.com/v3/__https://lists.ovirt.org/archives/list/users@o...