Problem with mysql database | table REPOSITORY_JOURNAL

Experience Manager (PaaS/OnPrem)
1

Hello,

I am trying to follow the following manual:
https://documentation.bloomreach.com/14/library/enterprise/installation-and-configuration/repository-maintenance.html

I have problems with the deletion when executing the DELETE statement, it is taking a long time to delete only one REVISION_ID, why?

Thank you

2

Perhaps some other running repository node is trying to update it at the same time?

3

no, only that process is running

MicrosoftTeams-image (2)
MicrosoftTeams-image (2)1660×384 15.8 KB

4

REPOSITORY_JOURNAL table is usually big. And the where clause with NOT LIKE will probably make it slow, too.