Massive storedhttpsessions table

[former_member633554]

Hi,

Using the session failover feature on hybris 6.7, we have a massive storedhttpsessions table. The table size is over 40GB, deleting data from it has no affect on the table size. So looks like some form of mysql fragmentation. We can run an optimize command on the table potentially but that requires some downtime. Has anyone had experience with this kind of issue?

[Private_Member_467521]

Hi leoryan,

That is addressed through Data Retention Framework, creating a cronjob.

SAP Note 2826384 has more details with an example.

https://launchpad.support.sap.com/#/notes/0002826384

For further reference, check the Help, in the Failover configuration, under the session invalidation section

https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/5da5660b2a3f4263ac3095d900d0...

Should this help to address you topic, please accept the answer.

Cheers,

Luis 🙂

[former_member633554]

Hi Luis, yes know about that job which does remove the data from the table but we are finding the table is not reducing in size when data is removed. It seems to be some mysql fragmentation type issue. Truncating the table fixes it instantly but i feel that is dangerous in a production environment and defeats the purpose of storing sessions that way.

[Private_Member_467521]

Hi Leo Ryan,

Definitely create a ticket with SAP to check upon that. This is not standard behavior.

Cheers,

Luis