Assigning permissions to a page and People Directory performance is slow due to database latency
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
Assigning permissions to a page and browsing the People Directory is very slow.
Responses for cached pages are faster.
Browsing for content and other Confluence operations are fast.
Page profiling logs shows several calls with long completion times similar to:
1[6586ms] - UserStatusManager.getUserStatus()
Cause
If Confluence is running slowly, one of the most likely cause is that there is some kind of bottleneck in (or around) the database.
First, check is the "Database Latency" field in the System Information tab in the admin console.
The latency is calculated by sending a trivial request to the database by querying a table which is known to have only one column and one row:
1
select * from CLUSTERSAFETY;
Tthis query should be blazing fast and return within 1 or 2 milliseconds. If the value displayed is consistently between 3 and 5 milliseconds, it may require attention. If the value is above 10ms, then there is definitely a need to investigate and improve this performance!
Latency is just the very first thing to look at. The latency may be zero, but Confluence is still encountering numerous database problems, e.g. if your tables are poorly indexed.
Resolution
Database performance issues are outside the scope of Atlassian support, and should be addressed locally by a database administrator.
Was this helpful?