BMC - Best performance tuning steps for YellowFin.

Asif Bhat shared this question 23 months ago
Answered

What are the best performance tuning steps for YellowFin.

Any Application and DB cleanup steps ?

Configurations we can look at ?

Comments (10)

photo
1

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

photo
1

You are awesome Nathan.

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

And yes I am from BMC Remedy Team.

photo
1

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

Nathan

photo
1

Please keep this discussion open for few more days.

photo
1

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.

photo
1

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

photo
1

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

photo
1

Hi Asif,

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

5a7a2a1aa4082b16aa5379587072bfaa

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.

518452e8cff7ba3e94109ca67a90b65e

Let me know if this makes sense.

Regards,

Nathan

photo
1

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

photo
1

No problem! Closing