Stats Module very slow

Moderator: crythias

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

Stats Module very slow

Post by sebastianp »

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 6 | Ubuntu 18.04 | MySQL 5.7
amdkryn
Znuny expert
Posts: 187
Joined: 02 Oct 2012, 02:52
Znuny Version: 5.0.27

Re: Stats Module very slow

Post by amdkryn »

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
Administrator
Posts: 3931
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Stats Module very slow

Post by root »

Hi,

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

- 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 ?
sebastianp
Znuny newbie
Posts: 4
Joined: 08 Sep 2017, 10:48
Znuny Version: 5.0.19
Real Name: Sebastian
Company: Chrono24
Contact:

Re: Stats Module very slow

Post by sebastianp »

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 6 | Ubuntu 18.04 | MySQL 5.7
Post Reply