Stats Module very slow

Moderator: crythias

Post Reply
sebastianp
OTRS newbie
Posts: 2
Joined: 08 Sep 2017, 10:48
OTRS Version?: 5.0.19
Real Name: Sebastian
Company: Chrono24
Contact:

Stats Module very slow

Post by sebastianp » 08 Nov 2017, 14:29

Hi Community,

we're having problems with the statistics module. Within creating or editing a statistic, it takes ages (up to 30 sec) to reload the page after every single click (Change X/Y-Axis, set filters, Save, and so on). This occurs only within the stats module, everything else works just fast as expected.

What I already know:
- MySQL seems not to be the problem, no slow queries.
- apache2 log says nothing special:
10.xx.xx.xx - - [08/Nov/2017:13:21:20 +0100] "GET /index.pl?Action=AgentStatistics;Subaction=Edit;StatID=7 HTTP/1.1" 200 1200792
- While a page is loading, the process is blocking one CPU core competely:
/index.pl?Action=AgentStatistics;Subaction=Edit;StatID=7 HT
- OTRS SupportData is all green.

maybe helpful:
- OTRS 5.0.19
- ubuntu 16.04
- mysql 5.7
- OS and Database on local SSD storage
- Articlestorage is on a NFS filesystem, which is not superfast. Might this be the problem?

has anyone seen this problem before or even a clue how to get this fixed?

Thanks a lot in advance
OTRS 5.0.19 | Ubuntu 16.04 | MySQL 5.7

amdkryn
OTRS wizard
Posts: 185
Joined: 02 Oct 2012, 02:52
OTRS Version?: 5.0.27

Re: Stats Module very slow

Post by amdkryn » 27 Mar 2018, 15:09

Hi, sorry to update the post without a solution but I have the same problem as you. Have you found a solution?
OTRS version 5.0.27 (With ITSM), Operating System OpenSuse 12 with Mysql.

root
Moderator
Posts: 1312
Joined: 18 Dec 2007, 12:23
OTRS Version?: 4/5/6
Real Name: Roy Kaldung
Company: Znuny Inc.
Contact:

Re: Stats Module very slow

Post by root » 27 Mar 2018, 18:46

Hi,

I suggest enabling slow query log for MySQL and considering (after analysis) working with a mirror db

- Roy
OTRS 4/5/6 CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

You need professional services? Check out https://www.znuny.com/

sebastianp
OTRS newbie
Posts: 2
Joined: 08 Sep 2017, 10:48
OTRS Version?: 5.0.19
Real Name: Sebastian
Company: Chrono24
Contact:

Re: Stats Module very slow

Post by sebastianp » 06 Aug 2018, 09:30

Hi,

as mentioned above, there are no slow quereies logged.
I did not find a solution for this yet. I built some own sql queries to get my statistics.

Cheers
Seb
OTRS 5.0.19 | Ubuntu 16.04 | MySQL 5.7

Post Reply