Satura la base de datos y la CPU

Hi @ricardorvm,

We’re very sorry you didn’t enjoy using Burst. We would love to solve the problems you are facing and provide a better product for the WordPress community.

Could you provide some more information regarding the problem? Did the server crash immediately after installing our plugin?

Kind regards
Hessel

Hola:

Os puedo dar ya pocos datos, porque he borrado el plugin y las tablas de la base de datos.

Lo que ocurrió fue lo siguiente:

1. Instalé el plugin en julio y empecé a recpilar datos.
2. a lo largo de estos meses he ido viendo las estadisticas y todo bien. Paralelamente, noté que el consumo de CPY del sevidor se iba incrementando, pero no lo achaqué al plugin. Ultimamente, el consumo estaba bastante alto, pero no lolaccionaba con el plugin.
3. El pasado viernes, tuve un pico de visitas, que se incrementó el sábado y el domingo. El servidor qudó practicamente paralizado. Consulté con el servicio tecnico y me dijeron que había muchisimas consultas a la base de datos desde el plugin.
4. Vi con phpmyadmin que habia una tabla que pesaba 1 Giga, y era una de las tablas del plugin. La borré y desinstalé el plugin y ahopra todo va bien. El consumo de CPY ha recuperado los niveles previso al mes de junio, que es cuando instalé el plugin.
5. La web dinde tenia el plugin no es una web peque?a. tiene entre 2.000 y 3.000 visitas diarias de lunes a vierntes, y los sabados y domingos puede aumentar de 15.000 a 30.000 visitas.

Un saludo.

Hola @ricardorvm,

Thank you for taking the time to provide us with detailed feedback. We’re genuinely sorry to hear about the issues you’ve faced.

Concerning CPU consumption, it’s important to note that any locally hosted analytics plugin, including ours, will result in more CPU usage because each visitor’s actions have to be logged. For websites with large traffic volumes like yours, this can add up.
In addition, the nature of locally hosted analytics means that the database will inevitably grow over time as more visitor data gets stored. This is a trade-off for the increased privacy and control that local hosting offers.

We are continually working to optimize Burst’s performance and are focusing on reducing database sizes. In fact, we already have an archiving function that should help manage the database size over time.

We have plans for an upcoming version that can be installed on a separate server. This will ensure that the CPU of your main website is not affected by our plugin.

We regret that you’ve had to uninstall our plugin. However, your insights are invaluable to us as we strive to make Burst better.

If you value handling user data privacy on your own server and wish to contribute to our free, open-source project, we would be happy to collaborate with you on a solution for your specific use case.

Kind regards,
Hessel

• This reply was modified 1 year ago by Hessel de Jong.