Forum GLPI-Project

gcamacho

Member

From: Quito - Ecuador

Registered: 2006-06-21

Posts: 36

GLPI Response time

I have some problems with the response time of my GLPI installations; with the new version 0.70.2 the delay is considerable.

When I synchronize with OCS, make backups or create a new ticket, the system doesn't respond for a long time.

My database has 10.8 MB and the index 8 MB, when I make a backup the file have 20 MB and all days it increase.

When I use the utility plugin to purge the computers I receive the following error: Incorrect key file for table '.\glpi\glpi_computers.MYI'; try to repair it
To solve it I run the fololowing command: mysqlcheck --auto-repair -uroot -ppassword GLPI glpi_computers

What can I do to solve the response time and optimize my database?

I will appreciate your answer, thank you for your help

gcamacho

Member

From: Quito - Ecuador

Registered: 2006-06-21

Posts: 36

Re: GLPI Response time

One think more, my SQL Dump have 20.793 KB and it grow 700 KB in a day.

Really I need help.

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: GLPI Response time

Please : http://glpi-project.org/forum/viewtopic.php?id=5651

Also the sync process with ocs is heavy. it's better to do sync by  little packet of computers for example.

You could also limit the log in configuration to limit the size of your db

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

wawa

GLPI-DEV

From: Montpellier / France

Registered: 2006-07-03

Posts: 6,019

Website

Re: GLPI Response time

you may disable use of internal cron and use the mass_ocs_import plugin instead... don't know if it may help