nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Slow "index.action"

Florian_qleefs

I am evaluating the latest greatest confluence version.

When I access my instance it is blazing fast (I get the start page of confluence in about a second). But when I don't access confluence for a few hours, it takes up to 10 seconds to load the start page.

I turned on the profiling and looked at the log. It looks like most of the time is spent on this action:

[4595ms] - XW Interceptor: Before defaultStack: /index.action (IndexAction.execute())

There are no sub-steps that would help to narrow down the problem.

I'm evaluating confluence in a docker container on an 8-core C2750 Atom-processor with 16GB RAM. Clearly, the processor is a limiting factor. But maybe there is a way to optimize confluence?

Does anyone have an idea? Is this CPU, RAM or IO related?

Accepted answers

All comments

AnnWorley

I understand you are evaluating Confluence 6.8.1 on a Docker instance. When you leave the instance idle for a few hours it takes a long time to load the landing page. Are you using the default landing page?

The only idea I have off the top of my head is that it probably isn't a load issue since you are the only user. That it is faster after you use it a few minutes indicates caching as a factor but it could be browser, OS or database caching.

There are a lot of suggestions on this page in case you have not seen it, could be a good place to start: Performance Tuning.

I look forward to hearing what you find.

Florian_qleefs

Thank you for your reply.

I think it's really a CPU issue. The C2750 (Atom based CPU) is really not performing well on confluence. I had a VPS on http://scaleway.com/ and also a local machine (with a C2750) and both performed equally bad. The 8 cpus are at 95-100% during the mentioned 10 second time window.

Now, on another VPS provider, I rented a VPS with 2x Intel Skylake and I don't have to wait 10 seconds anymore. It had reduced to 4-5 seconds, which I think is acceptable.

But honestly, I don't understand what confluence is doing during that time.

I am the only user on the instance, nobody else is using / evaluating it. Is there no possibility to just keep the cache for a longer period?

AnnWorley

I was only guessing about the caching based on your original post, but to help isolate the issue, please have a look at your cache statistics as described in Cache Performance Tuning.

Please also check the database server logs to see if there are any errors or slowness when accessing the database.

Another place to look for slow tasks is in the browser's developer console, especially the Network tab. For example, in Chrome's developer tools, Network tab, Size column shows whether the data is being loaded from memory cache, disk cache or the size of the file if it's pulled from the server: Screen Shot 2018-04-23 at 3.08.09 PM.png

Florian_qleefs

Yes, I have done that already. I checked both the Cache Performance Tuning page and the Performance Tuning page as well as the logs. The reason I'm posting here is exactely because the official guides do not cover that case.

According to these guides, the cache usage and effectiveness isn't really the problem (Not even speaking of the fact that an empty (!) instance shouldn't need to be "cache tuned", but that's a different story)..

I also already looked at the network tab and about 90% of the mentioned 10 second time window the browser is waiting for the first byte (ttfb).

Also, I tried both the integrated database and a Postgres database on a dedicated machine and both instances performed equally bad.

It is sad that an empty (!) instance of confluence consumes so much CPU power. The fact that I have to struggle with performance issues on an empty (!) installation already doesn't want me to continue anymore with confluence. I cannot afford to buy a higher VPS after adding a few pages...