PM - Mysql .ibd files filling in the disk space

Products

• CA Performance Management - Usage and Administration

Issue/Introduction

The disk is being filled up and the biggest contributors are .ibd files (events) that seem to come from Mysql db in CAPC (../mysql/data/em directory), eg:

mysql  mysql  2.9G  /opt/CA/MySql/data/em/event_properties#P#p20210427.ibd
mysql  mysql  3.4G  /opt/CA/MySql/data/em/event_properties#P#p20210428.ibd
mysql  mysql  2.6G  /opt/CA/MySql/data/em/event_properties#P#p20210429.ibd
mysql  mysql  4.7G  /opt/CA/MySql/data/em/events_l10n#P#p20210427.ibd
mysql  mysql  5.7G  /opt/CA/MySql/data/em/events_l10n#P#p20210428.ibd
mysql  mysql  4.4G  /opt/CA/MySql/data/em/events_l10n#P#p20210429.ibd
mysql  mysql  1.2G  /opt/CA/MySql/data/em/events#P#p20210427.ibd
mysql  mysql  1.4G  /opt/CA/MySql/data/em/events#P#p20210428.ibd

Environment

Any

Cause

By default, the Event Manager database retains events for 30 days.
How long it stores, or retains, events by modifying the Event.Retention property. 

Resolution

There is an attribute called Event.Retention (/opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/em.properties file) in the Event Manager database that controls the event retention settings.

By reducing the Event.Retention (30 days by default) it should remove .ibd files older than the specified retention setting and therefore it should free disk space, eg:

db.driverClassName=com.mysql.jdbc.Driver
db.timeout=120
db.maxActive=40
rib.queryTimeout=100
em.ws.maxqueue=50
Event.Retention=15 
db.url=jdbc\:mysql\://localhost\:3306/em?useUnicode\=true&characterEncoding\=UTF-8

Once the Event.Retention is updated we would need to wait until midnight for mysql db reperiodization to occur and should take care of the old .ibd files accordingly.

 

Additional Information

Change Event Properties

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/22-2/using/events/change-event-properties.html