Hi,
Do we have metrics on the MySQL process VM Size load on a server hosting the IAM DB for a medium/large sized EPM implementation using IDP?
On a given setup (currently monitoring over 600k Cable Modems) we have a 9GB VM Size load for the MySQL process, and we were wondering if this is normal or if it can be brought down.
Thank you
The amount of memory MySQL takes is configurable, i would say it depends on the size of the MySQL DB to decide how large the VM Size needs to be
if you have only a couple of GB of data i would say 2 GB is enough
If you have 20-50 GB of data somewhere between 2-9GB can be advised.
The major advantage of a lot of memory is the process to clean up the data, if a table can be inserted entirely in memory it goes significantly faster, so this could also be an indication on how large your VM size should be