Manual cleanup of nova-api database

Products

• VMware Integrated OpenStack
• VMware Telco Cloud Infrastructure

Issue/Introduction

• Cleanup using KB Purge Nova database of deleted instances did not clean up all nova-api database tables
• The tables taking the most space are identified:
  Ex.
MariaDB [nova_api]> SELECT table_name ,
    ->   round(((data_length + index_length) / 1024 / 1024), 2) as SIZE_MB
    -> FROM information_schema.TABLES
    -> WHERE table_schema = DATABASE() ORDER BY SIZE_MB DESC;
+------------------------------+---------+
| table_name                   | SIZE_MB |
+------------------------------+---------+
| request_specs                | 5000.00 |  
| instance_mappings            |  500.00 |

Environment

VIO: 7.x
TCI: 3.0

Resolution

Contact Broadcom support for assistance with corrective action.