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?