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?

[Dinesh Kumar]

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

[Tanuj Chawla]

Hi 

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

Can you please help.

Thanks in advance.

Tanuj Chawla

[Chris Solgat]

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.