BMC - Best performance tuning steps for YellowFin.

Hi Asaf,

Quick question, are you with BMC remedy or another division?

Regarding maintenance, this is a pretty broad question with a few answers:

On active instances, the configuration database can become quite large, making any query Yellowfin runs against it slower. This primarily will affect the reportinstance, event, and event archive tables (usage information that is gathered quickly, and serves; mostly to display usage statistics):

https://community.yellowfinbi.com/knowledge-base/article/why-is-my-yellowfin-database-so-large-and-what-can-i-do-about-it

Clustering is always a good bet for very large instances. As the load increases you can increase the size of your cluster. See attachment in this link for a complete guide:

https://community.yellowfinbi.com/knowledge-base/article/does-yellowfin-handle-session-replication-for-clustering

JVM and caching are another couple of settings worth looking at:

https://community.yellowfinbi.com/knowledge-base/article/yellowfin-internal-cache-options

https://www.yellowfinbi.com/resources/forum/yfforum-jvm-max-memory-thread-90378

Hopefully these get you started, let me know if you have any specific questions.

Regards,

Nathan

You are awesome Nathan.

I will go through these links and will let you know.

And yes I am from BMC Remedy Team.

Sounds good. Let me know if you have any questions.

Nathan

Please keep this discussion open for few more days.

Will do, it will be set to "Awaiting reply".

As an FYI, even closed cases can be re-opened. The second you reply to a case, no matter the status , it will show up in our "needs response" list.

Perfect. Then please set it to resolved. I will reply on this if I need any help.

Regarding below link can you please provide me the sample web.xml file having the parameters added.

Also what would be the value of the parameters for best performance.

https://community.yellowfinbi.com/knowledge-base/article/yellowfin-internal-cache-options

Hi Asif,

All of these parameters will go inside of the MIStartup servlet, and as an example, the reportCache is already being set here:

Regarding what to set these to..The best way to tell this is to navigate to the info_cache.jsp page and look through what is currently being cached. If any of your caches have high miss rates (>10-20%) and have stored up to their maximum values, then you will want to increase that cache size. In this example, the event cache is hitting >90% of the time, and only a small portion of the max cache size is being used(1%). This does not need to be increased.

Let me know if this makes sense.

Regards,

Nathan

This can be completed. Thanks a lot for your help.

No problem! Closing