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?