Hello, To try to isolate problems, could you redo this query with ‘debug’ mode set? This mode is in the ‘super-admin’ user’s settings and it gives SQL queries execution times.
Could you also send to me your DB? I’ll try to import it on my Linux server and I’ll give you my results. Thank you, Regards, Olivier MORON Miscellaneous Program Member RAYNET SNC Tel : +33 4 76 33 49 52 Fax: +33 4 76 70 56 63 From: Glpi-dev [mailto:glpi-dev-boun...@gna.org] On Behalf Of Douglas P. Fernandes Sent: Wednesday, May 20, 2015 9:11 PM To: glpi-dev@gna.org Subject: Re: [Glpi-dev] Glpi-dev Digest, Vol 119, Issue 7 Hi, friends. We made some tests on GLPI Tables and some assays regarding queries, too. This query bellow performed 15 sec to retrieve data from DB, what enforces our idea toward problem related to query criteria, not DB at all. SELECT DISTINCT `glpi_users`.* FROM `glpi_users` LEFT JOIN `glpi_useremails` ON (`glpi_users`.`id` = `glpi_useremails`.`users_id`) 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 ('105') OR (`glpi_profiles_users`.`is_recursive`='1' AND `glpi_profiles_users`.`entities_id` IN ('0')) ) AND `glpi_users`.`is_deleted` = '0' AND `glpi_users`.`is_active` = '0' AND (`glpi_users`.`begin_date` IS NULL OR `glpi_users`.`begin_date` < NOW()) AND (`glpi_users`.`end_date` IS NULL OR `glpi_users`.`end_date` > NOW()) ORDER BY `glpi_users`.`firstname`, `glpi_users`.`realname`, `glpi_users`.`name` LIMIT 0,100; We made, too, the change to InnoDB approach, no visible effects. It seens, anyway, a problem related really about how search criteria are constructed. Is there a possibility to optimize this query? Best regards, Douglas Fernandes IT Specialist Grupo de Governança de TIC Coordenadoria de Infraestrutura de Tecnologia da Informação e Comunicação - COTEC SECRETARIA DO PLANEJAMENTO E GESTÃO - SEPLAG GOVERNO DO ESTADO DO CEARÁ ________________________________ De: glpi-dev-requ...@gna.org<mailto:glpi-dev-requ...@gna.org> Para: glpi-dev@gna.org<mailto:glpi-dev@gna.org> Enviadas: Quarta-feira, 20 de maio de 2015 11:57:41 Assunto: Glpi-dev Digest, Vol 119, Issue 7 Send Glpi-dev mailing list submissions to glpi-dev@gna.org<mailto:glpi-dev@gna.org> To subscribe or unsubscribe via the World Wide Web, visit https://mail.gna.org/listinfo/glpi-dev or, via email, send a message with subject or body 'help' to glpi-dev-requ...@gna.org<mailto:glpi-dev-requ...@gna.org> You can reach the person managing the list at glpi-dev-ow...@gna.org<mailto:glpi-dev-ow...@gna.org> When replying, please edit your Subject line so it is more specific than "Re: Contents of Glpi-dev digest..." Today's Topics: 1. Re: Evolutions GLPI - Appliquer une r?gle m?tiers ? la modification (David DURIEUX) 2. Re: GLPI with bootstrap template ( work in progress ) (Augusto Ferronato) 3. Re: Glpi-dev Digest, Vol 119, Issue 5 (Moron, Olivier) ---------------------------------------------------------------------- Message: 1 Date: Wed, 20 May 2015 16:37:32 +0200 From: David DURIEUX <d.duri...@siprossii.com<mailto:d.duri...@siprossii.com>> To: glpi-dev@gna.org<mailto:glpi-dev@gna.org> Subject: Re: [Glpi-dev] Evolutions GLPI - Appliquer une r?gle m?tiers ? la modification Message-ID: <20150520163732.7b6d5...@siprossii.com<mailto:20150520163732.7b6d5...@siprossii.com>> Content-Type: text/plain; charset=iso-8859-1 Le Wed, 20 May 2015 14:28:38 +0000 TEILLET Guillaume <teille...@cc-parthenay-gatine.fr<mailto:teille...@cc-parthenay-gatine.fr>> a ?crit: >J'ai oubli? de pr?ciser la version 0.84.4 et qu'il s'agit de la >modification du ticket. Sur la doc en ligne il est pr?cis? : " >Remarque : les r?gles m?tier pour les tickets ne sont jou?es qu'? la >cr?ation du ticket. Lors de la modification de celui-ci, aucun >m?canise automatique n'est lanc?." >http://www.glpi-project.org/DOC/FR/ ... C'est sur la derni?re stable que ?a a ?t? ajout? 0.85.x, donc effectivement, ?a ne fonctionnera pas en 0.84.x David ++ >Guillaume > >-----Message d'origine----- >De?: Glpi-dev [mailto:glpi-dev-boun...@gna.org] De la part de David >DURIEUX Envoy??: mercredi 20 mai 2015 15:59 >??: glpi-dev@gna.org<mailto:glpi-dev@gna.org> >Objet?: Re: [Glpi-dev] Evolutions GLPI - Appliquer une r?gle m?tiers ? >la modification > > >Le Wed, 20 May 2015 13:53:43 +0000 >TEILLET Guillaume ><teille...@cc-parthenay-gatine.fr<mailto:teille...@cc-parthenay-gatine.fr>> a >?crit: > >>Bonjour, >>Serait-il possible de permettre d'appliquer une r?gle m?tiers ? la >>modification ? Merci. >>M TEILLET > >Oui les r?gles peuvent ?tre jou?es lors de la modification de ticket, >donc on ne comprend pas la question... > > >David >++ > >_______________________________________________ >Glpi-dev mailing list >Glpi-dev@gna.org<mailto:Glpi-dev@gna.org> >https://mail.gna.org/listinfo/glpi-dev > >_______________________________________________ >Glpi-dev mailing list >Glpi-dev@gna.org<mailto:Glpi-dev@gna.org> >https://mail.gna.org/listinfo/glpi-dev ------------------------------ Message: 2 Date: Wed, 20 May 2015 11:44:01 -0300 From: Augusto Ferronato <augusto.ferron...@gmail.com<mailto:augusto.ferron...@gmail.com>> To: Liste de diffusion des developpeurs GLPI <glpi-dev@gna.org<mailto:glpi-dev@gna.org>> Subject: Re: [Glpi-dev] GLPI with bootstrap template ( work in progress ) Message-ID: <cap_n9_kg_d_xyhtr5hnz-ymg2-o2f0ucrpsgnhsm2ger9bb...@mail.gmail.com<mailto:cap_n9_kg_d_xyhtr5hnz-ymg2-o2f0ucrpsgnhsm2ger9bb...@mail.gmail.com>> Content-Type: text/plain; charset="utf-8" Hello, Great job, Have some material in english? Regards, 2015-05-20 5:57 GMT-03:00 Bernd Kammlott <bernd.kamml...@gmail.com<mailto:bernd.kamml...@gmail.com>>: > Hey! > > i am working on a new Interface for GLPI and whould like to contribute > this Interface to the GLPI Project. > > What i am currently working on: > > - basic template in glpi style > - separate as mutch html code from php logic as possible > - integrate a baisic template system > - add the possibility to overwrite templates ( logo + css in CI style ) > - Template will be responsive for mobile access > > If there are people who whould like to contribute to this interface please > contact me. > > You can check out the current version of the interace on this page: > > For username and password and source check: > https://www.kaneo-gmbh.de/glpi-with-bootstrap-theme.html > > GLPI Interface: > https://www.kaneo-gmbh.de/glpi-demo/ > > best regards > Bernd > > > > _______________________________________________ > Glpi-dev mailing list > Glpi-dev@gna.org<mailto:Glpi-dev@gna.org> > https://mail.gna.org/listinfo/glpi-dev > > -- ____________________ Jos? Augusto Ferronato -------------- next part -------------- An HTML attachment was scrubbed... URL: </public/glpi-dev/attachments/20150520/3082d1a2/attachment.html> ------------------------------ Message: 3 Date: Wed, 20 May 2015 14:57:28 +0000 From: "Moron, Olivier" <olivier.mo...@araymond.com<mailto:olivier.mo...@araymond.com>> To: Liste de diffusion des developpeurs GLPI <glpi-dev@gna.org<mailto:glpi-dev@gna.org>> Subject: Re: [Glpi-dev] Glpi-dev Digest, Vol 119, Issue 5 Message-ID: <080df555e8a78147a053578ec592e83901252d3...@arexch34.ar.ray.group<mailto:080df555e8a78147a053578ec592e83901252d3...@arexch34.ar.ray.group>> Content-Type: text/plain; charset="utf-8" Hello, There can be many bottlenecks in such queries: 1) Server perfs: you must check how it behaves when doing the requests 2) mySQL perfs: same remark 3) PHP perfs: if server CPU is low and MySQL also then it can come from PHP computing, 4) Network perfs: at the end if nothing previously noted seems to fit the trouble, then it can come from network bandwith. At the end several solutions can be applied depending on the fine analysis done above ?. You may update your server so that you can use Apache2.4 and PHP5-FPM fastcgi, Which OS are you using? Windows or Linux? If Linux, you may also use HHVM instead of PHP5-FPM. HHVM is a JIT compiler for PHP (used by Facebook servers): speed gain is somewhere between 2 and 10. You can also use MariaDB (which is a binary replacement for MySQL (but with better perf). And you may convert myISAM tables to INNODB (which gives the possibility to load into memory the complete database, and such speed during queries). This is my 1 cent contribution ?, Regards, Olivier MORON Miscellaneous Program Member RAYNET SNC Tel : +33 4 76 33 49 52 Fax: +33 4 76 70 56 63 From: Glpi-dev [mailto:glpi-dev-boun...@gna.org] On Behalf Of Douglas P. Fernandes Sent: Wednesday, May 20, 2015 4:27 PM To: glpi-dev@gna.org<mailto:glpi-dev@gna.org> Subject: Re: [Glpi-dev] Glpi-dev Digest, Vol 119, Issue 5 Following informations, GLPI version: 0.85.4 Server (physical): CPU Intel Xeon E5620 2.40GHz, RAM 8GB (1.5GB free), Not Swap Web server: Apache 2.2.9-10 PHP release: 5.3.3-7 SQL application, and engine: MySQL 5.1.49-3 Queries: 1 - Search Requester in "Assistance>Tickets" (47 sec); 2 - Time to loading "Administration>Users" (12 sec); 3 - Search Users in "Administration>Users" (8 sec). Best regards, Douglas Fernandes IT Specialist Grupo de Governan?a de TIC Coordenadoria de Infraestrutura de Tecnologia da Informa??o e Comunica??o - COTEC SECRETARIA DO PLANEJAMENTO E GEST?O - SEPLAG GOVERNO DO ESTADO DO CEAR? ________________________________ De: glpi-dev-requ...@gna.org<mailto:glpi-dev-requ...@gna.org<mailto:glpi-dev-requ...@gna.org%3cmailto:glpi-dev-requ...@gna.org>> Para: glpi-dev@gna.org<mailto:glpi-dev@gna.org<mailto:glpi-dev@gna.org%3cmailto:glpi-dev@gna.org>> Enviadas: Quarta-feira, 20 de maio de 2015 10:02:09 Assunto: Glpi-dev Digest, Vol 119, Issue 5 Send Glpi-dev mailing list submissions to glpi-dev@gna.org<mailto:glpi-dev@gna.org<mailto:glpi-dev@gna.org%3cmailto:glpi-dev@gna.org>> To subscribe or unsubscribe via the World Wide Web, visit https://mail.gna.org/listinfo/glpi-dev or, via email, send a message with subject or body 'help' to glpi-dev-requ...@gna.org<mailto:glpi-dev-requ...@gna.org<mailto:glpi-dev-requ...@gna.org%3cmailto:glpi-dev-requ...@gna.org>> You can reach the person managing the list at glpi-dev-ow...@gna.org<mailto:glpi-dev-ow...@gna.org<mailto:glpi-dev-ow...@gna.org%3cmailto:glpi-dev-ow...@gna.org>> When replying, please edit your Subject line so it is more specific than "Re: Contents of Glpi-dev digest..." Today's Topics: 1. Request for analysis of response time issue (Douglas P. Fernandes) 2. Re: Request for analysis of response time issue (David DURIEUX) 3. Re: Request for analysis of response time issue (Moron, Olivier) ---------------------------------------------------------------------- Message: 1 Date: Wed, 20 May 2015 09:45:10 -0300 (BRT) From: "Douglas P. Fernandes" <douglas.fernan...@seplag.ce.gov.br<mailto:douglas.fernan...@seplag.ce.gov.br<mailto:douglas.fernan...@seplag.ce.gov.br%3cmailto:douglas.fernan...@seplag.ce.gov.br>>> To: glpi-dev@gna.org<mailto:glpi-dev@gna.org<mailto:glpi-dev@gna.org%3cmailto:glpi-dev@gna.org>> Subject: [Glpi-dev] Request for analysis of response time issue Message-ID: <59863347.13920691.1432125910402.javamail.zim...@seplag.ce.gov.br<mailto:59863347.13920691.1432125910402.javamail.zim...@seplag.ce.gov.br<mailto:59863347.13920691.1432125910402.javamail.zim...@seplag.ce.gov.br%3cmailto:59863347.13920691.1432125910402.javamail.zim...@seplag.ce.gov.br>>> Content-Type: text/plain; charset="utf-8" Dear Representative. We are committed to adopt GLPI here, at Seplag (Seplag is a State Secretary, State of Cear?). We have 150 thousand potential users, among all the public users. At assay phase, we found a problem regarding Requester, Ticket Form: search. It takes 47 seconds to retrieve data. The same search, at Administration ? User, takes about 08 (eight) seconds. It seems to us that a response time of 8 seconds is too much, let alone 47 seconds. We wonder if there's a way to enhance this search mechanism? If so, this would be decisive for our intent to adopt this excellent software. Best regards, Att, Douglas Fernandes Especialista em TI Grupo de Governan?a de TIC Coordenadoria de Infraestrutura de Tecnologia da Informa??o e Comunica??o - COTEC SECRETARIA DO PLANEJAMENTO E GEST?O - SEPLAG (85) 3101-4540 / (85) 9121-9564 -------------- next part -------------- An HTML attachment was scrubbed... URL: </public/glpi-dev/attachments/20150520/c4c799dd/attachment.html> ------------------------------ Message: 2 Date: Wed, 20 May 2015 14:56:56 +0200 From: David DURIEUX <d.duri...@siprossii.com<mailto:d.duri...@siprossii.com<mailto:d.duri...@siprossii.com%3cmailto:d.duri...@siprossii.com>>> To: glpi-dev@gna.org<mailto:glpi-dev@gna.org<mailto:glpi-dev@gna.org%3cmailto:glpi-dev@gna.org>> Subject: Re: [Glpi-dev] Request for analysis of response time issue Message-ID: <20150520145656.18de7...@siprossii.com<mailto:20150520145656.18de7...@siprossii.com<mailto:20150520145656.18de7...@siprossii.com%3cmailto:20150520145656.18de7...@siprossii.com>>> Content-Type: text/plain; charset=utf-8 Le Wed, 20 May 2015 09:45:10 -0300 (BRT) "Douglas P. Fernandes" <douglas.fernan...@seplag.ce.gov.br<mailto:douglas.fernan...@seplag.ce.gov.br<mailto:douglas.fernan...@seplag.ce.gov.br%3cmailto:douglas.fernan...@seplag.ce.gov.br>>> a ?crit: > > >Dear Representative. > Hi > > >We are committed to adopt GLPI here, at Seplag (Seplag is a State >Secretary, State of Cear?). We have 150 thousand potential users, >among all the public users. > > > > >At assay phase, we found a problem regarding Requester, Ticket Form: >search. It takes 47 seconds to retrieve data. The same search, at >Administration ? User, takes about 08 (eight) seconds. It seems to us >that a response time of 8 seconds is too much, let alone 47 seconds. >We wonder if there's a way to enhance this search mechanism? If so, >this would be decisive for our intent to adopt this excellent >software. It's not normal, give the version of: * PHP * MySQL Is the server swap ? David ++ > > >Best regards, > > >Att, > >Douglas Fernandes >Especialista em TI >Grupo de Governan?a de TIC >Coordenadoria de Infraestrutura de Tecnologia >da Informa??o e Comunica??o - COTEC >SECRETARIA DO PLANEJAMENTO E GEST?O - SEPLAG > >(85) 3101-4540 / (85) 9121-9564 > ------------------------------ Message: 3 Date: Wed, 20 May 2015 13:01:54 +0000 From: "Moron, Olivier" <olivier.mo...@araymond.com<mailto:olivier.mo...@araymond.com<mailto:olivier.mo...@araymond.com%3cmailto:olivier.mo...@araymond.com>>> To: Liste de diffusion des developpeurs GLPI <glpi-dev@gna.org<mailto:glpi-dev@gna.org<mailto:glpi-dev@gna.org%3cmailto:glpi-dev@gna.org>>> Subject: Re: [Glpi-dev] Request for analysis of response time issue Message-ID: <080df555e8a78147a053578ec592e83901252d2...@arexch34.ar.ray.group<mailto:080df555e8a78147a053578ec592e83901252d2...@arexch34.ar.ray.group<mailto:080df555e8a78147a053578ec592e83901252d2...@arexch34.ar.ray.group%3cmailto:080df555e8a78147a053578ec592e83901252d2...@arexch34.ar.ray.group>>> Content-Type: text/plain; charset="utf-8" Hello, I may help you, but I need a little bit more info about your configuration. Which GLPI version? What is the server (virtual or physical, CPU, RAM, HDD,?)? What is the web server? What is the PHP release? What is the SQL application, and engine (MySQL, MariaDB, MyISAM, INNODB)? What queries did you do to get this figures? ? Here is our current configuration: Server: Windows 2008 R2 (on a ESX VMWare) 64bits CPU: 4 cores RAM: 8GB HD: 20GB Web server: IIS7 (64bits) PHP: 5.4.14 64bits DB: MySQL 5.6.10 64bits DB Engine: myISAM DB size is 3GB Records figures: Ticket qt: 188640 Users: 7941 Entities: 970 Computers: 11462 Software: 231143 Logs: 15818092 They are some solution to improve Tickets and Users default requests, but you need to touch a little bit source files. Regards, Olivier MORON Miscellaneous Program Member RAYNET SNC Tel : +33 4 76 33 49 52 Fax: +33 4 76 70 56 63 From: Glpi-dev [mailto:glpi-dev-boun...@gna.org] On Behalf Of Douglas P. Fernandes Sent: Wednesday, May 20, 2015 2:45 PM To: glpi-dev@gna.org<mailto:glpi-dev@gna.org<mailto:glpi-dev@gna.org%3cmailto:glpi-dev@gna.org>> Subject: [Glpi-dev] Request for analysis of response time issue Dear Representative. We are committed to adopt GLPI here, at Seplag (Seplag is a State Secretary, State of Cear?). We have 150 thousand potential users, among all the public users. At assay phase, we found a problem regarding Requester, Ticket Form: search. It takes 47 seconds to retrieve data. The same search, at Administration ? User, takes about 08 (eight) seconds. It seems to us that a response time of 8 seconds is too much, let alone 47 seconds. We wonder if there's a way to enhance this search mechanism? If so, this would be decisive for our intent to adopt this excellent software. Best regards, Att, Douglas Fernandes Especialista em TI Grupo de Governan?a de TIC Coordenadoria de Infraestrutura de Tecnologia da Informa??o e Comunica??o - COTEC SECRETARIA DO PLANEJAMENTO E GEST?O - SEPLAG (85) 3101-4540 / (85) 9121-9564 -------------- next part -------------- An HTML attachment was scrubbed... URL: </public/glpi-dev/attachments/20150520/db40be19/attachment.html> ------------------------------ Subject: Digest Footer _______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org<mailto:Glpi-dev@gna.org<mailto:Glpi-dev@gna.org%3cmailto:Glpi-dev@gna.org>> https://mail.gna.org/listinfo/glpi-dev ------------------------------ End of Glpi-dev Digest, Vol 119, Issue 5 **************************************** -------------- next part -------------- An HTML attachment was scrubbed... URL: </public/glpi-dev/attachments/20150520/e03a68cf/attachment.html> ------------------------------ Subject: Digest Footer _______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org<mailto:Glpi-dev@gna.org> https://mail.gna.org/listinfo/glpi-dev ------------------------------ End of Glpi-dev Digest, Vol 119, Issue 7 ****************************************
_______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org https://mail.gna.org/listinfo/glpi-dev
