Bug #17187
closedcache_hash gets filled up with menudata entries while using TMENU_LAYERS
0%
Description
Hi,
this bug has been introduced with release 4.x and is causing a mayor slowdown due to almost killing the database. Mayor impact on performance as well. Using TMENU_LAYERS results in about >40 new entries in cache_has with MENUDATA items each time a page is beeing rendered.
Having a cache_hash with 5.3GB ! in size and 5.706.563 entries in total, where 99% where 5.704.321 are of type MENUDATA the only solution right now is to empty cache_hash.
See additional information for typoscript example. It might be possible that this is related to heavy traffic on the frontend, so this happens not on every site.
Any help would be great ;)
Thanks
Matt
Example Code:
subparts.menu0 = HMENU
subparts.menu0.special = list
subparts.menu0.special.value = 20,27,28,26,25,6400,23,24,22
subparts.menu0.1 = TMENU_LAYERS
subparts.menu0.1 {
layerStyle = position:absolute; visibility:hidden;
lockPosition = x
relativeToParentLayer=1
relativeToTriggerItem=1
topOffset=152
leftOffset=150
hideMenuWhenNotOver = 50
hideMenuTimer = 70
expAll=1
noBlur=1
wrap = <table border="0" cellspacing="0" cellpadding="0" height="35"><tr>|</tr></table>
NO.allWrap = <td class="topnav" valign="middle"> | </td>
ACT = 1
ACT.allWrap = <td class="topnav_act" valign="middle"> | </td>
}
subparts.menu0.2 = TMENU_LAYERS
subparts.menu0.2 {
layerStyle = position:absolute; visibility:hidden;
lockPosition = x
relativeToParentLayer=1
relativeToTriggerItem=1
relativeToTriggerItem.addWidth = 1
hideMenuWhenNotOver=1
topOffset=-6
leftOffset=4
expAll=1
noBlur=1
wrap = <div class="smenu_box"><div class="smenu"><div class="smenu_link"><table border="0" cellspacing="0" cellpadding="0"><tr><tr><td nowrap align="right">|</td></tr></tr></table></div></div></div>
NO.ATagParams = class="ssml"
IFSUB = 1
IFSUB.ATagParams = class="ssml_arrow"
ACT = 1
ACT.ATagParams = class="ssml layernav_act"
ACTIFSUB = 1
ACTIFSUB.ATagParams = class="ssml_arrow layernav_act"
}
subparts.menu0.3 = TMENU
subparts.menu0.3 {
noBlur=1
wrap = <div class="ssmenu"><div class="smenu_box"><div class="smenu"><div class="smenu_link"><table border="0" cellspacing="0" cellpadding="0"><tr><tr><td nowrap align="right">|</td></tr></tr></table></div></div></div></div>
NO.ATagParams = class="ssml"
ACT = 1
ACT.ATagParams = class="ssml layernav_act"
}
(issue imported from #M5360)