You are not logged in.
Nous venons d'installer un GLPI 0.78 sur un maquette (travail remarquable soit dis en passant)...
Toute la plate-forme fonctionne correctement et nous continuons de découvrir les améliorations de cette pré-version...
Cependant, nous constatons une grosse lenteur à la création d'un ticket (plus de 30 sec).
En mode débug, nous constatons plus de 8200 requetes avant l'affichage un modèle de ticket vièrge.
Voici les informations ralatives à notre configuration:
Plate-forme WAMP 2.0i,
AJAX activé pour les liste de plus de 10 éléments,
Importation de plus de 2000 entités via un outil maison d'import MySQL,
Utilisateur glpi (super-admin),
Aucun ticket présent en base,
Aucun matériel en base,
Cordialement,
fbou
--------------------
GLPI version 0.72.4 / Plateforme LAMP.
Offline
envoie de mail activé ?
Vous n'auriez pas un probleme a ce niveau la ?
Offline
Bonjour,
Je viens de vérifier ma configuration pour les notifications et en effet elle n'était pas configurée.
Chose faite et le test d'envoi de message se passe très bien (0.098s).
Je relance un test de création de ticket et j'ai toujours des temps de réponse désastreux (29.318s).
SQL REQUEST : 8211 Queries took 29.318000000002s
N° Queries Time Errors
1 SHOW COLUMNS
FROM `glpi_tickets` 0.012
2 SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2' 0.003
3 SHOW COLUMNS
FROM `glpi_entities` 0.007
4 SELECT `sons_cache`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
5 SELECT `id`
FROM `glpi_entities`
WHERE `entities_id` = '0'
ORDER BY `name` 0.020
6 SELECT `id`
FROM `glpi_entities`
WHERE `entities_id` IN ...; 0.113
8 UPDATE `glpi_entities` SET `sons_cache`='...; 0.003
9 SHOW COLUMNS
FROM `glpi_entities` 0.006
10 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
11 SHOW COLUMNS
FROM `glpi_entities` 0.005
12 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '1001143' 0.002
13 SHOW COLUMNS
FROM `glpi_entities` 0.004
14 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '1000747' 0.002
15 SHOW COLUMNS
FROM `glpi_entities` 0.005
...
4076 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '7004431' 0.001
4077 SELECT COUNT(DISTINCT `glpi_users`.`id` ) AS cpt
FROM `glpi_users`
LEFT JOIN `glpi_profiles_users` ON (`glpi_users`.`id` = `glpi_profiles_users`.`users_id`)
WHERE `glpi_users`.`id` > '1' AND ( `glpi_profiles_users`.`entities_id` IN (...) ) AND `glpi_users`.`is_deleted` = '0' AND `glpi_users`.`is_active` = '1' AND `glpi_users`.`id` NOT IN (2) 0.014
4078 SELECT *
FROM `glpi_users`
WHERE `id`='2' 0.001
4079 SELECT *
FROM `glpi_entitydatas`
WHERE `entities_id` = '0' 0.001
....
8148 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '7004431' 0.001
8149 SELECT count(*) AS cpt
FROM glpi_entities
WHERE ( `glpi_entities`.`id` IN (...) ) 0.011
8150 SHOW COLUMNS
FROM `glpi_groups` 0.015
8151 SHOW COLUMNS
FROM `glpi_groups` 0.006
8152 SHOW COLUMNS
FROM `glpi_entities` 0.007
8153 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8154 SELECT count(*) AS cpt
FROM glpi_groups
WHERE ( `glpi_groups`.`entities_id` = '0' ) 0.001
8155 SHOW COLUMNS
FROM `glpi_groups` 0.006
8156 SHOW COLUMNS
FROM `glpi_entities` 0.006
8157 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8158 SELECT *
FROM `glpi_groups`
WHERE 1 AND `glpi_groups`.`id` NOT IN ('0') AND ( `glpi_groups`.`entities_id` = '0' )
ORDER BY `entities_id`, name 0.001
8159 SHOW COLUMNS
FROM `glpi_ticketcategories` 0.006
8160 SHOW COLUMNS
FROM `glpi_ticketcategories` 0.007
8161 SHOW COLUMNS
FROM `glpi_entities` 0.006
8162 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8163 SELECT count(*) AS cpt
FROM glpi_ticketcategories
WHERE ( `glpi_ticketcategories`.`entities_id` = '0' ) 0.001
8164 SHOW COLUMNS
FROM `glpi_ticketcategories` 0.006
8165 SHOW COLUMNS
FROM `glpi_entities` 0.006
8166 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8167 SELECT *
FROM `glpi_ticketcategories`
WHERE 1 AND `glpi_ticketcategories`.`id` NOT IN ('0') AND ( `glpi_ticketcategories`.`entities_id` = '0' )
ORDER BY entities_id, `completename` 0.001
8168 SELECT *
FROM `glpi_ticketcategories`
WHERE `id` = '0' 0.001
8169 SHOW COLUMNS
FROM `glpi_entities` 0.005
8170 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8171 SELECT COUNT(DISTINCT `glpi_users`.`id` ) AS cpt
FROM `glpi_users`
LEFT JOIN `glpi_profiles_users` ON (`glpi_users`.`id` = `glpi_profiles_users`.`users_id`)
LEFT JOIN `glpi_profiles` ON (`glpi_profiles`.`id` = `glpi_profiles_users`.`profiles_id`)
WHERE (`glpi_profiles`.`own_ticket`='1' AND ( `glpi_profiles_users`.`entities_id` = '0' ) AND `glpi_profiles`.`interface` = 'central' ) AND `glpi_users`.`is_deleted` = '0' AND `glpi_users`.`is_active` = '1' 0.002
8172 SHOW COLUMNS
FROM `glpi_entities` 0.005
8173 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.001
8174 SELECT DISTINCT `glpi_users`.*
FROM `glpi_users`
LEFT JOIN `glpi_profiles_users` ON (`glpi_users`.`id` = `glpi_profiles_users`.`users_id`)
LEFT JOIN `glpi_profiles` ON (`glpi_profiles`.`id` = `glpi_profiles_users`.`profiles_id`)
WHERE (`glpi_profiles`.`own_ticket`='1' AND ( `glpi_profiles_users`.`entities_id` = '0' ) AND `glpi_profiles`.`interface` = 'central' ) AND `glpi_users`.`is_deleted` = '0' AND `glpi_users`.`is_active` = '1'
ORDER BY `glpi_users`.`realname`, `glpi_users`.`firstname`, `glpi_users`.`name` 0.008
8175 SELECT *
FROM `glpi_entitydatas`
WHERE `entities_id` = '0' 0.001
8176 SELECT *
FROM `glpi_authldaps`
WHERE is_default=1 0.001
8177 SELECT *
FROM `glpi_requesttypes`
WHERE `id` = '1' 0.001
8178 SHOW COLUMNS
FROM `glpi_requesttypes` 0.005
8179 SELECT count(*) AS cpt
FROM glpi_requesttypes 0.002
8180 SHOW COLUMNS
FROM `glpi_requesttypes` 0.004
8181 SELECT *
FROM `glpi_requesttypes`
WHERE 1 AND `glpi_requesttypes`.`id` NOT IN ('1')
ORDER BY name 0.002
8182 SELECT *
FROM `glpi_requesttypes`
WHERE `id` = '1' 0.000
8183 SELECT *
FROM `glpi_requesttypes`
WHERE `id` = '1' 0.001
8184 SHOW COLUMNS
FROM `glpi_groups` 0.005
8185 SHOW COLUMNS
FROM `glpi_groups` 0.005
8186 SHOW COLUMNS
FROM `glpi_entities` 0.008
8187 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8188 SELECT count(*) AS cpt
FROM glpi_groups
WHERE ( `glpi_groups`.`entities_id` = '0' ) 0.001
8189 SHOW COLUMNS
FROM `glpi_groups` 0.005
8190 SHOW COLUMNS
FROM `glpi_entities` 0.006
8191 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.001
8192 SELECT *
FROM `glpi_groups`
WHERE 1 AND `glpi_groups`.`id` NOT IN ('0') AND ( `glpi_groups`.`entities_id` = '0' )
ORDER BY `entities_id`, name 0.001
8193 SHOW COLUMNS
FROM `glpi_computers` 0.008
8194 SELECT *
FROM `glpi_computers`
WHERE `users_id` = '2' AND `is_deleted` = '0' AND `is_template` = '0' AND ( `glpi_computers`.`entities_id` = '0' ) 0.001
8195 SHOW COLUMNS
FROM `glpi_softwares` 0.007
8196 SHOW COLUMNS
FROM `glpi_entities` 0.006
8197 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8198 SELECT *
FROM `glpi_softwares`
WHERE `users_id` = '2' AND `is_deleted` = '0' AND `is_template` = '0' AND `is_helpdesk_visible` = '1' AND ( `glpi_softwares`.`entities_id` = '0' ) 0.001
8199 SHOW COLUMNS
FROM `glpi_phones` 0.009
8200 SELECT *
FROM `glpi_phones`
WHERE `users_id` = '2' AND `is_deleted` = '0' AND `is_template` = '0' AND ( `glpi_phones`.`entities_id` = '0' ) 0.001
8201 SHOW COLUMNS
FROM `glpi_suppliers` 0.007
8202 SHOW COLUMNS
FROM `glpi_suppliers` 0.011
8203 SHOW COLUMNS
FROM `glpi_entities` 0.006
8204 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.002
8205 SELECT count(*) AS cpt
FROM glpi_suppliers
WHERE ( `glpi_suppliers`.`entities_id` = '0' ) 0.001
8206 SHOW COLUMNS
FROM `glpi_suppliers` 0.006
8207 SHOW COLUMNS
FROM `glpi_entities` 0.006
8208 SELECT `ancestors_cache`,`entities_id`
FROM `glpi_entities`
WHERE `id` = '0' 0.001
8209 SELECT *
FROM `glpi_suppliers`
WHERE 1 AND `is_deleted`='0' AND `glpi_suppliers`.`id` NOT IN ('0') AND ( `glpi_suppliers`.`entities_id` = '0' )
ORDER BY `entities_id`, name 0.001
8210 SELECT *
FROM `glpi_suppliers`
WHERE `id` = '0' 0.001
8211 SELECT `email`
FROM `glpi_users`
WHERE `id` ='2' 0.001
AUTOLOAD
Plugin, TicketFollowup, Ticket, Profile_User, Dropdown, CommonDropdown, CommonTreeDropdown, Entity, User, EntityData, AuthLdap, Group, TicketCategory, Profile, RequestType, Computer, NetworkEquipment, Printer, Monitor, Peripheral, Software, Phone, Supplier, CommonDBChild, TicketValidation
POST VARIABLE
KEY => VALUE
searchText => *
value => 0
itemtype => Group
myname => groups_id
limit => 50
comment => 1
rand => 205301151
entity_restrict => 0
update_item =>
used =>
auto_submit => 0
condition =>
emptylabel => -----
display_emptychoice => 1
GET VARIABLE
KEY => VALUE
id =>
SESSION VARIABLE
KEY => VALUE
glpi_plugins =>
glpicookietest => testcookie
glpi_use_mode => 2
glpiID => 2
glpiname => glpi
glpirealname =>
glpifirstname =>
glpidefault_entity => 0
glpiusers_idisation => 1
glpiextauth => 0
glpiauthtype => 1
glpiroot => /glpi-0.78-RC2
glpicrontimer => 1280739185
glpi_tabs => KEY => VALUE
central => 1
config => -1
notificationmailsetting => -1
ticket => 1
=> 1
preference => 1
glpidate_format => 1
glpidefault_requesttypes_id => 1
glpidropdown_chars_limit => 50
glpifollowup_private => 0
glpitask_private => 0
glpiis_categorized_soft_expanded => 1
glpiis_ids_visible => 0
glpiis_not_categorized_soft_expanded => 1
glpilanguage => fr_FR
glpilist_limit => 20
glpinumber_format => 2
glpipriority_1 => #fff2f2
glpipriority_2 => #ffe0e0
glpipriority_3 => #ffcece
glpipriority_4 => #ffbfbf
glpipriority_5 => #ffadad
glpipriority_6 => #ff5555
glpishow_jobs_at_login => 0
glpiuse_flat_dropdowntree => 0
glpiprofiles => KEY => VALUE
4 => KEY => VALUE
name => super-admin
entities => KEY => VALUE
2 => KEY => VALUE
id => 0
name =>
is_recursive => 1
glpiactiveprofile => KEY => VALUE
id => 4
name => super-admin
interface => central
is_default => 0
computer => w
monitor => w
software => w
networking => w
printer => w
peripheral => w
cartridge => w
consumable => w
phone => w
notes => w
contact_enterprise => w
document => w
contract => w
infocom => w
knowbase => w
faq => w
reservation_helpdesk => 1
reservation_central => w
reports => r
ocsng => w
view_ocsng => r
sync_ocsng => w
dropdown => w
entity_dropdown => w
device => w
typedoc => w
link => w
config => w
rule_ticket => w
entity_rule_ticket => w
rule_ocs => w
rule_ldap => w
rule_softwarecategories => w
search_config => w
search_config_global => w
check_update => r
profile => w
user => w
user_authtype => w
group => w
entity => w
transfer => w
logs => r
reminder_public => w
bookmark_public => w
backup => w
create_ticket => 1
delete_ticket => 1
add_followups => 1
group_add_followups => 1
global_add_followups => 1
global_add_tasks => 1
update_ticket => 1
update_priority => 1
own_ticket => 1
steal_ticket => 1
assign_ticket => 1
show_all_ticket => 1
show_assign_ticket => 1
show_full_ticket => 1
observe_ticket => 1
update_followups => 1
update_tasks => 1
show_planning => 1
show_group_planning => 1
show_all_planning => 1
statistic => 1
password_update => 1
helpdesk_hardware => 3
helpdesk_item_type => KEY => VALUE
0 => Computer
1 => Software
2 => Phone
helpdesk_status =>
show_group_ticket => 0
show_group_hardware => 0
rule_dictionnary_software => w
rule_dictionnary_dropdown => w
budget => w
import_externalauth_users => w
notification => w
rule_mailcollector => w
date_mod =>
comment =>
validate_ticket => 1
create_validation => 1
entities => KEY => VALUE
2 => KEY => VALUE
id => 0
name =>
is_recursive => 1
glpiactiveentities => KEY => VALUE
0 => 0
1001143 => 1001143
1000747 => 1000747
1000630 => 1000630
...
7004392 => 7004392
7004393 => 7004393
7004403 => 7004403
7004431 => 7004431
glpisearch => KEY => VALUE
CronTask => KEY => VALUE
start => 0
order => ASC
is_deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
searchtype => KEY => VALUE
0 => contains
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
Link => KEY => VALUE
start => 0
order => ASC
is_deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
searchtype => KEY => VALUE
0 => contains
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
Ticket => KEY => VALUE
field => KEY => VALUE
0 => 12
searchtype => KEY => VALUE
0 => equals
contains => KEY => VALUE
0 => notold
sort => 19
order => DESC
NotificationTemplate => KEY => VALUE
start => 0
order => ASC
is_deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
searchtype => KEY => VALUE
0 => contains
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
Notification => KEY => VALUE
start => 0
order => ASC
is_deleted => 0
distinct => N
link =>
field => KEY => VALUE
0 => view
contains => KEY => VALUE
0 =>
searchtype => KEY => VALUE
0 => contains
link2 =>
field2 => KEY => VALUE
0 => view
contains2 => KEY => VALUE
0 =>
itemtype2 =>
searchtype2 =>
sort => 1
glpisearchcount => KEY => VALUE
CronTask => 1
Link => 1
Ticket => 1
NotificationTemplate => 1
Notification => 1
glpisearchcount2 => KEY => VALUE
CronTask => 0
Link => 0
Ticket => 0
NotificationTemplate => 0
Notification => 0
glpiactiveentities_string => '0','1001143','1000747','1000630','1000785','1000766','1001171','1000647','1001390','1000790','1001082','1001048','1001157',
...
'7002793','7002794','7003619','7003620','7003621','7002798','7004148','7002800','7004365','7004449','7004392','7004393','7004403','7004431'
glpiparententities =>
glpiparententities_string =>
glpiactive_entity => 0
glpiactive_entity_name => Entité racine (arborescence)
glpiactive_entity_shortname => Entité racine (arborescence)
glpishowallentities => 0
glpigroups =>
glpi_currenttime => 2010-08-02 08:53:05
MESSAGE_AFTER_REDIRECT =>
glpi_multientitiesmode => 1
glpilisttitle => KEY => VALUE
CronTask => Liste
NotificationMailSetting =>
NotificationTemplate => Liste
Notification => Liste
glpilistitems => KEY => VALUE
CronTask => KEY => VALUE
0 => 16
1 => 2
2 => 10
3 => 11
4 => 15
5 => 3
6 => 5
7 => 13
8 => 6
9 => 7
10 => 9
11 => 1
12 => 8
13 => 14
14 => 12
15 => 4
NotificationMailSetting =>
NotificationTemplate => KEY => VALUE
0 => 3
1 => 6
2 => 8
3 => 9
4 => 12
5 => 10
6 => 11
7 => 1
8 => 2
9 => 4
10 => 5
11 => 7
Notification => KEY => VALUE
0 => 5
1 => 6
2 => 16
3 => 1
4 => 20
5 => 4
6 => 21
7 => 18
8 => 17
9 => 9
10 => 15
11 => 10
12 => 22
13 => 19
14 => 13
15 => 2
16 => 11
17 => 23
18 => 12
19 => 7
glpilisturl => KEY => VALUE
CronTask => /glpi-0.78-RC2/front/crontask.php
NotificationMailSetting => /glpi-0.78-RC2/front/notificationmailsetting.php
NotificationTemplate => /glpi-0.78-RC2/front/notificationtemplate.php
Notification => /glpi-0.78-RC2/front/notification.php
glpimassiveactionselected =>
glpicronuserrunning =>
Y aurai-t-il quelques chose qui nous échappe ?
Merci de votre aide.
Last edited by fbou (2010-08-02 11:21:30)
Cordialement,
fbou
--------------------
GLPI version 0.72.4 / Plateforme LAMP.
Offline
De nouveau un test...
Nous venons de faire une sauvegarde de la plate-forme et de la passer sur une LAMP :
linux Ubuntu 10.04
MySQL : 5.1.41
PHP : 5.3.2
Apache : 2.2.14
----
Nous avons des performances très différentes : ~7sec
Même si ces performances ne sont pas encore extraordinaires, nous avons une nette amélioration !
Nous nous posions une question sur le nombre de requete lancé à la création d'un ticket : > 8000...
Est-ce normal de lister un par un l'ensemble des entités ?
Quelqu'un a-t-il les mêmes soucis de perf. ?
A vous lire,
Cordialement,
fbou
--------------------
GLPI version 0.72.4 / Plateforme LAMP.
Offline
Bonjour,
Je me permet de déterrer ce message car j'ai à peu près le même problème de performances depuis le début de la semaine.
Tout est à jour:
Debian 5.0.6
Apache 2.2.9
MySql 5.0.51a
PHP 5.2.4-1
Nous n'observons des lenteurs (+/- 10sec) qu'à la création de tickets et ajout de suivi, tout le reste de la navigation est très fluide et les insertions sur d'autres outils hébergés sur la même plateforme ne souffrent pas de ces lenteurs.
Le mode debug ne me remonte pas d'erreur et des requêtes de sélection (en moyenne 125 tout de même) qui durent quelques millièmes de secondes. Le monitoring sur le serveur ne m'indique pas de traffic étrange perturbant le serveur.
Je commence à être à court d'idées et je me tourne donc vers vous.
Merci pour votre aide.
Offline
Sans doute l'envoi de notification.
Donc il faut utiliser un serveur SMTP rapide : le mieux, c'est d'utiliser "localhost" en relai.
+
Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/
Offline
Je suis d'accord avec Remi.
Est-ce que vous vous connectez en anonyme sur votre serveur SMTP ? La connexion anonyme peux causer des lenteurs.
Essayez avec un identifiant/mot de passe.
@ +
Plateforme Ubuntu 10.04 LTS
GLPI : 0.80.1 [Apache version 2.2.14 PHP Version 5.3.2]
Utilisateur depuis 2007
Offline
Bonjour à tous!!
YES ca venait de cela!! enfin...
J'ai désactivé le suivi par mail et ENFIN les pages s'affichent bien correctement!
UN GRAND MERCO A TOUS
par contre j'ai également des soucis dans la gestion des gabaris (je n'en ai plus)
Offline
ah bah non les gabarits se réaffichent, comprends pas....
encore merci
Reste à comprendre pourquoi les notifications ne fonctionnaient plus puis les réactiver, je suis preneur pour les infos.
Boolzabah
Last edited by boolzabah (2014-01-16 10:45:46)
Offline