Table glpi_logs is huge

albertus · 2012-10-17 12:03:44

Hi,

After a look to the BD, I see that the glpi_logs table keeps growing over time, there isn't any king of cleaning. I've tried the cleanhistory.php, which cleans the table, but it grows again. I've enabled and executed the 'logs' task but it doesn't make any difference. Is there any setting to limit the maximum age of entries in glpi_logs, or disable logging?

remi · 2012-10-17 18:15:03

Yes this table is huge, by design.

But having millions of entry should not be an issue.

albertus · 2012-10-17 23:19:56

It is an issue to me, as the DB size is above 1GB, and the backups take a long time to complete. Furthermore, it requires manual mainteinance from time to time (to clean the table). Another problem is the long time that a db optimization takes.

I think that a new task to rotate these entries would be the finest solution here.

Last edited by albertus (2012-10-17 23:20:52)

emilio · 2012-10-24 22:16:41

In my case I think the problem is the plugin FusioninventoryAgent, it create a new record whit the same info (old_value = new_value)

ddurieux · 2012-10-24 22:39:39

Can you copy one of these lines?

Version of GLPI?

Version of plugins FusionInventory?

emilio · 2012-10-25 13:00:17

GLPI version = 0.80.7
FusionInventory plugins = 0.80+1.1

exemple of lines:
old_value = {"INVENTORY":"v2.1.8-1"} new_value    = {"INVENTORY":"v2.1.8-1"}
old_value = {"INVENTORY":"v2.1.9-2"} new_value    = {"INVENTORY":"v2.1.9-2"}
old_value = {"INVENTORY":"v2.1.9-3"} new_value    = {"INVENTORY":"v2.1.9-3"}
old_value = {"INVENTORY":"v2.1.11-1"} new_value    = {"INVENTORY":"v2.1.11-1"}

ddurieux · 2012-10-25 13:14:06

It has been fixed (moe than 6 months ago) in the fixes version 0.80+1.3 of plugins fusioninventory

albertus · 2012-10-25 14:07:44

I don't use fusioninventory. In my case, almost all rows come from user_name=massocsimport or cron_ocsng (a mix from both)

emilio · 2012-10-25 17:09:24

I have to upgrade to a newer version of the plugin.

Can you help to clean the database, its there a SQL sintax that I can use?

many thanks for you help ddurieux

emilio · 2012-10-26 20:35:23

What do you think about this syntax for clear database ?

SELECT * FROM `glpi`.`glpi_logs` where user_name = 'Plugin_FusionInventory'
and old_value = new_value and linked_action = '0';

emilio · 2012-10-28 15:51:17

<RemiFedora> help with this: "there is a script to clean the glpi_logs"
https://forge.indepnet.net/projects/glp … istory.php
so i try and do : "php cleanhistory.php --type=12 --delay=0" it only return 306 entries

but if I use
SELECT count(user_name) as Plugin_FusionInventory from glpi_logs
where old_value = new_value and linked_action = "0";

it return 173062 entries, what do you think?

Forum GLPI-Project

Announcement

#1 2012-10-17 12:03:44

Table glpi_logs is huge

#2 2012-10-17 18:15:03

Re: Table glpi_logs is huge

#3 2012-10-17 23:19:56

Re: Table glpi_logs is huge

#4 2012-10-24 22:16:41

Re: Table glpi_logs is huge

#5 2012-10-24 22:39:39

Re: Table glpi_logs is huge

#6 2012-10-25 13:00:17

Re: Table glpi_logs is huge

#7 2012-10-25 13:14:06

Re: Table glpi_logs is huge

#8 2012-10-25 14:07:44

Re: Table glpi_logs is huge

#9 2012-10-25 17:09:24

Re: Table glpi_logs is huge

#10 2012-10-26 20:35:23

Re: Table glpi_logs is huge

#11 2012-10-28 15:51:17

Re: Table glpi_logs is huge

Board footer