Popular Label Macro incredibly slow since upgrade to 4.2.2

Since the Upgrade from 4.1.9 to 4.2.2 during the weekend, we suffer bad performance on the Popular Label Macro.

Having looked at it from the mysql side, the SQL Query which is executed by the Macro is very slow:

mysql> select label5_.LABELID as LABELID, label5_.NAME as NAME, label5_.OWNER as OWNER, label5_.NAMESPACE as NAMESPACE, label5_.CREATIONDATE as CREATION5_, label5_.LASTMODDATE as LASTMODD6_, label5_.LABELID as x0_0_, count(label5_.LABELID) as x1_0_ from CONTENT spaceconte0_, SPACES space1_, CONTENT_LABEL labelling2_ left outer join ATTACHMENTS attachment3_ on labelling2_.ATTACHMENTID=attachment3_.ATTACHMENTID left outer join CONTENT contentent4_ on labelling2_.CONTENTID=contentent4_.CONTENTID, LABEL label5_ where spaceconte0_.CONTENTTYPE in ('com.atlassian.confluence.pages.AbstractPage', 'USERSTATUS', 'PAGE', 'BLOGPOST', 'CUSTOM', 'MAIL', 'SPACEDESCRIPTION', 'com.atlassian.confluence.core.SpaceContentEntityObject') and labelling2_.LABELID=label5_.LABELID and ((label5_.NAMESPACE='global' and labelling2_.LABELID=label5_.LABELID)and((contentent4_.CONTENTID=spaceconte0_.CONTENTID )or(attachment3_.PAGEID=spaceconte0_.CONTENTID ))and(spaceconte0_.SPACEID=space1_.SPACEID )and(lower(space1_.SPACEKEY)='knowledgebase' )and((attachment3_.ATTACHMENTID is not null )or(contentent4_.CONTENT_STATUS!='deleted' ))) group by label5_.LABELID , label5_.NAMESPACE , label5_.OWNER , label5_.NAME , label5_.LASTMODDATE , label5_.CREATIONDATE order by count(label5_.LABELID)DESC limit 5;

+----------+-------+-------+-----------+---------------------+---------------------+----------+-------+

| LABELID | NAME | OWNER | NAMESPACE | CREATION5_ | LASTMODD6_ | x0_0_ | x1_0_ |

+----------+-------+-------+-----------+---------------------+---------------------+----------+-------+

| 3211278 | howto | NULL | global | 2011-11-23 12:54:13 | 2011-11-23 12:54:13 | 3211278 | 14 |

| 6619144 | cucm | NULL | global | 2011-11-30 15:32:19 | 2011-11-30 15:32:19 | 6619144 | 10 |

| 4685827 | cisco | NULL | global | 2011-11-25 19:07:52 | 2011-11-25 19:07:52 | 4685827 | 7 |

| 8290306 | uccx | NULL | global | 2011-12-05 22:43:31 | 2011-12-05 22:43:31 | 8290306 | 7 |

| 17465346 | ios | NULL | global | 2012-02-29 09:24:29 | 2012-02-29 09:24:29 | 17465346 | 6 |

+----------+-------+-------+-----------+---------------------+---------------------+----------+-------+

5 rows in set *(53.69 sec)*

mysql>

As you can see - needing 54 sec to complete the Query.

Other than that we don't really expierience any performance Issues with our Database.

Please advise.

1 answer

This widget could not be displayed.

Hi Christian,

Sorry to hear you experiencing such issue on your instance. We are aware of such issue and have created a bug report to discussed this issue

We highly recommend you to watch the mentioned bug so that you would be updated on it and please feel free to address your concern directly into it.

Hope the above information clarify your doubts.

Regards,
Septa Cahyadiputra

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

601 views 8 6
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you