Mysql 100%

axil_76 · 2014-02-25 17:44:27

Bonjour,
J'ai un petit soucy malgré un my.cnf configuré correctement , le process mysql occupe la cpu à 100 % , j’ai pu observer ce comportement quand on active les vues personnelles , au moment où je fais « inventaire -> ordinateur » une requête fait une copie du resultat dans une table temporaire « Copying to tmp table » et c’est là que le process monte a 100 %
Je suis en glpi 0.83 - Config 4 CPU + 4 Go de RAM
le plus troublant c'est qu'il y a des comptes qui fonctionnent , c'est a dire que l'utilisateur fait « inventaire -> ordinateur » et la réponse est instantanée .
Dans quelle table on positionne les vues personnelles pour remettre les vues par defaut ?
Merci pour vos réponses

vorGroup · 2014-02-26 09:25:31

As a workaround, I would recommend creating a RAMDrive and then configuring MySQL to use the RAMDrive's mountpoint for all temp table creations. This essentially puts temp tables back into memory, and keeps the CPU ioWait down.

axil_76 · 2014-02-26 15:00:29

je viens de faire le teste , cela ne change rien !

0. mkdir -p /db/tmpfs01 && chown mysql:mysql /db/tmpfs01
1. mount tmpfs /db/tmpfs01 -t tmpfs -o size=1G
3. edit my.cnf file and add: tmpdir = /db/tmpfs01
4. restart MySQL

ou
http://2bits.com/articles/reduce-your-s … -disk.html

j'ai un utilisateur qui a supprimer ca vue personnelle et il se retrouve dans la meme situation , la requete bloque le process mysql à 100 %
je pense qu'il y a un rapport avec les vues , peut-on remettre les vues de tous les utilisateurs par défaut ?
voila la requete qui bloque

SELECT 'PZEW125' AS currentuser, `glpi_computers`.`name` AS ITEM_0, `glpi_computers`.`id` AS ITEM_0_2, `glpi_locations`.`completename` AS ITEM_1, `glpi_states`.`completename` AS ITEM_2, `glpi_computers`.`comment` AS ITEM_3, `glpi_computertypes`.`name` AS ITEM_4, `glpi_computermodels`.`name` AS ITEM_5, `glpi_operatingsystems`.`name` AS ITEM_6, `glpi_computers`.`serial` AS ITEM_7, `glpi_operatingsystemservicepacks`.`name` AS ITEM_8, `glpi_groups`.`completename` AS ITEM_9, `glpi_users_users_id_tech`.`name` AS ITEM_10, `glpi_users_users_id_tech`.`realname` AS ITEM_10_2, `glpi_users_users_id_tech`.`id` AS ITEM_10_3, `glpi_users_users_id_tech`.`firstname` AS ITEM_10_4, `glpi_groups_groups_id_tech`.`completename` AS ITEM_11, `glpi_computers`.`id` AS ITEM_12, `glpi_operatingsystemversions`.`name` AS ITEM_13, `glpi_autoupdatesystems`.`name` AS ITEM_14, `glpi_computers`.`date_mod` AS ITEM_15, GROUP_CONCAT( DISTINCT `glpi_deviceprocessors_5f7e26f9f0745c275164ce9061504c57`.`designation`
SEPARATOR '$$$$' ) AS ITEM_16, SUM( `glpi_computers_devicememories`.`specificity` ) / COUNT( `glpi_computers_devicememories`.`id` ) * COUNT( DISTINCT `glpi_computers_devicememories`.`id` ) AS ITEM_17, SUM( `glpi_computers_deviceprocessors`.`specificity` ) / COUNT( `glpi_computers_deviceprocessors`.`id` ) AS ITEM_18, `glpi_manufacturers`.`name` AS ITEM_19, SUM( `glpi_computers_deviceharddrives`.`specificity` ) / COUNT( `glpi_computers_deviceharddrives`.`id` ) * COUNT( DISTINCT `glpi_computers_deviceharddrives`.`id` ) AS ITEM_20, GROUP_CONCAT( DISTINCT `glpi_networkports_835478c7a57a8a79892635dbf6064655`.`ip`
SEPARATOR '$$$$' ) AS ITEM_21, `glpi_computers`.`id` AS id
FROM `glpi_computers`
LEFT JOIN `glpi_locations` ON ( `glpi_computers`.`locations_id` = `glpi_locations`.`id` )
LEFT JOIN `glpi_states` ON ( `glpi_computers`.`states_id` = `glpi_states`.`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_operatingsystemservicepacks` ON ( `glpi_computers`.`operatingsystemservicepacks_id` = `glpi_operatingsystemservicepacks`.`id` )
LEFT JOIN `glpi_groups` ON ( `glpi_computers`.`groups_id` = `glpi_groups`.`id` )
LEFT JOIN `glpi_users` AS glpi_users_users_id_tech ON ( `glpi_computers`.`users_id_tech` = `glpi_users_users_id_tech`.`id` )
LEFT JOIN `glpi_groups` AS glpi_groups_groups_id_tech ON ( `glpi_computers`.`groups_id_tech` = `glpi_groups_groups_id_tech`.`id` )
LEFT JOIN `glpi_operatingsystemversions` ON ( `glpi_computers`.`operatingsystemversions_id` = `glpi_operatingsystemversions`.`id` )
LEFT JOIN `glpi_autoupdatesystems` ON ( `glpi_computers`.`autoupdatesystems_id` = `glpi_autoupdatesystems`.`id` )
LEFT JOIN `glpi_computers_deviceprocessors` ON ( `glpi_computers`.`id` = `glpi_computers_deviceprocessors`.`computers_id` )
LEFT JOIN `glpi_deviceprocessors` AS glpi_deviceprocessors_5f7e26f9f0745c275164ce9061504c57 ON ( `glpi_computers_deviceprocessors`.`deviceprocessors_id` = `glpi_deviceprocessors_5f7e26f9f0745c275164ce9061504c57`.`id` )
LEFT JOIN `glpi_computers_devicememories` ON ( `glpi_computers`.`id` = `glpi_computers_devicememories`.`computers_id` )
LEFT JOIN `glpi_manufacturers` ON ( `glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id` )
LEFT JOIN `glpi_computers_deviceharddrives` ON ( `glpi_computers`.`id` = `glpi_computers_deviceharddrives`.`computers_id` )
LEFT JOIN `glpi_computers_devicenetworkcards` ON ( `glpi_computers`.`id` = `glpi_computers_devicenetworkcards`.`computers_id` )
LEFT JOIN `glpi_networkports` AS glpi_networkports_835478c7a57a8a79892635dbf6064655 ON ( `glpi_computers`.`id` = `glpi_networkports_835478c7a57a8a79892635dbf6064655`.`items_id`
AND `glpi_networkports_835478c7a57a8a79892635dbf6064655`.`itemtype` = 'Computer' )
WHERE `glpi_computers`.`is_deleted` = '0'
AND `glpi_computers`.`is_template` = '0'
AND (
`glpi_computers`.`entities_id`
IN (
'0'
)
)
GROUP BY `glpi_computers`.`id`
ORDER BY ITEM_0 ASC
LIMIT 0 , 30

Last edited by axil_76 (2014-02-26 15:03:28)

axil_76 · 2014-03-04 15:11:25

apres plusieurs test et restore de dump ca serait la vue personnelle qui pose problème !
lorsqu'on rajoute l'adresse ip du serveur par exemple dans la vue global ou vue personnelle , la requête fait monter mysql a 100 % ..!en fait il fait un « Copying to tmp table » et puis on peut attendre longtemps.. , peut-on me donner la table qui correspond a la vue global ?

pour info ... j'ai fait le test en 0.84 c'est le meme problème ..! peut etre que la requete est mal faite ???

axil_76 · 2014-03-04 15:15:00

ha non sur la 0.84 ca fonctionne bien avec le champ adresse ip , par contre dès qu'on rajoute d'autres champs ! ca fonctionne plus !

Last edited by axil_76 (2014-03-04 15:33:27)

bej04037 · 2016-03-29 20:59:18

Bonjour,

Je re-ouvre ce thread car j' ai ce problème depuis ma migration 0.78.5 vers 0.84.8.
Si j'ajoute le champ IP la requête computer view dure 4 minutes
Comment avez vous résolu ce problème ?

Merci

ddurieux · 2016-03-30 17:42:27

Il y a eu des modifications de structure pour optimiser cette requete sur l'IP, mais il faut passer sur une version plus récente de GLPI

bej04037 · 2016-03-30 22:23:35

Merci pour la réponse
je pense continuer la migration vers la 0.85.3.
Est-ce une release optimisé pour ce problème ?
Je ne souhaite pas monter de trop haut car j' ai une dizaine de plugin et certains ne sont pas encore disponible pour la 0.9.

ddurieux · 2016-03-31 10:22:16

les plugins compatible 0.85 le sont aussi pour la 0.90

bej04037 · 2016-03-31 22:30:18

Bonsoir ddurieux

C'est intéressant, j'ai besoin du plugin appliance inventory, il semble y avoir seulement une version pour 0.84
Tu confirme ?

rreglpimc · 2019-11-25 15:57:18

Bonjour à tous,

je déterre un peu ce topic pour ne pas en recréé un autre similaire.

Depuis qql semaines, on rencontre un soucis avec l'instance glpi qui s'écroule suite à une requête mysql.
Au départ je pensais à une requête servant à alimenter des fichiers excel de kpi/métrique (oui mes utilisateurs ont du mal à utiliser les rapports intégrés à glpi ou le dashboard, du coup ils font ça via excel.... no comment).

Après analyse de la dernière occurence, il s'avère que je suis en mesure de reproduire le problème qui est le suivant :
- aller dans l'interface des tickets
- clear le filtre si il en existe 1 et dans le critère de recherche, remplacer "éléments visualisés" par "tous" (tout tout en bas de la liste déroulante, j'avais jamais vu que ça existait !)
- lancer la recherche (que ça soit sur l'entité racine ou sur une sous entité, même combat)

=> là le navigateur du client qui a lancé mouline dans le vide et n'arrive jamais au bout
=> au bout de plusieurs minutes que la requête tourne en occupant 100% de cpu sur un thread avec un process mysql, on perd l'accès à l'instance web pour tout le monde

Workaround temporaire : kill de mysql et relance du service sous debian
Workaround permanent : ne pas utilisé le critère "tous" ?? optimisé la conf mysql ? si oui comment ?

config : GLPI 9.4.3 / Debian 9.8 / PHP 7.0.33-0+deb9u3 fpm-fcgi / Apache 2.4.25 / 10.1.38-MariaDB
client : ie, firefox, chrome

exemple de la requête qui sature et fait planté mysql avec le critère "tous", pas trop optimisée selon moi :

SELECT DISTINCT `glpi_tickets`.`id` AS id, 'prénom.nom' AS currentuser,
`glpi_tickets`.`id` AS `ITEM_Ticket_2`, `glpi_tickets`.`name` AS `ITEM_Ticket_1`,
`glpi_tickets`.`id` AS `ITEM_Ticket_1_id`,
`glpi_tickets`.`id` AS `ITEM_Ticket_1_id`, `glpi_tickets`.`content` AS `ITEM_Ticket_1_content`, `glpi_tickets`.`status` AS `ITEM_Ticket_1_status`, `glpi_tickets`.`status` AS `ITEM_Ticket_12`, `glpi_tickets`.`date` AS `ITEM_Ticket_15`, `glpi_tickets`.`priority` AS `ITEM_Ticket_3`, GROUP_CONCAT(DISTINCT `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`id` SEPARATOR '$$##$$')
AS `ITEM_Ticket_4`,
GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`users_id`, ' ',
`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`alternative_email`)
SEPARATOR '$$##$$') AS `ITEM_Ticket_4_2`,
GROUP_CONCAT(DISTINCT `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`id` SEPARATOR '$$##$$')
AS `ITEM_Ticket_5`,
GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`users_id`, ' ',
`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`alternative_email`)
SEPARATOR '$$##$$') AS `ITEM_Ticket_5_2`,
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_groups_1358be41ea7158319a888236ffba5355`.`completename`, '__NULL__'),
'$#$',`glpi_groups_1358be41ea7158319a888236ffba5355`.`id`) ORDER BY `glpi_groups_1358be41ea7158319a888236ffba5355`.`id` SEPARATOR '$$##$$')
AS `ITEM_Ticket_8`,

`glpi_users_users_id_lastupdater`.`name` AS `ITEM_Ticket_64`,
`glpi_users_users_id_lastupdater`.`realname` AS `ITEM_Ticket_64_realname`,
`glpi_users_users_id_lastupdater`.`id` AS `ITEM_Ticket_64_id`,
`glpi_users_users_id_lastupdater`.`firstname` AS `ITEM_Ticket_64_firstname`,
`glpi_tickets`.`date_mod` AS `ITEM_Ticket_19`, `glpi_itilcategories`.`completename` AS `ITEM_Ticket_7`, `glpi_plugin_vip_groups`.`isvip` AS `ITEM_Ticket_10100` FROM `glpi_tickets` LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`tickets_id`
AND `glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`type` = 1 )LEFT JOIN `glpi_users` AS `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`
ON (`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`users_id` = `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`id`
) LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`tickets_id`
AND `glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`type` = 2 )LEFT JOIN `glpi_users` AS `glpi_users_f201be21cd638ee780d08cba4ceff0d4`
ON (`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`users_id` = `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`id`
) LEFT JOIN `glpi_groups_tickets` AS `glpi_groups_tickets_819efb92c8b927b345e489211ec8e43b`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets_819efb92c8b927b345e489211ec8e43b`.`tickets_id`
AND `glpi_groups_tickets_819efb92c8b927b345e489211ec8e43b`.`type` = 2 )LEFT JOIN `glpi_groups` AS `glpi_groups_1358be41ea7158319a888236ffba5355`
ON (`glpi_groups_tickets_819efb92c8b927b345e489211ec8e43b`.`groups_id` = `glpi_groups_1358be41ea7158319a888236ffba5355`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_users_id_lastupdater`
ON (`glpi_tickets`.`users_id_lastupdater` = `glpi_users_users_id_lastupdater`.`id`
)LEFT JOIN `glpi_itilcategories`
ON (`glpi_tickets`.`itilcategories_id` = `glpi_itilcategories`.`id`
) LEFT JOIN `glpi_tickets_users` ON (`glpi_tickets`.`id` = `glpi_tickets_users`.`tickets_id` AND `glpi_tickets_users`.`type` = 1) LEFT JOIN `glpi_groups_users` ON (`glpi_tickets_users`.`users_id` = `glpi_groups_users`.`users_id`) LEFT JOIN `glpi_plugin_vip_groups` ON (`glpi_groups_users`.`groups_id` = `glpi_plugin_vip_groups`.`id`)LEFT JOIN `glpi_entities`
ON (`glpi_tickets`.`entities_id` = `glpi_entities`.`id`
) LEFT JOIN `glpi_items_tickets`
ON (`glpi_tickets`.`id` = `glpi_items_tickets`.`tickets_id`
)LEFT JOIN `glpi_requesttypes`
ON (`glpi_tickets`.`requesttypes_id` = `glpi_requesttypes`.`id`
)LEFT JOIN `glpi_locations`
ON (`glpi_tickets`.`locations_id` = `glpi_locations`.`id`
) LEFT JOIN `glpi_documents_items`
ON (`glpi_tickets`.`id` = `glpi_documents_items`.`items_id`
AND `glpi_documents_items`.`itemtype` = 'Ticket'
) LEFT JOIN `glpi_documents` AS `glpi_documents_2d98e43dfecb07952ef329c36da01250`
ON (`glpi_documents_items`.`documents_id` = `glpi_documents_2d98e43dfecb07952ef329c36da01250`.`id`
) LEFT JOIN `glpi_groups_tickets` AS `glpi_groups_tickets_d1524bb2ea1d461ab90aed3b5f0e7e60`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets_d1524bb2ea1d461ab90aed3b5f0e7e60`.`tickets_id`
AND `glpi_groups_tickets_d1524bb2ea1d461ab90aed3b5f0e7e60`.`type` = 1 )LEFT JOIN `glpi_groups` AS `glpi_groups_a0fdb25a4e0967f334115fb0dbcee9ce`
ON (`glpi_groups_tickets_d1524bb2ea1d461ab90aed3b5f0e7e60`.`groups_id` = `glpi_groups_a0fdb25a4e0967f334115fb0dbcee9ce`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_users_id_recipient`
ON (`glpi_tickets`.`users_id_recipient` = `glpi_users_users_id_recipient`.`id`
) LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_d86d1fe2a1ea996e3820de82e6aa57e8`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_d86d1fe2a1ea996e3820de82e6aa57e8`.`tickets_id`
AND `glpi_tickets_users_d86d1fe2a1ea996e3820de82e6aa57e8`.`type` = 3 )LEFT JOIN `glpi_users` AS `glpi_users_b746b14c5f912caf02dd66b0df98d264`
ON (`glpi_tickets_users_d86d1fe2a1ea996e3820de82e6aa57e8`.`users_id` = `glpi_users_b746b14c5f912caf02dd66b0df98d264`.`id`
) LEFT JOIN `glpi_groups_tickets` AS `glpi_groups_tickets_d86d1fe2a1ea996e3820de82e6aa57e8`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets_d86d1fe2a1ea996e3820de82e6aa57e8`.`tickets_id`
AND `glpi_groups_tickets_d86d1fe2a1ea996e3820de82e6aa57e8`.`type` = 3 )LEFT JOIN `glpi_groups` AS `glpi_groups_c4fd3c0e88c6dca4af1d451af9d747fb`
ON (`glpi_groups_tickets_d86d1fe2a1ea996e3820de82e6aa57e8`.`groups_id` = `glpi_groups_c4fd3c0e88c6dca4af1d451af9d747fb`.`id`
) LEFT JOIN `glpi_suppliers_tickets` AS `glpi_suppliers_tickets_819efb92c8b927b345e489211ec8e43b`
ON (`glpi_tickets`.`id` = `glpi_suppliers_tickets_819efb92c8b927b345e489211ec8e43b`.`tickets_id`
AND `glpi_suppliers_tickets_819efb92c8b927b345e489211ec8e43b`.`type` = 2 )LEFT JOIN `glpi_suppliers` AS `glpi_suppliers_d5ef7ac0b56c3f7be9b7468c412fee7e`
ON (`glpi_suppliers_tickets_819efb92c8b927b345e489211ec8e43b`.`suppliers_id` = `glpi_suppliers_d5ef7ac0b56c3f7be9b7468c412fee7e`.`id`
)LEFT JOIN `glpi_slas` AS `glpi_slas_slas_id_tto_bb5aab1a526f6069c73375c529fafec7`
ON (`glpi_tickets`.`slas_id_tto` = `glpi_slas_slas_id_tto_bb5aab1a526f6069c73375c529fafec7`.`id`
AND `glpi_slas_slas_id_tto_bb5aab1a526f6069c73375c529fafec7`.`type` = '1' )LEFT JOIN `glpi_slas` AS `glpi_slas_slas_id_ttr_f3aab278f60e510b77ec99388d401d84`
ON (`glpi_tickets`.`slas_id_ttr` = `glpi_slas_slas_id_ttr_f3aab278f60e510b77ec99388d401d84`.`id`
AND `glpi_slas_slas_id_ttr_f3aab278f60e510b77ec99388d401d84`.`type` = '0' ) LEFT JOIN `glpi_slalevels_tickets`
ON (`glpi_tickets`.`id` = `glpi_slalevels_tickets`.`tickets_id`
)LEFT JOIN `glpi_slalevels` AS `glpi_slalevels_b3496fc202f417bdbcf7196c9852bb44`
ON (`glpi_slalevels_tickets`.`slalevels_id` = `glpi_slalevels_b3496fc202f417bdbcf7196c9852bb44`.`id`
)LEFT JOIN `glpi_olas` AS `glpi_olas_olas_id_tto_bb5aab1a526f6069c73375c529fafec7`
ON (`glpi_tickets`.`olas_id_tto` = `glpi_olas_olas_id_tto_bb5aab1a526f6069c73375c529fafec7`.`id`
AND `glpi_olas_olas_id_tto_bb5aab1a526f6069c73375c529fafec7`.`type` = '1' )LEFT JOIN `glpi_olas` AS `glpi_olas_olas_id_ttr_f3aab278f60e510b77ec99388d401d84`
ON (`glpi_tickets`.`olas_id_ttr` = `glpi_olas_olas_id_ttr_f3aab278f60e510b77ec99388d401d84`.`id`
AND `glpi_olas_olas_id_ttr_f3aab278f60e510b77ec99388d401d84`.`type` = '0' ) LEFT JOIN `glpi_olalevels_tickets`
ON (`glpi_tickets`.`id` = `glpi_olalevels_tickets`.`tickets_id`
)LEFT JOIN `glpi_olalevels` AS `glpi_olalevels_ef6f69a2a882a9c957c5861574cf3188`
ON (`glpi_olalevels_tickets`.`olalevels_id` = `glpi_olalevels_ef6f69a2a882a9c957c5861574cf3188`.`id`
) LEFT JOIN `glpi_ticketvalidations`
ON (`glpi_tickets`.`id` = `glpi_ticketvalidations`.`tickets_id`
)LEFT JOIN `glpi_users` AS `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`
ON (`glpi_ticketvalidations`.`users_id` = `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`
ON (`glpi_ticketvalidations`.`users_id_validate` = `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`id`
) LEFT JOIN `glpi_ticketsatisfactions`
ON (`glpi_tickets`.`id` = `glpi_ticketsatisfactions`.`tickets_id`
) LEFT JOIN `glpi_itilfollowups`
ON (`glpi_tickets`.`id` = `glpi_itilfollowups`.`items_id`
AND `glpi_itilfollowups`.`itemtype` = 'Ticket'
) LEFT JOIN `glpi_requesttypes` AS `glpi_requesttypes_d12a295d7ff257da5484d2c48ced662b`
ON (`glpi_itilfollowups`.`requesttypes_id` = `glpi_requesttypes_d12a295d7ff257da5484d2c48ced662b`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_d12a295d7ff257da5484d2c48ced662b`
ON (`glpi_itilfollowups`.`users_id` = `glpi_users_d12a295d7ff257da5484d2c48ced662b`.`id`
) LEFT JOIN `glpi_tickettasks`
ON (`glpi_tickets`.`id` = `glpi_tickettasks`.`tickets_id`
)LEFT JOIN `glpi_taskcategories` AS `glpi_taskcategories_e5ca2f53018fdc28a31faf534186b3a2`
ON (`glpi_tickettasks`.`taskcategories_id` = `glpi_taskcategories_e5ca2f53018fdc28a31faf534186b3a2`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`
ON (`glpi_tickettasks`.`users_id` = `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`
ON (`glpi_tickettasks`.`users_id_tech` = `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`id`
)LEFT JOIN `glpi_groups` AS `glpi_groups_groups_id_tech_e5ca2f53018fdc28a31faf534186b3a2`
ON (`glpi_tickettasks`.`groups_id_tech` = `glpi_groups_groups_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`id`
)LEFT JOIN `glpi_tasktemplates` AS `glpi_tasktemplates_e5ca2f53018fdc28a31faf534186b3a2`
ON (`glpi_tickettasks`.`tasktemplates_id` = `glpi_tasktemplates_e5ca2f53018fdc28a31faf534186b3a2`.`id`
) LEFT JOIN `glpi_tickets_tickets`
ON ((`glpi_tickets`.`id`
= `glpi_tickets_tickets`.`tickets_id_1`
OR `glpi_tickets`.`id`
= `glpi_tickets_tickets`.`tickets_id_2`)
) LEFT JOIN `glpi_tickets_tickets` AS `glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`
ON ((`glpi_tickets`.`id`
= `glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`.`tickets_id_1`
OR `glpi_tickets`.`id`
= `glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`.`tickets_id_2`)
AND `glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`.`link` = 2 ) LEFT JOIN `glpi_tickets_tickets` AS `glpi_tickets_tickets_9ea26d5c9bb1204c106dce61d751f4eb`
ON (`glpi_tickets`.`id` = `glpi_tickets_tickets_9ea26d5c9bb1204c106dce61d751f4eb`.`tickets_id_1`
AND `glpi_tickets_tickets_9ea26d5c9bb1204c106dce61d751f4eb`.`link` = 3 )LEFT JOIN `glpi_tickets` AS `glpi_tickets_tickets_id_2_5902dd14035b2dbb2510a1e55d1c9a4a`
ON (`glpi_tickets_tickets_9ea26d5c9bb1204c106dce61d751f4eb`.`tickets_id_2` = `glpi_tickets_tickets_id_2_5902dd14035b2dbb2510a1e55d1c9a4a`.`id`
) LEFT JOIN `glpi_tickets_tickets` AS `glpi_tickets_tickets_48b11680da9cd90521f248d617a22048`
ON (`glpi_tickets`.`id` = `glpi_tickets_tickets_48b11680da9cd90521f248d617a22048`.`tickets_id_2`
AND `glpi_tickets_tickets_48b11680da9cd90521f248d617a22048`.`link` = 3 )LEFT JOIN `glpi_tickets` AS `glpi_tickets_tickets_id_1_5902dd14035b2dbb2510a1e55d1c9a4a`
ON (`glpi_tickets_tickets_48b11680da9cd90521f248d617a22048`.`tickets_id_1` = `glpi_tickets_tickets_id_1_5902dd14035b2dbb2510a1e55d1c9a4a`.`id`
) LEFT JOIN `glpi_itilsolutions`
ON (`glpi_tickets`.`id` = `glpi_itilsolutions`.`items_id`
AND `glpi_itilsolutions`.`itemtype` = 'Ticket'
) LEFT JOIN `glpi_solutiontypes` AS `glpi_solutiontypes_d493e99d999206eb61c5eb189f85a158`
ON (`glpi_itilsolutions`.`solutiontypes_id` = `glpi_solutiontypes_d493e99d999206eb61c5eb189f85a158`.`id`
) LEFT JOIN `glpi_itilsolutions` AS `glpi_itilsolutions_55ddf494676c2bd280ea5c785e14b930`
ON (`glpi_tickets`.`id` = `glpi_itilsolutions_55ddf494676c2bd280ea5c785e14b930`.`items_id`
AND `glpi_itilsolutions_55ddf494676c2bd280ea5c785e14b930`.`itemtype` = 'Ticket'

AND `glpi_itilsolutions_55ddf494676c2bd280ea5c785e14b930`.`id` = (
SELECT `id` FROM `glpi_itilsolutions`
WHERE `glpi_itilsolutions`.`items_id` = `glpi_tickets`.`id`
AND `glpi_itilsolutions`.`itemtype` = 'Ticket'
ORDER BY `glpi_itilsolutions`.`id` DESC
LIMIT 1
) ) LEFT JOIN `glpi_ticketcosts`
ON (`glpi_tickets`.`id` = `glpi_ticketcosts`.`tickets_id`
) WHERE `glpi_tickets`.`is_deleted` = 0 AND ( `glpi_tickets`.`entities_id` IN ('26') ) AND ( ( (`glpi_tickets`.`name` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`content` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`id` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`status` LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickets`.`date` USING utf8) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickets`.`closedate` USING utf8) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickets`.`time_to_resolve` USING utf8) LIKE '%ENGIE%' ) OR (IF(`glpi_tickets`.`time_to_resolve` IS NOT NULL
AND `glpi_tickets`.`status` <> 4
AND (`glpi_tickets`.`solvedate` > `glpi_tickets`.`time_to_resolve`
OR (`glpi_tickets`.`solvedate` IS NULL
AND `glpi_tickets`.`time_to_resolve` < NOW())),
1, 0) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickets`.`solvedate` USING utf8) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickets`.`date_mod` USING utf8) LIKE '%ENGIE%' ) OR (`glpi_itilcategories`.`completename` LIKE '%ENGIE%' ) OR (`glpi_entities`.`completename` LIKE '%ENGIE%' ) OR (((`glpi_users_users_id_lastupdater`.`realname` LIKE '%ENGIE%'
OR `glpi_users_users_id_lastupdater`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_users_id_lastupdater`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_users_id_lastupdater`.`realname`, ' ', `glpi_users_users_id_lastupdater`.`firstname`) LIKE '%ENGIE%' )
) ) OR (CONVERT(`glpi_tickets`.`time_to_own` USING utf8) LIKE '%ENGIE%' ) OR (IF(`glpi_tickets`.`time_to_own` IS NOT NULL
AND `glpi_tickets`.`status` <> 4
AND (`glpi_tickets`.`takeintoaccount_delay_stat`
> TIME_TO_SEC(TIMEDIFF(`glpi_tickets`.`time_to_own`,
`glpi_tickets`.`date`))
OR (`glpi_tickets`.`takeintoaccount_delay_stat` = 0
AND `glpi_tickets`.`time_to_own` < NOW())),
1, 0) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickets`.`internal_time_to_resolve` USING utf8) LIKE '%ENGIE%' ) OR (IF(`glpi_tickets`.`internal_time_to_resolve` IS NOT NULL
AND `glpi_tickets`.`status` <> 4
AND (`glpi_tickets`.`solvedate` > `glpi_tickets`.`internal_time_to_resolve`
OR (`glpi_tickets`.`solvedate` IS NULL
AND `glpi_tickets`.`internal_time_to_resolve` < NOW())),
1, 0) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickets`.`internal_time_to_own` USING utf8) LIKE '%ENGIE%' ) OR (IF(`glpi_tickets`.`internal_time_to_own` IS NOT NULL
AND `glpi_tickets`.`status` <> 4
AND (`glpi_tickets`.`takeintoaccount_delay_stat`
> TIME_TO_SEC(TIMEDIFF(`glpi_tickets`.`internal_time_to_own`,
`glpi_tickets`.`date`))
OR (`glpi_tickets`.`takeintoaccount_delay_stat` = 0
AND `glpi_tickets`.`internal_time_to_own` < NOW())),
1, 0) LIKE '%ENGIE%' ) OR (`glpi_tickets`.`type` LIKE '%ENGIE%' ) OR (`glpi_items_tickets`.`itemtype` LIKE '%ENGIE%' ) OR (`glpi_requesttypes`.`name` LIKE '%ENGIE%' ) OR (`glpi_locations`.`completename` LIKE '%ENGIE%' ) OR (`glpi_locations`.`address` LIKE '%ENGIE%' ) OR (`glpi_locations`.`postcode` LIKE '%ENGIE%' ) OR (`glpi_locations`.`town` LIKE '%ENGIE%' ) OR (`glpi_locations`.`state` LIKE '%ENGIE%' ) OR (`glpi_locations`.`country` LIKE '%ENGIE%' ) OR (`glpi_locations`.`building` LIKE '%ENGIE%' ) OR (`glpi_locations`.`room` LIKE '%ENGIE%' ) OR (`glpi_locations`.`comment` LIKE '%ENGIE%' ) OR (`glpi_locations`.`latitude` LIKE '%ENGIE%' ) OR (`glpi_locations`.`longitude` LIKE '%ENGIE%' ) OR (((`glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`realname` LIKE '%ENGIE%'
OR `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`realname`, ' ', `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`firstname`) LIKE '%ENGIE%' )
) OR (`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`alternative_email` LIKE '%ENGIE%' )) OR (`glpi_groups_a0fdb25a4e0967f334115fb0dbcee9ce`.`completename` LIKE '%ENGIE%' ) OR (((`glpi_users_users_id_recipient`.`realname` LIKE '%ENGIE%'
OR `glpi_users_users_id_recipient`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_users_id_recipient`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_users_id_recipient`.`realname`, ' ', `glpi_users_users_id_recipient`.`firstname`) LIKE '%ENGIE%' )
) ) OR (((`glpi_users_b746b14c5f912caf02dd66b0df98d264`.`realname` LIKE '%ENGIE%'
OR `glpi_users_b746b14c5f912caf02dd66b0df98d264`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_b746b14c5f912caf02dd66b0df98d264`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_b746b14c5f912caf02dd66b0df98d264`.`realname`, ' ', `glpi_users_b746b14c5f912caf02dd66b0df98d264`.`firstname`) LIKE '%ENGIE%' )
) OR (`glpi_tickets_users_d86d1fe2a1ea996e3820de82e6aa57e8`.`alternative_email` LIKE '%ENGIE%' )) OR (`glpi_groups_c4fd3c0e88c6dca4af1d451af9d747fb`.`completename` LIKE '%ENGIE%' ) OR (((`glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`realname` LIKE '%ENGIE%'
OR `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`realname`, ' ', `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`firstname`) LIKE '%ENGIE%' )
) OR (`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`alternative_email` LIKE '%ENGIE%' )) OR (`glpi_suppliers_d5ef7ac0b56c3f7be9b7468c412fee7e`.`name` LIKE '%ENGIE%' ) OR (`glpi_groups_1358be41ea7158319a888236ffba5355`.`completename` LIKE '%ENGIE%' ) OR (`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`use_notification` LIKE '%ENGIE%' ) OR (`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`alternative_email` LIKE '%ENGIE%' ) OR (`glpi_slas_slas_id_tto_bb5aab1a526f6069c73375c529fafec7`.`name` LIKE '%ENGIE%' ) OR (`glpi_slas_slas_id_ttr_f3aab278f60e510b77ec99388d401d84`.`name` LIKE '%ENGIE%' ) OR (`glpi_slalevels_b3496fc202f417bdbcf7196c9852bb44`.`name` LIKE '%ENGIE%' ) OR (`glpi_olas_olas_id_tto_bb5aab1a526f6069c73375c529fafec7`.`name` LIKE '%ENGIE%' ) OR (`glpi_olas_olas_id_ttr_f3aab278f60e510b77ec99388d401d84`.`name` LIKE '%ENGIE%' ) OR (`glpi_olalevels_ef6f69a2a882a9c957c5861574cf3188`.`name` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`validation_percent` LIKE '%ENGIE%' ) OR `glpi_tickets`.`global_validation` IN ('ENGIE') OR (`glpi_ticketvalidations`.`comment_submission` LIKE '%ENGIE%' ) OR (`glpi_ticketvalidations`.`comment_validation` LIKE '%ENGIE%' ) OR `glpi_ticketvalidations`.`status` IN ('ENGIE') OR (CONVERT(`glpi_ticketvalidations`.`submission_date` USING utf8) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_ticketvalidations`.`validation_date` USING utf8) LIKE '%ENGIE%' ) OR (((`glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`realname` LIKE '%ENGIE%'
OR `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`realname`, ' ', `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`firstname`) LIKE '%ENGIE%' )
) ) OR (((`glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`realname` LIKE '%ENGIE%'
OR `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`realname`, ' ', `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`firstname`) LIKE '%ENGIE%' )
) ) OR (`glpi_ticketsatisfactions`.`type` LIKE '%ENGIE%' ) OR (CONVERT(`glpi_ticketsatisfactions`.`date_begin` USING utf8) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_ticketsatisfactions`.`date_answered` USING utf8) LIKE '%ENGIE%' ) OR (`glpi_ticketsatisfactions`.`satisfaction` LIKE '%ENGIE%' ) OR (`glpi_ticketsatisfactions`.`comment` LIKE '%ENGIE%' ) OR (`glpi_itilfollowups`.`content` LIKE '%ENGIE%' ) OR (CONVERT(`glpi_itilfollowups`.`date` USING utf8) LIKE '%ENGIE%' ) OR (`glpi_requesttypes_d12a295d7ff257da5484d2c48ced662b`.`name` LIKE '%ENGIE%' ) OR (`glpi_itilfollowups`.`is_private` LIKE '%ENGIE%' ) OR (((`glpi_users_d12a295d7ff257da5484d2c48ced662b`.`realname` LIKE '%ENGIE%'
OR `glpi_users_d12a295d7ff257da5484d2c48ced662b`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_d12a295d7ff257da5484d2c48ced662b`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_d12a295d7ff257da5484d2c48ced662b`.`realname`, ' ', `glpi_users_d12a295d7ff257da5484d2c48ced662b`.`firstname`) LIKE '%ENGIE%' )
) ) OR (`glpi_tickettasks`.`content` LIKE '%ENGIE%' ) OR (`glpi_taskcategories_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%ENGIE%' ) OR (`glpi_tickettasks`.`is_private` LIKE '%ENGIE%' ) OR (((`glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`realname` LIKE '%ENGIE%'
OR `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`realname`, ' ', `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`firstname`) LIKE '%ENGIE%' )
) ) OR (((`glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`realname` LIKE '%ENGIE%'
OR `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`firstname` LIKE '%ENGIE%'
OR `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%ENGIE%'
OR CONCAT(`glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`realname`, ' ', `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`firstname`) LIKE '%ENGIE%' )
) ) OR (`glpi_groups_groups_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`completename` LIKE '%ENGIE%' ) OR (`glpi_tickettasks`.`actiontime` LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickettasks`.`date` USING utf8) LIKE '%ENGIE%' ) OR (`glpi_tickettasks`.`state` LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickettasks`.`begin` USING utf8) LIKE '%ENGIE%' ) OR (CONVERT(`glpi_tickettasks`.`end` USING utf8) LIKE '%ENGIE%' ) OR (`glpi_tasktemplates_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`solve_delay_stat` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`close_delay_stat` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`waiting_duration` LIKE '%ENGIE%' ) OR (`glpi_tickets`.`takeintoaccount_delay_stat` LIKE '%ENGIE%' ) OR (((`glpi_tickets_tickets`.`tickets_id_1` = 'ENGIE'
OR `glpi_tickets_tickets`.`tickets_id_2` = 'ENGIE')
AND `glpi_tickets`.`id` <> 'ENGIE')
) OR (((`glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`.`tickets_id_1` = 'ENGIE'
OR `glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`.`tickets_id_2` = 'ENGIE')
AND `glpi_tickets`.`id` <> 'ENGIE')
) OR (`glpi_solutiontypes_d493e99d999206eb61c5eb189f85a158`.`name` LIKE '%ENGIE%' ) OR (`glpi_itilsolutions`.`content` LIKE '%ENGIE%' ) OR (`glpi_itilsolutions`.`status` LIKE '%ENGIE%' ) OR (`glpi_itilsolutions_55ddf494676c2bd280ea5c785e14b930`.`status` LIKE '%ENGIE%' ) OR (`glpi_plugin_vip_groups`.`isvip` LIKE '%ENGIE%' )) ) GROUP BY `glpi_tickets`.`id` ORDER BY ITEM_Ticket_19 DESC

Forum GLPI-Project

Announcement

#1 2014-02-25 17:44:27

Mysql 100%

#2 2014-02-26 09:25:31

Re: Mysql 100%

#3 2014-02-26 15:00:29

Re: Mysql 100%

#4 2014-03-04 15:11:25

Re: Mysql 100%

#5 2014-03-04 15:15:00

Re: Mysql 100%

#6 2016-03-29 20:59:18

Re: Mysql 100%

#7 2016-03-30 17:42:27

Re: Mysql 100%

#8 2016-03-30 22:23:35

Re: Mysql 100%

#9 2016-03-31 10:22:16

Re: Mysql 100%

#10 2016-03-31 22:30:18

Re: Mysql 100%

#11 2019-11-25 15:57:18

Re: Mysql 100%

Board footer