clean logs

Changemanager · 2023-09-20 17:18:37

Hello.

h-ttps://forum.glpi-project.org/viewtopic.php?pid=503253#p503253

Taking into account what has been said above, I need to be able to delete more logs.

Is it possible to delete records directly from the BBDD in glpi_logs?

Can records in glpi_queuednotifications also be deleted manually, or are there dependencies?

Thank you.

LaDenrée · 2023-09-21 00:10:23

notification are sent to dustbin, once they are sent to user.

Set automatic action "queuednotificationclean" to purge notifications dustbin.

you can delete lines in glpi_logs table without any problem .

Changemanager · 2023-10-10 17:42:23

I don't see how to free up space in this table (glpi_queuednotifications); it just keeps growing and growing. I have the 'queuednotificationclean' automatic task enabled and a short retention, but in its log, it doesn't delete anything (-1 Action completed, no processing required). And no matter how many messages I manually delete from the sent items' trash, it just keeps growing endlessly.

Any idea what's happening? I'm on version 10.0.9."

29k rows for 5.3Gb...

thankyou

Last edited by Changemanager (2023-10-10 17:53:36)

LaDenrée · 2023-10-11 08:43:21

check if you have lot of free space in your table; if yes then optimize the table

show table status like "glpi_queuednotifications"

Forum GLPI-Project

Announcement

#1 2023-09-20 17:18:37

clean logs

#2 2023-09-21 00:10:23

Re: clean logs

#3 2023-10-10 17:42:23

Re: clean logs

#4 2023-10-11 08:43:21

Re: clean logs

Board footer