Re: [otrs] Performance trouble,

Hi, please try to run the "ab" from your client which is expecting the poor performance. If you run it from another server you should also try to browse OTRS from this server (cURL, wget, lynx) to make sure that the performance issues are not L3 related. Otherwise the results aren't comparable. On the OTRS server please run: # time sudo -uotrs ./otrs.Console.pl Maint::Database::Check # sudo -uotrs ./otrs.Console.pl Dev::Tools::CacheBenchmark I'm not sure if unreachability could lead to bad user experience but you could also try to check if cloud services are reachable and not blocked by firewall. # sudo -uotrs ./otrs.Console.pl Maint::CloudServices::ConnectionCheck Regards, Yves

On 01 Jul 2016, at 09:55, Mimiko wrote:

So the results:

...

ab -n 100 -c 2 http://example.com/otrs-web/skins/Agent/default/css/thirdparty/fontawesome/f... This is ApacheBench, Version 2.3 <$Revision$> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking example.com (be patient).....done

Server Software: Apache/2.4.7 Server Hostname: example.com Server Port: 80

Document Path: /otrs-web/skins/Agent/default/css/thirdparty/fontawesome/fontawesome-webfont.svg Document Length: 313398 bytes

Concurrency Level: 2 Time taken for tests: 0.317 seconds Complete requests: 100 Failed requests: 0 Total transferred: 31376400 bytes HTML transferred: 31339800 bytes Requests per second: 315.12 [#/sec] (mean) Time per request: 6.347 [ms] (mean) Time per request: 3.173 [ms] (mean, across all concurrent requests) Transfer rate: 96556.71 [Kbytes/sec] received

Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.1 0 1 Processing: 4 6 1.7 6 13 Waiting: 0 4 2.2 4 11 Total: 4 6 1.8 6 13

Percentage of the requests served within a certain time (ms) 50% 6 66% 6 75% 7 80% 7 90% 8 95% 11 98% 12 99% 13 100% 13 (longest request)

-------------------

From another server:

...

ab -n 100 -c 2 http://example.com/otrs-web/skins/Agent/default/css/thirdparty/fontawesome/f... This is ApacheBench, Version 2.3 <$Revision: 1373084 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking example.com (be patient).....done

Server Software: Apache/2.4.7 Server Hostname: example.com Server Port: 80

Document Path: /otrs-web/skins/Agent/default/css/thirdparty/fontawesome/fontawesome-webfont.svg Document Length: 313398 bytes

Concurrency Level: 2 Time taken for tests: 0.689 seconds Complete requests: 100 Failed requests: 0 Write errors: 0 Total transferred: 31376400 bytes HTML transferred: 31339800 bytes Requests per second: 145.24 [#/sec] (mean) Time per request: 13.771 [ms] (mean) Time per request: 6.885 [ms] (mean, across all concurrent requests) Transfer rate: 44502.27 [Kbytes/sec] received

Connection Times (ms) min mean[+/-sd] median max Connect: 0 1 1.1 0 8 Processing: 8 13 4.4 12 38 Waiting: 3 6 3.4 4 26 Total: 9 14 4.6 13 38

Percentage of the requests served within a certain time (ms) 50% 13 66% 13 75% 15 80% 16 90% 20 95% 23 98% 29 99% 38 100% 38 (longest request)

------------------------------------

...

time mysql --host=ip --user=user --password=password -e 'select count(tn) from ticket;' otrs +-----------+ | count(tn) | +-----------+ | 139 | +-----------+

real 0m0.010s user 0m0.004s sys 0m0.000s

------------------------

...

time mysql --host=ip --user=user --password=password -e "SELECT BENCHMARK(1000,(SELECT t.tn FROM queue AS q, ticket AS t, article AS a, article_type AS a_t, ( SELECT _a.ticket_id, MAX(_a.create_time) AS create_time FROM ticket AS _t, ticket_state AS _t_s, article AS _a WHERE _t_s.name IN ('new', 'open') AND _t.ticket_state_id = _t_s.id AND _a.ticket_id = _t.id GROUP BY _a.ticket_id ) a_max WHERE q.id = t.queue_id AND t.id = a_max.ticket_id AND a.create_time = a_max.create_time AND a_t.id = a.article_type_id GROUP BY t.id ORDER BY a.create_time DESC LIMIT 0,1));" otrs +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | BENCHMARK(1000,(SELECT t.tn FROM queue AS q, ticket AS t, article AS a, article_type AS a_t, ( SELECT _a.ticket_id, MAX(_a.create_time) AS create_time FROM ticket AS _t, ticket_state AS _t_s, article AS _a WHERE _t_s.name IN ('new', 'open') AND _t.ticket_ | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 0 | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

real 0m0.013s user 0m0.004s sys 0m0.004s

This seems ok. So what could it be?

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

------------------------------------------------------- >>> business. people. technology. <<< ------------------------------------------------------- adesso AG mit Sitz in Dortmund Vorstand: Michael Kenfenheuer (Vors.), Christoph Junge, Andreas Prenneis Vorsitzender des Aufsichtsrates: Prof. Dr. Volker Gruhn Amtsgericht Dortmund HRB 20663