# Problem with mysql database | table REPOSITORY\_JOURNAL

**URL:** <https://community.bloomreach.com/t/problem-with-mysql-database-table-repository-journal/2609>\
**Category:** Experience Manager (PaaS/OnPrem)\
**Created:** [June 7, 2021, 4:39pm UTC](https://community.bloomreach.com/t/problem-with-mysql-database-table-repository-journal/2609 "2021-06-07T16:39:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![asanchez](https://avatars.discourse-cdn.com/v4/letter/a/46a35a/32.png) [@asanchez](https://community.bloomreach.com/u/asanchez)\
**Post date:** [June 7, 2021, 4:39pm UTC](https://community.bloomreach.com/t/problem-with-mysql-database-table-repository-journal/2609/1 "2021-06-07T16:39:41Z")

</div>

Hello,

I am trying to follow the following manual:  
[https://documentation.bloomreach.com/14/library/enterprise/installation-and-configuration/repository-maintenance.html](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

---

<div class="post-metadata">

**Author:** ![woonsanko](https://avatars.discourse-cdn.com/v4/letter/w/b5a626/32.png) [@woonsanko](https://community.bloomreach.com/u/woonsanko)\
**Post date:** [June 8, 2021, 9:59am UTC](https://community.bloomreach.com/t/problem-with-mysql-database-table-repository-journal/2609/2 "2021-06-08T09:59:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![asanchez](https://avatars.discourse-cdn.com/v4/letter/a/46a35a/32.png) [@asanchez](https://community.bloomreach.com/u/asanchez)\
**Post date:** [June 9, 2021, 10:53am UTC](https://community.bloomreach.com/t/problem-with-mysql-database-table-repository-journal/2609/3 "2021-06-09T10:53:38Z")

</div>

no, only that process is running

 ![MicrosoftTeams-image (2)](https://canada1.discourse-cdn.com/flex027/uploads/bloomreach1/original/2X/7/75bec49d06c5fc94f6c2dea3ad8f83c98f8966af.png)

---

<div class="post-metadata">

**Author:** ![woonsanko](https://avatars.discourse-cdn.com/v4/letter/w/b5a626/32.png) [@woonsanko](https://community.bloomreach.com/u/woonsanko)\
**Post date:** [June 9, 2021, 11:12am UTC](https://community.bloomreach.com/t/problem-with-mysql-database-table-repository-journal/2609/4 "2021-06-09T11:12:54Z")

</div>

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