Forum GLPI-Project

andreas8ghz

Member

Registered: 2016-06-22

Posts: 22

shrink database size

We use GLPI 91.1 with FusionInventory for our inventory management since one year. Actually +1000 Assets with daily inventory. Ticketing is actually not implemented(Work in progress)
Our database have a size of 4,1GB and the table glpi_logs is 3,9GB large. I think the most data in this table are the history of the inventoring.

Is it possible to purge the old data from inventory? In example that we only want to have the state of the last 6 months.

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: shrink database size

You have a file: cleanhistory.php in https://github.com/glpi-project/glpi/tr … ixes/tools to clean your glpi_logs from event and object.
You have an example of use at the beginning or the file

---

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)

andreas8ghz

Member

Registered: 2016-06-22

Posts: 22

Re: shrink database size

Thanks for the quick response!