So the results:
> ab -n 100 -c 2
http://example.com/otrs-web/skins/Agent/default/css/thirdparty/fontawesome/fontawesome-webfont.svg
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/fontawesome-webfont.svg
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
