Optimize the database - Upgrade PAM from 3.4.3 to 4.0.1

Products

• CA Privileged Access Manager (PAM)

Issue/Introduction

WE want to get Mysql database optimized before a massive upgrade of all PAM infrasctructure

Environment

Release : 4.0, 4.1.x

Component :

Cause

There are some tables that can be truncated 

Resolution

Open a case with support, support can help you to run some SQL commands to optimize database