Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Gathering Confluence Statistics to Implement DevOps Administration Edited

We're trying to set our Confluence installation and administration up in more of a devops capacity. Part of the process is to define KPIs that let us know how well the app is performing. It seems a lot of this data just needs to be pulled directly from the database via SQLs. A lot of the SQLs provided when searching seem to be related to older versions of Confluence. Even the official Atlassian docs at https://confluence.atlassian.com/disc/administration-tips/obtaining-confluence-instance-metrics are woefully out of date. An example is the SQLs referencing the ATTACHMENTS table, but that was removed in 5.7 (I think). Can anyone provide useful SQLs for modern Confluence versions (6.x perferably)? Other methods of gathering statistics are welcome, but I'd like to avoid anything that requires purchasing a plugin for that specific use case. Thanks

1 answer

0 votes
Daniel Eads Atlassian Team Nov 19, 2018

Hey Doug,

Let's break this out into a few different things -

Application Server (Java / DB) Performance:
An application performance monitor like NewRelic or AppDynamics will get you a ton of info about the JVM itself - heap usage, garbage collection stats, etc. in addition to basic info about the host (free/used memory, CPU, etc). It's worth checking one of these out if you're serious about performance monitoring.

Both these tools can check on what SQL queries are being run to give you hints on if there's any plugins running that might be doing things in an unoptimized way. In a previous role as an admin, I was actually able to use the DB performance tools in NewRelic to track down a single misconfigured Confluence macro that was causing an entire Confluence instance to slow down when a particular page loaded.

JMX Monitoring:
Confluence (and Jira) come with some stats enabled for export via JMX connector. You enable this in your Confluence config, and then you can attach to the Confluence server stats by running JConsole on your local machine. Check out the document for details on the types of things you can measure with JMX.

Confluence statistics:
Many of these can be pulled via the free SpaceAuditor plugin. Things you can pull include:

  • Pages in a space
  • Attachments in a space
  • Size of attachments
  • Number of contributors
  • Age of pages
  • Most modified/least modified

etc. - you get the idea!

If there are any specific Confluence-usage stats you're interested in retrieving via SQL, let me know what those are and we can work together on making sure those are 6.x-friendly queries.

Cheers,
Daniel

Hi Daniel,

We're trying to gather global statistics specific to Confluence itself. I'm familiar with ways to get OS/app/db performance info, but we're being pushed to go even further and provide metrics business stakeholders can relate to. It's also to help us create a history of data to see if we can find any trends or identify issues during irregularities to be notified of issues before users encounter them. A couple of items that come to mind are:

  • Total number of newly created pages in X timeframe
  • Total number of pages updated within X timeframe
  • Total number of pages viewed within X timeframe
  • Total number of new attachments uploaded within X timeframe

I'm open to any other suggestions as to useful data relevant to the Confluence app specifically. Thanks

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in DevOps

Step up your DevOps game webinar Q&A series - Questions answered!

  On October 21st, 2020 we hosted a webinar titled,   Step Up You DevOps Game with 4 Key Integrations for Jira and Bitbucket. We had a great showing and high engagement, but that meant th...

117 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you