Forum GLPI-Project

vosido

Member

Registered: 2016-08-05

Posts: 2

Problem table log very big

HI ,

I use GLPI 0.90.5.

When i want to create a ticket it's very long .

i see on the database glpi a big table (log table).

I search a script or plugin for purge the log but i don't found this.

Can you help me please to purge the log table .

thanks

Best regards

vosido

Member

Registered: 2016-08-05

Posts: 2

Re: Problem table log very big

nobody have any idea please ?

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Problem table log very big

In Tools directory (https://github.com/glpi-project/glpi/tr … ixes/tools) you have a script to clean this (cleanhistory.php)
At the beginning of this file you have the usage of it

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

willianmgrocha

Member

From: Brazil

Registered: 2014-10-22

Posts: 75

Re: Problem table log very big

In Tools directory (https://github.com/glpi-project/glpi/tr … ixes/tools) you have a script to clean this (cleanhistory.php)
At the beginning of this file you have the usage of it

Hi,

Thanks for tip, i would ike to knos you have some examples for clear all log > 1 month, best regards.

Willian Rocha

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Problem table log very big

php cleanhistory.php  --item=Computer  --type=1 --delay=1
=> you will see all computer with device added older than 1 month.
If you add --run=1 the glpi_logs will be clean for this request

If you just indicated php cleanhistory.php  --delay=1 it will clean all history older than 1 month

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)