Destroy ps_guest - ps_page_viewed - ps_search_index

[iamtheboss]

We have these stats

ps_guest  35,351,672 4.8 GiB

ps_page_viewed 30,244,454 1.5 GiB

ps_search_index  9,223,233 716.0 MiB

We can destroy something and if yes how ?

Thanks

[juanrojas]

hello, in case it helps you, take a look at this module, it will clean your database and you can make a cron job so that it does it every x time

[iamtheboss]

And for do it by hand ? Your module destroy only after x time ? We want to keep the last 10 days or maybe people get temporarly order loss.

 

Thanks

[El Patron]

On 5/11/2023 at 6:42 PM, iamtheboss said:

And for do it by hand ? Your module destroy only after x time ? We want to keep the last 10 days or maybe people get temporarly order loss.

 

Thanks

yes, we feel same, for clean module we want to be able to say keep some amount of days trailing.  I don't know  that module exists that supports this important feature.

[Mediacom87]

Like this : https://www.prestatoolbox.com/administrative-tools/457-automate-the-cleaning-of-your-prestashop-store.html

[El Patron]

5 minutes ago, Mediacom87 said:

Like this : https://www.prestatoolbox.com/administrative-tools/457-automate-the-cleaning-of-your-prestashop-store.html

Hey!  thanks for that info....if I understand correctly the retention period is global for all candidate clean ups yes?

if yes, having a separate retention by db table would be useful for us and our clients.  

If you agree, please let me know when available, I'll buy one for each client, we don't reuse developers modules across all clients.

[Mediacom87]

Il y a 2 heures, PrestaHeroes USA a dit :

Hey!  thanks for that info....if I understand correctly the retention period is global for all candidate clean ups yes?

if yes, having a separate retention by db table would be useful for us and our clients.  

If you agree, please let me know when available, I'll buy one for each client, we don't reuse developers modules across all clients.

For automatic tasks, the module allows to define a different delay for the tabs proposing data identifiable by dates.
What are the scenarios that would justify a different delay and therefore separate cron tasks?

[juanrojas]

En 12/5/2023 a las 1:42 AM, iamtheboss dijo:

And for do it by hand ? Your module destroy only after x time ? We want to keep the last 10 days or maybe people get temporarly order loss.

 

Thanks

x time means that you can replace x with whatever you want, either a day of the month or a specific time, this is programmed from the server

[iamtheboss]

We want simply to do a clear by hand one time, we have totally full database and we want to clear all the past except for example the last 30 days

ps_guest  35,351,672 4.8 GiB

ps_page_viewed 30,244,454 1.5 GiB

ps_search_index  9,223,233 716.0 MiB

This is really to much big, how we can destroy this by hand ?

ps pageview and ps guest we can destroy without any issue correct ?

Edited May 14, 2023 by iamtheboss (see edit history)

[iamtheboss]

Ok we buy this module and we have really good increase in performance, only negative thing is the website get totally blocked during the clean, but we have really big data to delete, so was normal.

The only question is:

ps_page_viewed  29,353,922 - 1.5 GiB

How we can clear this table ? We don't have find any option in your module for lean this.

Thanks

 

Edited May 16, 2023 by iamtheboss (see edit history)

[juanrojas]

hello, I think this table should also be present in the module, write a ticket to the people of the module to see if they can include it

[Mediacom87]

Il y a 9 heures, iamtheboss a dit :

How we can clear this table ? We don't have find any option in your module for lean this.

My module already allows you to do this and by limiting the data retention time, you can gradually reduce the tables by reducing this time without blocking the store.