Software inventory very slow after update

Snippie · 2010-10-20 12:14:19

I just update from 0.72.4 to 0.78.
The update went OK and everything seems to work.
But when I go to inventory - software it takes up to 1 minute before I see something.
Before the update is was 2 - 3 seconds.
There are about 3000 entries in the software and I only display 20 items.
And not just the first load. Even when I go the next page.
This is with IE8.
With FF 3.6.10 nothing will be displayed.

OpenSuse 11.1
GLPI updated from 0.72.4 to 0.78
MYSQL 5.0.67
PHP 5.2.6
Apache 2.2.10

Regards

wawa · 2010-10-20 12:19:20

hello
can you check the logs ?
are you sure there's no cron job running (like cron sending emails) ?

Snippie · 2010-10-20 14:15:24

Hello

I checked the logs but I do not see anything strange in it.

What I notice when I am working in the new version the CPU usage is about 5%.

When I click Inventory - Software the CPU usage goes to 99%, all used by mysql.

When I check mysql I see:

-----------------
show full processlist\G
*************************** 1. row ***************************
Id: 6
User: root
Host: localhost
db: glpi
Command: Query
Time: 41
State: Copying to tmp table
Info: SELECT `glpi_softwares`.`entities_id`, `glpi_softwares`.`is_recursive`, `glpi_softwares`.`name` AS ITEM_0,
`glpi_softwares`.`id` AS ITEM_0_2, `glpi_manufacturers`.`name` AS ITEM_1, GROUP_CONCAT(DISTINCT `glpi_softwareversions`.`name` SEPARATOR '$$$$') AS ITEM_2, `glpi_operatingsystems`.`name` AS ITEM_3, `glpi_softwarecategories`.`name` AS ITEM_4, COUNT(DISTINCT `glpi_computers_softwareversions`.`id`)
AS ITEM_5, FLOOR(SUM(`glpi_softwarelicenses`.`number`)
* COUNT(DISTINCT `glpi_softwarelicenses`.`id`)
/ COUNT(`glpi_softwarelicenses`.`id`)) AS ITEM_6,
MIN(`glpi_softwarelicenses`.`number`) AS ITEM_6_2, `glpi_softwares`.`id` AS id FROM `glpi_softwares` LEFT JOIN `glpi_manufacturers` ON (`glpi_softwares`.`manufacturers_id` = `glpi_manufacturers`.`id`) LEFT JOIN `glpi_softwareversions` ON (`glpi_softwares`.`id` = `glpi_softwareversions`.`softwares_id`) LEFT JOIN `glpi_operatingsystems` ON (`glpi_softwares`.`operatingsystems_id` = `glpi_operatingsystems`.`id`) LEFT JOIN `glpi_softwarecategories` ON (`glpi_softwares`.`softwarecategories_id` = `glpi_softwarecategories`.`id`)
LEFT JOIN `glpi_computers_softwareversions`
ON (`glpi_softwareversions`.`id` = `glpi_computers_softwareversions`.`softwareversions_id`) LEFT JOIN `glpi_softwarelicenses`
ON (`glpi_softwares`.`id` = `glpi_softwarelicenses`.`softwares_id` ) WHERE `glpi_softwares`.`is_deleted` = '0' AND `glpi_softwares`.`is_template` = '0' GROUP BY `glpi_softwares`.`id` ORDER BY ITEM_0 ASC LIMIT 0, 20
-----------------

Regards

sean.tapscott · 2010-10-20 18:18:43

Try using debug mode as well, should tell you which query takes all of the time.

Snippie · 2010-10-21 09:30:52

Hello

In debug mode I see the query below takes all the time. 106.936s of the total 106.996s.

--------------------
SELECT `glpi_softwares`.`entities_id`, `glpi_softwares`.`is_recursive`, `glpi_softwares`.`name` AS ITEM_0, `glpi_softwares`.`id` AS ITEM_0_2, `glpi_manufacturers`.`name` AS ITEM_1, GROUP_CONCAT(DISTINCT `glpi_softwareversions`.`name` SEPARATOR '$$$$') AS ITEM_2, `glpi_operatingsystems`.`name` AS ITEM_3, `glpi_softwarecategories`.`name` AS ITEM_4, COUNT(DISTINCT `glpi_computers_softwareversions`.`id`) AS ITEM_5, FLOOR(SUM(`glpi_softwarelicenses`.`number`) * COUNT(DISTINCT `glpi_softwarelicenses`.`id`) / COUNT(`glpi_softwarelicenses`.`id`)) AS ITEM_6, MIN(`glpi_softwarelicenses`.`number`) AS ITEM_6_2, `glpi_softwares`.`id` AS id
FROM `glpi_softwares`
LEFT JOIN `glpi_manufacturers` ON (`glpi_softwares`.`manufacturers_id` = `glpi_manufacturers`.`id`)
LEFT JOIN `glpi_softwareversions` ON (`glpi_softwares`.`id` = `glpi_softwareversions`.`softwares_id`)
LEFT JOIN `glpi_operatingsystems` ON (`glpi_softwares`.`operatingsystems_id` = `glpi_operatingsystems`.`id`)
LEFT JOIN `glpi_softwarecategories` ON (`glpi_softwares`.`softwarecategories_id` = `glpi_softwarecategories`.`id`)
LEFT JOIN `glpi_computers_softwareversions` ON (`glpi_softwareversions`.`id` = `glpi_computers_softwareversions`.`softwareversions_id`)
LEFT JOIN `glpi_softwarelicenses` ON (`glpi_softwares`.`id` = `glpi_softwarelicenses`.`softwares_id` )
WHERE `glpi_softwares`.`is_deleted` = '0' AND `glpi_softwares`.`is_template` = '0' GROUP BY `glpi_softwares`.`id`
ORDER BY ITEM_0 ASC LIMIT 0, 20
--------------------

Regards

remi · 2010-10-21 09:51:10

Remove some columns... (Number of installations, Number of licenses).

+

Snippie · 2010-10-21 12:24:27

Hello

Yes that was the problem.
Removing the columns 'Number of installations' and 'Number of licenses' and it is shown within 2 seconds.

thanks

yllen · 2010-10-21 15:46:34

Perfect. I close

Forum GLPI-Project

Announcement

#1 2010-10-20 12:14:19

Software inventory very slow after update

#2 2010-10-20 12:19:20

Re: Software inventory very slow after update

#3 2010-10-20 14:15:24

Re: Software inventory very slow after update

#4 2010-10-20 18:18:43

Re: Software inventory very slow after update

#5 2010-10-21 09:30:52

Re: Software inventory very slow after update

#6 2010-10-21 09:51:10

Re: Software inventory very slow after update

#7 2010-10-21 12:24:27

Re: Software inventory very slow after update

#8 2010-10-21 15:46:34

Re: Software inventory very slow after update

Board footer