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 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> Para: glpi-dev@gna.org<mailto: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> 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. 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>> To: glpi-dev@gna.org<mailto: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>> 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>> To: glpi-dev@gna.org<mailto: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>> 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>> 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>> To: Liste de diffusion des developpeurs GLPI <glpi-dev@gna.org<mailto: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>> 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> 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> https://mail.gna.org/listinfo/glpi-dev ------------------------------ End of Glpi-dev Digest, Vol 119, Issue 5 ****************************************
_______________________________________________ Glpi-dev mailing list Glpi-dev@gna.org https://mail.gna.org/listinfo/glpi-dev
