GLPI- how to spedup performance

caimano68 · 2008-02-22 10:38:57

Hello, I have a question about performance!.
We are 6 technicians that works with glpi. We have find that glpi often freezes for a few seconds ( 10 /15) before processing requests. This problem is more visible using search in dropdown, or when we click to start query.
I don't know if the problem is in GLPI or in our installation but if you have some suggestion I can try to find the problem.
thanks in advance.
Mariano

P.S.
_ Our GLPI Installation is a vmware esx virtual machine with 1,4gb of ram - ubuntu 6.06 - apache2 - php5 - mysql - glpi 0.7.2 - OCS 1.0.1 - clients Explorer and Firefox -- only glpi and ocs are on this machine.

remi · 2008-02-22 12:47:50

What is the size of your database ?

How many computers, entities, ...

Have you enable "ajax" ?

...

caimano68 · 2008-02-22 13:16:57

Thanks for your response:

remi wrote:

What is the size of your database ?

I don't know correct command for this in mysql - on filesystem the database is 11MB

remi wrote:

How many computers, entities, ...

We have about 300 computers inventoried and 10 entity

remi wrote:

Have you enable "ajax" ?
...

Yes we have enabled it. I have just reduced the ajax consumptio ( I believe) in configuration.
I attach our config

glpi_config image

THe links don't works correctly please copy and paste the url...

Last edited by caimano68 (2008-02-22 13:22:33)

remi · 2008-02-22 14:06:57

What is the frequence of this freeze ?

Can you note date/time and check the log to see what happen then (you should enable the log to file in configuration => glpi/_files/log).

I'm thinking of a cron start which lock some tables...

++

caimano68 · 2008-02-22 14:31:42

remi wrote:

What is the frequence of this freeze ?
Can you note date/time and check the log to see what happen then (you should enable the log to file in configuration => glpi/_files/log).
I'm thinking of a cron start which lock some tables...
++

In cron.log file i find that we have many request

can you see this attachment? theese are only the requests that system start today. I don't know if are correct
cron log 22-2-08

thanks for your help

remi · 2008-02-22 14:54:15

Many request : it's OK.

You need to check if there is a correlation between freeze and event in log.

++

caimano68 · 2008-02-22 15:53:27

ok Thanks for your help If i find correlation i call you again

JMD · 2008-02-22 16:03:35

Is the cache enable on glpi ?

It's possible also that your mysql config or php.ini are not optimal

caimano68 · 2008-02-22 18:03:35

Yes the cache is enabled..

For mysql/php config where I can find information about better parameters?
thansk

Forum GLPI-Project

Announcement

#1 2008-02-22 10:38:57

GLPI- how to spedup performance

#2 2008-02-22 12:47:50

Re: GLPI- how to spedup performance

#3 2008-02-22 13:16:57

Re: GLPI- how to spedup performance

#4 2008-02-22 14:06:57

Re: GLPI- how to spedup performance

#5 2008-02-22 14:31:42

Re: GLPI- how to spedup performance

#6 2008-02-22 14:54:15

Re: GLPI- how to spedup performance

#7 2008-02-22 15:53:27

Re: GLPI- how to spedup performance

#8 2008-02-22 16:03:35

Re: GLPI- how to spedup performance

#9 2008-02-22 18:03:35

Re: GLPI- how to spedup performance

Board footer