Database growth due to large Events table in Cloud Director

Products

• VMware Cloud Director

Issue/Introduction

The database for Cloud Director is growing rapidly and has exceeded the default size multiple times. This behavior is typically observed when the Events table becomes excessively large due to the retention of historical data.

Environment

 

• Product: VMware Cloud Director

• Component: Database / Events Table

 

Cause

By default, VMware Cloud Director is configured to retain events for 90 days (vcloud.eventsKeepDays). In environments with high activity, this 90-day retention period can cause the Events table to grow at a rate that exceeds available database storage.

Resolution

You can resolve this issue by reducing the number of days events are kept in the database using the cell-management-tool.

1. Log in to the Cloud Director cell using SSH as root.

2. List the current value to verify the existing configuration:

   /opt/vmware/vcloud-director/bin/cell-management-tool manage-config -n com.vmware.vcloud.eventsKeepDays -l
   

3. Set a new value (e.g., 30 days) to reduce the retention period:

   /opt/vmware/vcloud-director/bin/cell-management-tool manage-config -n com.vmware.vcloud.eventsKeepDays -v [number_of_days]
   

   Replace [number_of_days] with your desired retention period.

Note: A restart of the Cloud Director services is not required for this change to take effect.

Additional Information

 

• For issues related to database maintenance and storage, it is recommended to subscribe to this knowledge article to receive updates on best practices.

• If you require further assistance with database performance, please refer to the Contact Support page.