Hi,
I just saw that you're talking about page load times up to 20 seconds... that's far from that what I'm struggling with (1-2 seconds).
And I'm pretty sure that OTRS is not the root cause. Here're some simple checks you can try before pulling out the BFGs of performance analysis.
Make sure that DNS is working on your server - sometimes strange performance problems are related to misconfigured DNS.
After that you maybe you should try loading some static assets to check if it's not a L3 problem from your client to the server.
If that looks ok (requests per second should be around 2/sec mean) you maybe could take a look at the MySQL server.
# time mysql -h <mysql-fqdn> -u<mysql-username> -p<mysql-secret> -e 'SELECT count(tn) FROM ticket;' <otrs-database>
The "real" value should be something around "0m0.010s".
Next you can try to make a little more expensive query to the MySQL server
mysql> SELECT BENCHMARK(1000,(
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));
If the above statement finishes in round about 30ms your problem is probably not the MySQL server.
Regards,
Yves
No, ACLs are simple, as otrs is at start. No much agents and customers.
I didn't disable caching, as this will degrade performance also.
On 30.06.2016 18:14, Vogl, Yves wrote:
Just to make sure: Do you make heavy use of ACLs and maybe disabled caching for debugging purposes?
---------------------------------------------------------------------
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
