Hello,
we have been using OTRS since 2016.
We are now using OTRS 6 (6.0.29) with Time Accounting plugin but we are facing really slow overall performance in particular with the Time Accounting section.
It takes about 30secs to load the Overwiew page and 10/15 secs to open a day to fill with the time accountings.
I have exported the statements of the sql server to gain some infos.
OTRS is running on a Ubuntu 18.04 LTS VM on an Hyper-V hosts. (attached infos)
Is there a way to understand what is slowing the time accounting section? It is frustrating to wait so much time every day.
Thank you very much.
OTRS 6 Time Accounting really slow
Moderator: crythias
-
- Znuny newbie
- Posts: 13
- Joined: 03 Nov 2016, 15:46
- Znuny Version: 6.0.29
- Real Name: Berardino Davide D'Agostino
- Company: CodeArchitects SysOps srl
OTRS 6 Time Accounting really slow
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 4011
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: OTRS 6 Time Accounting really slow
Hi,
Do you have enabled slow query logging? I guess there are indices missing. Log also queries wo/ using an index.
- Roy
Do you have enabled slow query logging? I guess there are indices missing. Log also queries wo/ using an index.
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 13
- Joined: 03 Nov 2016, 15:46
- Znuny Version: 6.0.29
- Real Name: Berardino Davide D'Agostino
- Company: CodeArchitects SysOps srl
Re: OTRS 6 Time Accounting really slow
Hello, thanks for your reply.
Attached the logs requested.
You do not have the required permissions to view the files attached to this post.
-
- Znuny newbie
- Posts: 13
- Joined: 03 Nov 2016, 15:46
- Znuny Version: 6.0.29
- Real Name: Berardino Davide D'Agostino
- Company: CodeArchitects SysOps srl
Re: OTRS 6 Time Accounting really slow
Hello,
do you have some suggestions?
Thank you
Re: OTRS 6 Time Accounting really slow
Hi,
Is your DB server running locally? Is it on SSDs?
I suggest that you follow the steps mentioned here and put the results here: http://perfdiag.lubik.ca
Is your DB server running locally? Is it on SSDs?
I suggest that you follow the steps mentioned here and put the results here: http://perfdiag.lubik.ca