# Problem with MySQL database

**URL:** <https://community.bloomreach.com/t/problem-with-mysql-database/2608>\
**Category:** Experience Manager (PaaS/OnPrem)\
**Created:** [June 7, 2021, 2:13pm UTC](https://community.bloomreach.com/t/problem-with-mysql-database/2608 "2021-06-07T14:13:51Z")\
**Posts on this page:** 2\
**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, 2:13pm UTC](https://community.bloomreach.com/t/problem-with-mysql-database/2608/1 "2021-06-07T14:13:51Z")

</div>

Hello ,

I am having a problem in the DEV development environment. To put it in context, the cms has programmed a call through Kafka in which it listens for incoming events and records in the cms if they are new. We have had a problem with the maximum capacity of the database and have changed the read and write permissions to read only. We have observed the cms and there are no cloned documents, nor large capacity files … and in the database we observe that the following table has registered up to 2 million lines, but I do not know what relationship this field has with the documents of Bloomreach. My doubt comes because I do not relate that table with the information that I keep in the cms and it comes through kafka.

![MicrosoftTeams-image (1)](https://canada1.discourse-cdn.com/flex027/uploads/bloomreach1/original/2X/c/ccf9195dbfbf4411257728ae1f30b1ffbfe86cdf.jpeg)

 ![MicrosoftTeams-image](https://canada1.discourse-cdn.com/flex027/uploads/bloomreach1/original/2X/0/05aa45997b804a2947316502a3b0d151806f5085.jpeg)

I do not understand what record is being stored since we have controlled the records that enter us and we do not understand what relationship it has with the massive load of data that is in the database.

Thank you so much

---

<div class="post-metadata">

**Author:** ![machak](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/machak/32/1298_2.png) [@machak](https://community.bloomreach.com/u/machak)\
**Post date:** [June 7, 2021, 2:44pm UTC](https://community.bloomreach.com/t/problem-with-mysql-database/2608/2 "2021-06-07T14:44:32Z")

</div>

datastore contains all documents/images/assets…  
for some more info, @woonsanko wrote a nice analysis about datastore:

> **[Apache Jackrabbit Database Usage Patterns and Options to Reduce Database size](http://woonsanko.blogspot.com/2018/11/apache-jackrabbit-database-usage.html)**
>
> Recently, I wrote about how to externalize version storage to an SFTP server backend to reduce database size:  https://woonsanko.blogspot.co...