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
Stats Module very slow
Moderator: crythias
-
- 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
OTRS 6 | Ubuntu 18.04 | MySQL 5.7
Re: Stats Module very slow
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.
-
- Administrator
- Posts: 3976
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Stats Module very slow
Hi,
I suggest enabling slow query log for MySQL and considering (after analysis) working with a mirror db
- Roy
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 ?
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: 4
- Joined: 08 Sep 2017, 10:48
- Znuny Version: 5.0.19
- Real Name: Sebastian
- Company: Chrono24
- Contact:
Re: Stats Module very slow
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
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