AnsweredAssumed Answered

How to tune UMP with MySQL DB

Question asked by rschiller2 on Jun 8, 2018
Latest reply on Jun 11, 2018 by rschiller2

We are using UIM with MySQL database and have performance problems with UMP. I found suggestion to tune, but all of it applies for MY SQL Database. Has anybody experience how to tune the MySQL Database?

One observation is - the database folder contains very large number of files - abour 100 times as many as tables in the database. Also, the mysql probe is reporting "too many temporary tables". I wonder if all this has an influence on the UMP performance?

Also, we use custom-made (external) CABI dashboards, to invoke them in UMP take ages - has anybody experience how to tune this?

Many thanks