You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2020-01-07 17:14:14

widget007
Member
Registered: 2020-01-07
Posts: 1

Lenteurs page Ordinateurs à cause du champ IP

Bonjour,

J'aurais besoin d'aide pour débugguer des lenteurs d'affichage au niveau de la page Ordinateurs.
En retirant la colonne "IP" de la page, je n'ai plus de souci.

J'ai tenté de supprimer les nombreuses IP à "0.0.0.0" pour n'avoir que les vraies IP sur cette page mais sans succès.
En mode debug, c'est la requête suivante qui prend 3.6 secondes.

SELECT 'MyUserName' AS currentuser, `glpi_computers`.`name` AS ITEM_0, `glpi_computers`.`id` AS ITEM_0_2, `glpi_states`.`completename` AS ITEM_1, `glpi_computers`.`serial` AS ITEM_2, `glpi_manufacturers`.`name` AS ITEM_3, `glpi_users`.`name` AS ITEM_4, `glpi_users`.`realname` AS ITEM_4_2, `glpi_users`.`id` AS ITEM_4_3, `glpi_users`.`firstname` AS ITEM_4_4, `glpi_computertypes`.`name` AS ITEM_5, `glpi_computermodels`.`name` AS ITEM_6, `glpi_operatingsystems`.`name` AS ITEM_7, `glpi_computers`.`date_mod` AS ITEM_8, `glpi_locations`.`completename` AS ITEM_9, `glpi_entities`.`completename` AS ITEM_10, `glpi_computers`.`contact` AS ITEM_11, GROUP_CONCAT(DISTINCT CONCAT(`glpi_ipaddresses_4a5b2c0a661787d86d5c94fd78dfbfff`.`name`,'$$',`glpi_ipaddresses_4a5b2c0a661787d86d5c94fd78dfbfff`.`id`) SEPARATOR '$$$$') AS ITEM_12, `glpi_computers`.`id` AS id 
FROM `glpi_computers`
LEFT JOIN `glpi_states` ON (`glpi_computers`.`states_id` = `glpi_states`.`id` )
LEFT JOIN `glpi_manufacturers` ON (`glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id` )
LEFT JOIN `glpi_users` ON (`glpi_computers`.`users_id` = `glpi_users`.`id` )
LEFT JOIN `glpi_computertypes` ON (`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`id` )
LEFT JOIN `glpi_computermodels` ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id` )
LEFT JOIN `glpi_operatingsystems` ON (`glpi_computers`.`operatingsystems_id` = `glpi_operatingsystems`.`id` )
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id` )
LEFT JOIN `glpi_entities` ON (`glpi_computers`.`entities_id` = `glpi_entities`.`id` ) 
LEFT JOIN `glpi_items_devicenetworkcards` ON (`glpi_computers`.`id` = `glpi_items_devicenetworkcards`.`items_id` AND `glpi_items_devicenetworkcards`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_networkports` AS glpi_networkports_1006b9c36acb1b209506af6cc85ea8e5 ON (`glpi_computers`.`id` = `glpi_networkports_1006b9c36acb1b209506af6cc85ea8e5`.`items_id` AND `glpi_networkports_1006b9c36acb1b209506af6cc85ea8e5`.`itemtype` = 'Computer' ) 
LEFT JOIN `glpi_networknames` AS glpi_networknames_1c35f844286c802e0cbde4560b5d579e ON (`glpi_networkports_1006b9c36acb1b209506af6cc85ea8e5`.`id` = `glpi_networknames_1c35f844286c802e0cbde4560b5d579e`.`items_id` AND `glpi_networknames_1c35f844286c802e0cbde4560b5d579e`.`itemtype` = 'NetworkPort' AND `glpi_networknames_1c35f844286c802e0cbde4560b5d579e`.`is_deleted` = 0 ) 
LEFT JOIN `glpi_ipaddresses` AS glpi_ipaddresses_4a5b2c0a661787d86d5c94fd78dfbfff ON (`glpi_networknames_1c35f844286c802e0cbde4560b5d579e`.`id` = `glpi_ipaddresses_4a5b2c0a661787d86d5c94fd78dfbfff`.`items_id` AND `glpi_ipaddresses_4a5b2c0a661787d86d5c94fd78dfbfff`.`itemtype` = 'NetworkName' AND `glpi_ipaddresses_4a5b2c0a661787d86d5c94fd78dfbfff`.`is_deleted` = 0 ) 
WHERE `glpi_computers`.`is_deleted` = '0' AND `glpi_computers`.`is_template` = '0' AND ( `glpi_computers`.`entities_id` IN ('31') ) GROUP BY `glpi_computers`.`id` 
ORDER BY ITEM_8 DESC LIMIT 0, 100

Sans le champ IP, on a la requête suivante en 0.1 seconde :

SELECT 'MyUserName' AS currentuser, `glpi_computers`.`name` AS ITEM_0, `glpi_computers`.`id` AS ITEM_0_2, `glpi_states`.`completename` AS ITEM_1, `glpi_computers`.`serial` AS ITEM_2, `glpi_manufacturers`.`name` AS ITEM_3, `glpi_users`.`name` AS ITEM_4, `glpi_users`.`realname` AS ITEM_4_2, `glpi_users`.`id` AS ITEM_4_3, `glpi_users`.`firstname` AS ITEM_4_4, `glpi_computertypes`.`name` AS ITEM_5, `glpi_computermodels`.`name` AS ITEM_6, `glpi_operatingsystems`.`name` AS ITEM_7, `glpi_computers`.`date_mod` AS ITEM_8, `glpi_locations`.`completename` AS ITEM_9, `glpi_entities`.`completename` AS ITEM_10, `glpi_computers`.`contact` AS ITEM_11, `glpi_computers`.`id` AS id 
FROM `glpi_computers`
LEFT JOIN `glpi_states` ON (`glpi_computers`.`states_id` = `glpi_states`.`id` )
LEFT JOIN `glpi_manufacturers` ON (`glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id` )
LEFT JOIN `glpi_users` ON (`glpi_computers`.`users_id` = `glpi_users`.`id` )
LEFT JOIN `glpi_computertypes` ON (`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`id` )
LEFT JOIN `glpi_computermodels` ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id` )
LEFT JOIN `glpi_operatingsystems` ON (`glpi_computers`.`operatingsystems_id` = `glpi_operatingsystems`.`id` )
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id` )
LEFT JOIN `glpi_entities` ON (`glpi_computers`.`entities_id` = `glpi_entities`.`id` ) 
WHERE `glpi_computers`.`is_deleted` = '0' AND `glpi_computers`.`is_template` = '0' AND ( `glpi_computers`.`entities_id` IN ('31') ) 
ORDER BY ITEM_8 DESC LIMIT 0, 100

Le problème n'était pas présent quelques jours auparavant.
Y aurait-il des liens KO dans la BDD ? Une autre cause ?

Merci d'avance pour votre aide,
Guillaume.

---
Version 0.84.8

Offline

Board footer

Powered by FluxBB