• Community
  • Products
  • Marketplace Apps
  • Questions
  • How to generate the statistics from JIRA using Java melody plugin for HTTP sessions, Active JDBC connections, used JDBC connections, SQL hits per minute and SQL mean times?

How to generate the statistics from JIRA using Java melody plugin for HTTP sessions, Active JDBC connections, used JDBC connections, SQL hits per minute and SQL mean times?

Hi,

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.

Thank you,

Dinesh

2 answers

This widget could not be displayed.

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.

This widget could not be displayed.

Hi 

Even after following the same steps the graphs are still not getting generated.

Can you please help.

Thanks in advance.

Tanuj Chawla

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

425 views 3 17
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you