Big tables in Openstack database Alarm

Products

• VMware Integrated OpenStack

Issue/Introduction

• When you run command: viocli check health -n mariadb you get an alarm:  "Big tables in Openstack database"
Name: vio health check 
+---------+----------+--------------------------------+
|  NAME   |  RESULT  |             ALARM              |
+---------+----------+--------------------------------+
| mariadb | Alarms:1 | Big tables in Openstack        |
|         | Passed:1 | database                       |
+---------+----------+--------------------------------+
| basic   | Passed:5 |                                |
+---------+----------+--------------------------------+
• viocli_health_check.log shows list of tables with move than 100k rows.
  Example
2022/07/20 10:07:57 mariadb.sh check_big_tables_in_database: Big tables in Openstack database: nova.instance_actions_events[154054], nova.instance_system_metadata[139914], nova.instance_actions[105930]
  
  

Environment

7.x

Cause

The database health script checks tables with rows over 100,000 records.

 

Note:  In general the tables we are concerned with are Nova, Glance, Cinder.  All others can be ignored, unless you are having a specific problem with the reported component.  If there are any concerns please contact Support.

Resolution

Warning: These procedures modify the database. Ensure to take a backup of the database before proceeding.

For Nova tables see VIO purge Nova database of deleted instances

For Glance tables see VMware Integrated Openstack Glance API Performance

For Cinder tables see VIO Cleanup soft deleted volumes

Additional Information

VMware Integrated OpenStack CLI Health Check Runbook