You are not logged in.
- Topics: Active | Unanswered
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
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
#1 2017-10-10 20:01:39
- dahvakana
- Member
- Registered: 2012-02-13
- Posts: 12
Search All locks up database with a long running process.
Hello,
When any tech searches using the "All" option in the dropdown menu in the search criteria, the database locks up. Is this a case of too many tickets in the database? I have seen a previous issue for an earlier version (http://forum.glpi-project.org/viewtopic.php?id=33759) that suggested "disable [the All Search option] on global config" I don't see a way to disable "All" in the Setup->Dropdown options, and I can't locate the "global config" section or file. Is there a workaround for those of us who have many tickets in our database?
Glpi ->0.90.1
PHP ->5.6.31
Apache ->2.4.27
MySQL ->5.6.27 (The glpi_tickets table has 97855 rows.)
The full sql call when I search all (in this case I searched for string "lockup"):
SELECT 'DAhvakana' AS currentuser,
`glpi_tickets`.`id` AS `ITEM_0`, `glpi_tickets`.`name` AS `ITEM_1`,
`glpi_tickets`.`id` AS `ITEM_1_id`,
`glpi_tickets`.`id` AS `ITEM_1_id`, `glpi_tickets`.`content` AS `ITEM_1_content`, `glpi_tickets`.`status` AS `ITEM_1_status`, `glpi_tickets`.`status` AS `ITEM_2`, `glpi_tickets`.`date_mod` AS `ITEM_3`, `glpi_tickets`.`date` AS `ITEM_4`, `glpi_tickets`.`priority` AS `ITEM_5`, GROUP_CONCAT(DISTINCT `glpi_users_647c2805c3795643b0f52f520e7cdb86`.`id` SEPARATOR '$$##$$')
AS `ITEM_6`,
GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`users_id`, ' ',
`glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`alternative_email`)
SEPARATOR '$$##$$') AS `ITEM_6_2`,
GROUP_CONCAT(DISTINCT `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`id` SEPARATOR '$$##$$')
AS `ITEM_7`,
GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`users_id`, ' ',
`glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`alternative_email`)
SEPARATOR '$$##$$') AS `ITEM_7_2`,
`glpi_itilcategories`.`completename` AS `ITEM_8`, `glpi_tickets`.`due_date` AS `ITEM_9`, `glpi_tickets`.`status` AS `ITEM_9_status`, `glpi_tickets`.`id` AS id FROM `glpi_tickets` LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_a900a61824c3906cc82f90407e525192`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`tickets_id`
AND `glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`type`
= 1 )LEFT JOIN `glpi_users` AS `glpi_users_647c2805c3795643b0f52f520e7cdb86`
ON (`glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`users_id` = `glpi_users_647c2805c3795643b0f52f520e7cdb86`.`id`
) LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`tickets_id`
AND `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`type`
= 2 )LEFT JOIN `glpi_users` AS `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`
ON (`glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`users_id` = `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`id`
)LEFT JOIN `glpi_itilcategories`
ON (`glpi_tickets`.`itilcategories_id` = `glpi_itilcategories`.`id`
)LEFT JOIN `glpi_entities`
ON (`glpi_tickets`.`entities_id` = `glpi_entities`.`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_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_8fe4b8216083df6473c0597972c40717`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets_8fe4b8216083df6473c0597972c40717`.`tickets_id`
AND `glpi_groups_tickets_8fe4b8216083df6473c0597972c40717`.`type`
= 1 )LEFT JOIN `glpi_groups` AS `glpi_groups_77277850fac99c62dbc26a804f22f50c`
ON (`glpi_groups_tickets_8fe4b8216083df6473c0597972c40717`.`groups_id` = `glpi_groups_77277850fac99c62dbc26a804f22f50c`.`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_9201eed6268ba42a969f0541adcd73d9`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_9201eed6268ba42a969f0541adcd73d9`.`tickets_id`
AND `glpi_tickets_users_9201eed6268ba42a969f0541adcd73d9`.`type`
= 3 )LEFT JOIN `glpi_users` AS `glpi_users_a1c9cdee57b96c1259435fb94656bf07`
ON (`glpi_tickets_users_9201eed6268ba42a969f0541adcd73d9`.`users_id` = `glpi_users_a1c9cdee57b96c1259435fb94656bf07`.`id`
) LEFT JOIN `glpi_groups_tickets` AS `glpi_groups_tickets_9201eed6268ba42a969f0541adcd73d9`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets_9201eed6268ba42a969f0541adcd73d9`.`tickets_id`
AND `glpi_groups_tickets_9201eed6268ba42a969f0541adcd73d9`.`type`
= 3 )LEFT JOIN `glpi_groups` AS `glpi_groups_e2329ee8584cf5b8a84437506dd2ca66`
ON (`glpi_groups_tickets_9201eed6268ba42a969f0541adcd73d9`.`groups_id` = `glpi_groups_e2329ee8584cf5b8a84437506dd2ca66`.`id`
) LEFT JOIN `glpi_suppliers_tickets` AS `glpi_suppliers_tickets_74690f2626744a37ace4c70dd87cea83`
ON (`glpi_tickets`.`id` = `glpi_suppliers_tickets_74690f2626744a37ace4c70dd87cea83`.`tickets_id`
AND `glpi_suppliers_tickets_74690f2626744a37ace4c70dd87cea83`.`type`
= 2 )LEFT JOIN `glpi_suppliers` AS `glpi_suppliers_54b493b9140ea0c46d5e2442edf1b74e`
ON (`glpi_suppliers_tickets_74690f2626744a37ace4c70dd87cea83`.`suppliers_id` = `glpi_suppliers_54b493b9140ea0c46d5e2442edf1b74e`.`id`
) LEFT JOIN `glpi_groups_tickets` AS `glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83`
ON (`glpi_tickets`.`id` = `glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83`.`tickets_id`
AND `glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83`.`type`
= 2 )LEFT JOIN `glpi_groups` AS `glpi_groups_80a94b3f6bc6957c5f1fd062f3013524`
ON (`glpi_groups_tickets_74690f2626744a37ace4c70dd87cea83`.`groups_id` = `glpi_groups_80a94b3f6bc6957c5f1fd062f3013524`.`id`
) LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_c929cf9ec7348a7ddc947bee038ca5e8`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_c929cf9ec7348a7ddc947bee038ca5e8`.`tickets_id`
AND `glpi_tickets_users_c929cf9ec7348a7ddc947bee038ca5e8`.`type`
= 1 )LEFT JOIN `glpi_slts` AS `glpi_slts_slts_tto_id_bb5aab1a526f6069c73375c529fafec7`
ON (`glpi_tickets`.`slts_tto_id` = `glpi_slts_slts_tto_id_bb5aab1a526f6069c73375c529fafec7`.`id`
AND `glpi_slts_slts_tto_id_bb5aab1a526f6069c73375c529fafec7`.`type` = '1' )LEFT JOIN `glpi_slts` AS `glpi_slts_slts_ttr_id_f3aab278f60e510b77ec99388d401d84`
ON (`glpi_tickets`.`slts_ttr_id` = `glpi_slts_slts_ttr_id_f3aab278f60e510b77ec99388d401d84`.`id`
AND `glpi_slts_slts_ttr_id_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_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_ticketfollowups`
ON (`glpi_tickets`.`id` = `glpi_ticketfollowups`.`tickets_id`
)LEFT JOIN `glpi_requesttypes` AS `glpi_requesttypes_c38aefef0996a025032b9f8e81ceee2a`
ON (`glpi_ticketfollowups`.`requesttypes_id` = `glpi_requesttypes_c38aefef0996a025032b9f8e81ceee2a`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_c38aefef0996a025032b9f8e81ceee2a`
ON (`glpi_ticketfollowups`.`users_id` = `glpi_users_c38aefef0996a025032b9f8e81ceee2a`.`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_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_solutiontypes`
ON (`glpi_tickets`.`solutiontypes_id` = `glpi_solutiontypes`.`id`
) LEFT JOIN `glpi_ticketcosts`
ON (`glpi_tickets`.`id` = `glpi_ticketcosts`.`tickets_id`
) LEFT JOIN `glpi_problems_tickets`
ON (`glpi_tickets`.`id` = `glpi_problems_tickets`.`tickets_id`
) WHERE `glpi_tickets`.`is_deleted` = '0' AND ( `glpi_tickets`.`entities_id` IN ('2') ) AND ( ( `glpi_tickets`.`name` LIKE '%lockup%' OR `glpi_tickets`.`content` LIKE '%lockup%' OR `glpi_tickets`.`id` LIKE '%lockup%' OR `glpi_tickets`.`status` LIKE '%lockup%' OR `glpi_tickets`.`date` LIKE '%lockup%' OR `glpi_tickets`.`closedate` LIKE '%lockup%' OR `glpi_tickets`.`due_date` LIKE '%lockup%' OR IF(`glpi_tickets`.`due_date` IS NOT NULL
AND `glpi_tickets`.`status` <> 4
AND (`glpi_tickets`.`solvedate` > `glpi_tickets`.`due_date`
OR (`glpi_tickets`.`solvedate` IS NULL
AND `glpi_tickets`.`due_date` < NOW())),
1, 0) LIKE '%lockup%' OR `glpi_tickets`.`solvedate` LIKE '%lockup%' OR `glpi_tickets`.`date_mod` LIKE '%lockup%' OR `glpi_itilcategories`.`completename` LIKE '%lockup%' OR `glpi_entities`.`completename` LIKE '%lockup%' OR (((`glpi_users_users_id_lastupdater`.`realname` LIKE '%lockup%'
OR `glpi_users_users_id_lastupdater`.`firstname` LIKE '%lockup%'
OR `glpi_users_users_id_lastupdater`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_users_id_lastupdater`.`realname`, ' ', `glpi_users_users_id_lastupdater`.`firstname`) LIKE '%lockup%' )
) ) OR `glpi_tickets`.`time_to_own` LIKE '%lockup%' 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 '%lockup%' OR `glpi_tickets`.`type` LIKE '%lockup%' OR `glpi_items_tickets`.`itemtype` LIKE '%lockup%' OR `glpi_requesttypes`.`name` LIKE '%lockup%' OR `glpi_locations`.`completename` LIKE '%lockup%' OR (((`glpi_users_647c2805c3795643b0f52f520e7cdb86`.`realname` LIKE '%lockup%'
OR `glpi_users_647c2805c3795643b0f52f520e7cdb86`.`firstname` LIKE '%lockup%'
OR `glpi_users_647c2805c3795643b0f52f520e7cdb86`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_647c2805c3795643b0f52f520e7cdb86`.`realname`, ' ', `glpi_users_647c2805c3795643b0f52f520e7cdb86`.`firstname`) LIKE '%lockup%' )
) OR `glpi_tickets_users_a900a61824c3906cc82f90407e525192`.`alternative_email` LIKE '%lockup%' ) OR `glpi_groups_77277850fac99c62dbc26a804f22f50c`.`completename` LIKE '%lockup%' OR (((`glpi_users_users_id_recipient`.`realname` LIKE '%lockup%'
OR `glpi_users_users_id_recipient`.`firstname` LIKE '%lockup%'
OR `glpi_users_users_id_recipient`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_users_id_recipient`.`realname`, ' ', `glpi_users_users_id_recipient`.`firstname`) LIKE '%lockup%' )
) ) OR (((`glpi_users_a1c9cdee57b96c1259435fb94656bf07`.`realname` LIKE '%lockup%'
OR `glpi_users_a1c9cdee57b96c1259435fb94656bf07`.`firstname` LIKE '%lockup%'
OR `glpi_users_a1c9cdee57b96c1259435fb94656bf07`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_a1c9cdee57b96c1259435fb94656bf07`.`realname`, ' ', `glpi_users_a1c9cdee57b96c1259435fb94656bf07`.`firstname`) LIKE '%lockup%' )
) OR `glpi_tickets_users_9201eed6268ba42a969f0541adcd73d9`.`alternative_email` LIKE '%lockup%' ) OR `glpi_groups_e2329ee8584cf5b8a84437506dd2ca66`.`completename` LIKE '%lockup%' OR (((`glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`realname` LIKE '%lockup%'
OR `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`firstname` LIKE '%lockup%'
OR `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`realname`, ' ', `glpi_users_c5e682856a6d6fe48b5aed8f8b238708`.`firstname`) LIKE '%lockup%' )
) OR `glpi_tickets_users_74690f2626744a37ace4c70dd87cea83`.`alternative_email` LIKE '%lockup%' ) OR `glpi_suppliers_54b493b9140ea0c46d5e2442edf1b74e`.`name` LIKE '%lockup%' OR `glpi_groups_80a94b3f6bc6957c5f1fd062f3013524`.`completename` LIKE '%lockup%' OR `glpi_tickets_users_c929cf9ec7348a7ddc947bee038ca5e8`.`use_notification` LIKE '%lockup%' OR `glpi_tickets_users_c929cf9ec7348a7ddc947bee038ca5e8`.`alternative_email` LIKE '%lockup%' OR `glpi_slts_slts_tto_id_bb5aab1a526f6069c73375c529fafec7`.`name` LIKE '%lockup%' OR `glpi_slts_slts_ttr_id_f3aab278f60e510b77ec99388d401d84`.`name` LIKE '%lockup%' OR `glpi_slalevels_b3496fc202f417bdbcf7196c9852bb44`.`name` LIKE '%lockup%' OR `glpi_tickets`.`validation_percent` LIKE '%lockup%' OR `glpi_tickets`.`global_validation` IN ('lockup') OR `glpi_ticketvalidations`.`comment_submission` LIKE '%lockup%' OR `glpi_ticketvalidations`.`comment_validation` LIKE '%lockup%' OR `glpi_ticketvalidations`.`status` IN ('lockup') OR `glpi_ticketvalidations`.`submission_date` LIKE '%lockup%' OR `glpi_ticketvalidations`.`validation_date` LIKE '%lockup%' OR (((`glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`realname` LIKE '%lockup%'
OR `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`firstname` LIKE '%lockup%'
OR `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`realname`, ' ', `glpi_users_57751ba960bd8511d2ad8a01bd8487f4`.`firstname`) LIKE '%lockup%' )
) ) OR (((`glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`realname` LIKE '%lockup%'
OR `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`firstname` LIKE '%lockup%'
OR `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`realname`, ' ', `glpi_users_users_id_validate_57751ba960bd8511d2ad8a01bd8487f4`.`firstname`) LIKE '%lockup%' )
) ) OR `glpi_ticketsatisfactions`.`type` LIKE '%lockup%' OR `glpi_ticketsatisfactions`.`date_begin` LIKE '%lockup%' OR `glpi_ticketsatisfactions`.`date_answered` LIKE '%lockup%' OR `glpi_ticketsatisfactions`.`satisfaction` LIKE '%lockup%' OR `glpi_ticketsatisfactions`.`comment` LIKE '%lockup%' OR `glpi_ticketfollowups`.`content` LIKE '%lockup%' OR `glpi_ticketfollowups`.`date` LIKE '%lockup%' OR `glpi_requesttypes_c38aefef0996a025032b9f8e81ceee2a`.`name` LIKE '%lockup%' OR `glpi_ticketfollowups`.`is_private` LIKE '%lockup%' OR (((`glpi_users_c38aefef0996a025032b9f8e81ceee2a`.`realname` LIKE '%lockup%'
OR `glpi_users_c38aefef0996a025032b9f8e81ceee2a`.`firstname` LIKE '%lockup%'
OR `glpi_users_c38aefef0996a025032b9f8e81ceee2a`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_c38aefef0996a025032b9f8e81ceee2a`.`realname`, ' ', `glpi_users_c38aefef0996a025032b9f8e81ceee2a`.`firstname`) LIKE '%lockup%' )
) ) OR `glpi_tickets`.`solve_delay_stat` LIKE '%lockup%' OR `glpi_tickets`.`close_delay_stat` LIKE '%lockup%' OR `glpi_tickets`.`waiting_duration` LIKE '%lockup%' OR `glpi_tickets`.`takeintoaccount_delay_stat` LIKE '%lockup%' OR (((`glpi_tickets_tickets`.`tickets_id_1` = 'lockup'
OR `glpi_tickets_tickets`.`tickets_id_2` = 'lockup')
AND `glpi_tickets`.`id` <> 'lockup')
) OR (((`glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`.`tickets_id_1` = 'lockup'
OR `glpi_tickets_tickets_9b9f1a767329ed99d9c2a164b41de828`.`tickets_id_2` = 'lockup')
AND `glpi_tickets`.`id` <> 'lockup')
) OR `glpi_tickettasks`.`content` LIKE '%lockup%' OR `glpi_taskcategories_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%lockup%' OR `glpi_tickettasks`.`is_private` LIKE '%lockup%' OR (((`glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`realname` LIKE '%lockup%'
OR `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`firstname` LIKE '%lockup%'
OR `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`realname`, ' ', `glpi_users_e5ca2f53018fdc28a31faf534186b3a2`.`firstname`) LIKE '%lockup%' )
) ) OR (((`glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`realname` LIKE '%lockup%'
OR `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`firstname` LIKE '%lockup%'
OR `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%lockup%'
OR CONCAT(`glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`realname`, ' ', `glpi_users_users_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`firstname`) LIKE '%lockup%' )
) ) OR `glpi_groups_groups_id_tech_e5ca2f53018fdc28a31faf534186b3a2`.`name` LIKE '%lockup%' OR `glpi_tickettasks`.`actiontime` LIKE '%lockup%' OR `glpi_tickettasks`.`date` LIKE '%lockup%' OR `glpi_tickettasks`.`state` LIKE '%lockup%' OR `glpi_tickettasks`.`begin` LIKE '%lockup%' OR `glpi_tickettasks`.`end` LIKE '%lockup%' OR `glpi_solutiontypes`.`name` LIKE '%lockup%' OR `glpi_tickets`.`solution` LIKE '%lockup%' ) ) GROUP BY `glpi_tickets`.`id` ORDER BY ITEM_3 DESCGlpi ->0.90.1
PHP ->5.6.31
Apache ->2.4.27
MySQL ->5.6.27
Offline
#2 2017-10-11 17:08:49
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: Search All locks up database with a long running process.
You have this option in Setup > Global (last fields on bottom left
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline