Java melody plugin is generating few statistics for JIRA like Used memory, % CPU, Active threads, HTTP hits per minute and HTTP mean times. But, it is not generating the statistics for HTTP sessions, Active JDBC connections, used JDBC connections, SQL hits per minute and SQL mean times.
Could anyone please help me to generate the same?
Your inputs would be much appreciated.
The short answer is to use a datasource connection instead of a direct jdbc connection. In your dbconfig.xml file, switch the settings to use the datasource. Then you will put your jdbc connection information into your conf/server.xml file. After you restart JIRA, you should now see your sql stats. Here's a link to configure a datasource – https://confluence.atlassian.com/display/JIRA043/Connecting+JIRA+to+MySQL#ConnectingJIRAtoMySQL-5.1.ConfigureyourapplicationservertoconnecttoMySQL
You WILL NOT modify the entityengine.xml, you will modify the dbconfig.xml file instead (assuming you are using a newer version of Jira. I know this is true since at least JIRA 6).
I am not sure why you're not getting your http sessions though, as they are not related to the sql setup. Did you turn off your access_log logging, during setup? That's about the only thing I can think of off of the top of my head for those.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs