OTRS 6 Time Accounting really slow

Moderator: crythias

Post Reply
bddagostino
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

Post by bddagostino »

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.
You do not have the required permissions to view the files attached to this post.
root
Administrator
Posts: 3934
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

Post by root »

Hi,

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 ?
bddagostino
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

Post by bddagostino »

root wrote: 16 Apr 2021, 22:25 Hi,

Do you have enabled slow query logging? I guess there are indices missing. Log also queries wo/ using an index.

- Roy
Hello, thanks for your reply.

Attached the logs requested.
You do not have the required permissions to view the files attached to this post.
bddagostino
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

Post by bddagostino »

bddagostino wrote: 19 Apr 2021, 16:08
root wrote: 16 Apr 2021, 22:25 Hi,

Do you have enabled slow query logging? I guess there are indices missing. Log also queries wo/ using an index.

- Roy
Hello, thanks for your reply.

Attached the logs requested.
Hello,

do you have some suggestions?

Thank you
ugob
Znuny newbie
Posts: 52
Joined: 29 Jul 2011, 22:15
Znuny Version: 3.0

Re: OTRS 6 Time Accounting really slow

Post by ugob »

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
Post Reply