• 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

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.

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

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...

160 views 0 4
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