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
Hi, You probably need to vacuum the database. 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/3FHOSWBN2DWH2R...
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@gmail.com> Sent: Wednesday, March 13, 2024 5:22 AM To: users@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@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://urldefense.com/v3/__https://www.ovirt.org/privacy-policy.html__;!!AC... oVirt Code of Conduct: https://urldefense.com/v3/__https://www.ovirt.org/community/about/community-... List Archives: https://urldefense.com/v3/__https://lists.ovirt.org/archives/list/users@ovir...
participants (3)
-
Brett Maton -
Marcos Sungaila -
ziyi Liu