Bamboo home page takes long to load

[Alex Gabrielian]

Our Bamboo instance has about 1000 plans on the bamboo home page ($BAMBOO_URL/allPlans.action). Every time we visit this page, it takes anywhere from 20-30 seconds to fully load. I know there is a filter feature to list only the projects you filter out but our team uses pretty much each project. Is there a way to make this load more instantaneously each time we visit?

[cbenard1]

Hi Alex,

For starters let's make sure that Bamboo has been allocated enough memory. You can do so by looking at the Bamboo Install Dir/bin/setenv.sh or setenv.bat depending on your host OS (please see here for full details). You'll want to make sure this is configured above the default 256/384.

Additionally as Daniel has mentioned it could be DB performance. Postgres is our recommended DB so we're good there. However with that many plans you may want to up the number of DB connections from Bamboo to your DB. You can do this by upping the connection pool on your DB side and editing the <Bamboo Home Directory>/bamboo.cfg.xml so the <property name="hibernate.c3p0.max_size">100</property> is increased. The number of threads can be determined by the formula found here.

If everything is looking good and you're still hitting performance issues please create a support ticket at https://support.atlassian.com and we'll take a closer look!

Thanks!

Turner

[Alex Gabrielian]

Hi Turner, will this change require a full bamboo/postgres restart or is it applied upon change?

[cbenard1]

Hi Alex,

These changes will require a restart to take effect. If you're needing to up the thread count in your postgres instance to accommodate the large number of consumed threads (not always necessary) then you may need a restart as well, but just making the change to Bamboo should not require a restart of postgres.

Best of luck!

Turner 

[Alex Gabrielian]

We're using PostGres and Bamboo version 5.7.2. I have not looked at the database performance. What are the steps to do that and how do we analyze the performance?

[Daniel Wester]

I would look for long running queries. It might be that you're missing an index or something. You should probably put in a support.atlassian.com issue as well

[Daniel Wester]

What database and bamboo version are you using? Have you looked at the database performance?