How to Remove "cloud.alert" and "cloud_usage.cloud_event" Tables in the Cloud Database

This article describes how to remove cloud_usage.cloud.usage??tables in the Cloud Database.

Background

The "cloud.alert" and "cloud_usage.cloud_usage" table in the CloudPlatform database can grow large over a period of time. However, this might not cause any issues in day-to-day operations but in some scenarios, for example during an upgrade, the large number of records might cause the upgrade to take significantly longer (in hours) to complete.

Complete the following steps to remove the tables:

1. Open the database dump of CloudPlatform??databases.

   mysqldump -u<user> -p<password> -h<hostname> -P<port> cloud > cloud.dump

   mysqldump -u<user> -p<password> -h<hostname> -P<port> cloud_usage > cloud_usage.dump

2. Stop the cloud usage service.

   Note: This is an optional step.

   service cloud-usage stop

3. Truncate "cloud_usage.cloud_usage" table.

   truncate table cloud_usage.cloud_usage;

   Note: Do not run this query when the usage job is running. Usage job executes as per the schedule set in the global config.

4. Start the cloud usage service if you have stopped the service in Step 2.

   service cloud-usage start

5. Stop the cloud management service.

   Note: This is an optional step.

   ??service cloud-management stop

6. Truncate the "cloud.alert" table.

   truncate table cloud.alert;

7. Start the cloud management service??if you have stopped the service in Step 5.

   service cloud-management start