 | In this set of pages on Investigating A Slow Confluence Installation - Version 3.3.1, I document the steps I took to try and identify slow running operations on my copy of Confluence 3.3.1. I recently added about 10K pages and labels for an EGW topical index, roughly doubling the number of pages (not not total size of content). This should account for the recent slowdowns and non-responsive Confluence that I have seen.
In this set of topics I discuss how I examined the database, stack dumps, dealt with Confluence hangs, logged bugs with the vendor, examined robot activity, and took other defensive measures to keep my copy of Confluence running. Please let me know if these topics helped you run your copy of Conflunece. You can use the "Add comment" on any of these pages to let me know. Please include your email addres in your comment, I will keep a copy of your email so we can correspond about Confluence, but quickly remove it from the comment you place here. |
Here are the top times reported for this operation:
2010-09-10 16:13:25,861 DEBUG [http-8080-7] [atlassian.util.profiling.UtilTimerStack] log [10399ms] - /display/cdsprivate/Status+and+needs+for+progress+-+2010-09-10
[0ms] - UserAccessor.getUser()
[5269ms] - SiteMesh: parsePage: http://www.bobsgear.com/display/somespace/Status+and+needs+for+progress+-+2010-09-10
[5266ms] - XW Interceptor: Before defaultStack: /pages/viewpage.action (ViewPageAction.execute())
[5124ms] - XW Interceptor: After defaultStack: /pages/viewpage.action (ViewPageAction.execute())
[5124ms] - XW Interceptor: After validatingStack: /pages/viewpage.action (ViewPageAction.execute())
[5044ms] - XW View: doExecute(/pages/viewpage.vm)
[5043ms] - ApplyDecoratorDirective.render()
[5040ms] - ApplyDecoratorDirective.render()
[4269ms] - NotificationManager.getNotificationByUserAndPage()
[0ms] - NotificationManager.getNotificationByUserAndSpace()
[0ms] - PermissionManager.hasPermission()
[1ms] - NotificationManager.getNotificationByUserAndPage()
[46ms] - NotificationManager.getNotificationByUserAndSpace()
[0ms] - NotificationManager.getNotificationByUserAndPage()
[0ms] - NotificationManager.getNotificationByUserAndPage()
[1ms] - NotificationManager.getNotificationByUserAndSpace()
[5105ms] - SiteMesh: applyDecorator: main (doctheme/decorators/main.vmd)
[1ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getUser()
[0ms] - MessageManager.getMessages()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[1ms] - SpaceManager.getPersonalSpace()
[0ms] - SpaceManager.getPersonalSpace()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getUser()
[1ms] - UserAccessor.getUser()
[1ms] - UserAccessor.getUser()
[1ms] - SpaceManager.getLogoForSpace()
The long timing for NotificationManager.GetNotificationbyuserandpage seems like a fluke, since others were executing quickly.
No clue as to what within SiteMesh:applydecorator was taking so long.
Here is the raw info:
2010-09-10 16:13:25,861 DEBUG [http-8080-7] [atlassian.util.profiling.UtilTimerStack] log [10399ms] - /display/cdsprivate/Status+and+needs+for+progress+-+2010-09-10
[0ms] - UserAccessor.getUser()
[5269ms] - SiteMesh: parsePage: http://www.bobsgear.com/display/somespace/Status+and+needs+for+progress+-+2010-09-10
[5266ms] - XW Interceptor: Before defaultStack: /pages/viewpage.action (ViewPageAction.execute())
[0ms] - UserAccessor.getPropertySet()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - SpaceAwareInterceptor.intercept()
[69ms] - PageAwareInterceptor.intercept()
[68ms] - PageManager.getPage()
[1ms] - PermissionManager.hasPermission()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[1ms] - UserAccessor.isSuperUser()
[1ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - CommentAwareInterceptor.intercept()
[0ms] - UserAwareInterceptor.intercept()
[0ms] - BootstrapAwareInterceptor.intercept()
[0ms] - UserAccessor.getUser()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[5124ms] - XW Interceptor: After defaultStack: /pages/viewpage.action (ViewPageAction.execute())
[5124ms] - XW Interceptor: After validatingStack: /pages/viewpage.action (ViewPageAction.execute())
[24ms] - WikiStyleRenderer.convertWikiToXHtml()
[1ms] - Rendering macro: {note}
[1ms] - PageManager.getPage()
[0ms] - SpaceManager.getSpace()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[1ms] - PageManager.getPage()
[0ms] - SpaceManager.getSpace()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PageManager.getPage()
[0ms] - SpaceManager.getSpace()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PageManager.getPage()
[0ms] - SpaceManager.getSpace()
[1ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[5044ms] - XW View: doExecute(/pages/viewpage.vm)
[0ms] - XW View: getTemplate(/pages/viewpage.vm)
[5043ms] - ApplyDecoratorDirective.render()
[0ms] - SpaceManager.getSpace()
[0ms] - UserAccessor.getUser()
[5040ms] - ApplyDecoratorDirective.render()
[0ms] - UserAccessor.getUser()
[2ms] - WikiStyleRenderer.convertWikiToXHtml()
[2ms] - Rendering macro: {pagetree}
[0ms] - SpaceManager.getSpace()
[0ms] - WikiStyleRenderer.convertWikiToXHtml()
[0ms] - WikiStyleRenderer.convertWikiToXHtml()
[0ms] - WikiStyleRenderer.convertWikiToXHtml()
[0ms] - PermissionManager.hasPermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - PermissionManager.hasPermission()
[1ms] - PermissionManager.hasCreatePermission()
[1ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - PermissionManager.hasCreatePermission()
[1ms] - UserAccessor.isSuperUser()
[1ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[4269ms] - NotificationManager.getNotificationByUserAndPage()
[0ms] - NotificationManager.getNotificationByUserAndSpace()
[0ms] - PermissionManager.hasPermission()
[1ms] - NotificationManager.getNotificationByUserAndPage()
[46ms] - NotificationManager.getNotificationByUserAndSpace()
[0ms] - NotificationManager.getNotificationByUserAndPage()
[0ms] - NotificationManager.getNotificationByUserAndPage()
[1ms] - NotificationManager.getNotificationByUserAndSpace()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[1ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasPermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - UserAccessor.getUserProfilePicture()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[1ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getUser()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getUser()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[1ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getConfluenceUserPreferences()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - FormatSettingsManager.getDateFormat()
[0ms] - FormatSettingsManager.getDateTimeFormat()
[0ms] - FormatSettingsManager.getTimeFormat()
[0ms] - FormatSettingsManager.getDayFormat()
[0ms] - FormatSettingsManager.getDateFormat()
[0ms] - FormatSettingsManager.getDateTimeFormat()
[10ms] - PageManager.getPageByVersion()
[0ms] - WikiStyleRenderer.convertWikiToXHtml()
[2ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[39ms] - ApplyDecoratorDirective.render()
[0ms] - SpaceManager.getSpace()
[0ms] - UserAccessor.getUser()
[37ms] - ApplyDecoratorDirective.render()
[1ms] - SpaceManager.getSpace()
[0ms] - UserAccessor.getUser()
[1ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[0ms] - PermissionManager.hasPermission()
[0ms] - PermissionManager.hasPermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[5105ms] - SiteMesh: applyDecorator: main (doctheme/decorators/main.vmd)
[1ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getUser()
[0ms] - MessageManager.getMessages()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - UserAccessor.isSuperUser()
[0ms] - com.atlassian.user.impl.delegation.properties.DelegatingPropertySetFactory_delegating_getPropertySet(admin)
[1ms] - SpaceManager.getPersonalSpace()
[0ms] - SpaceManager.getPersonalSpace()
[0ms] - PermissionManager.hasCreatePermission()
[0ms] - UserAccessor.getUser()
[0ms] - UserAccessor.getUser()
[1ms] - UserAccessor.getUser()
[1ms] - UserAccessor.getUser()
[1ms] - SpaceManager.getLogoForSpace()
Labels:
None
Add Comment