OTRS Performance Degraded

Moderator: crythias

Locked
flippertom
Znuny advanced
Posts: 120
Joined: 16 Apr 2015, 08:42
Znuny Version: 3.2.16

OTRS Performance Degraded

Post by flippertom »

Sometimes login to OTRS is very slow.
Once logged in, viewing tickets works at normal speed.
However, opening new phone ticket page and saving the ticket takes long time.(upto 2-5 minutes at times).
This effect lasts for about 10 mins after which everything works at normal speed.

There are not jobs running at such times and database queries are executed at normal speed.
What could be the cause of this degraded performance?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS Performance Degraded

Post by crythias »

email not being able to send notifications.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS Performance Degraded

Post by jojo »

rebuild of caches (and slow cache backend)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
flippertom
Znuny advanced
Posts: 120
Joined: 16 Apr 2015, 08:42
Znuny Version: 3.2.16

Re: OTRS Performance Degraded

Post by flippertom »

But would emails cause the login to be slow?
Or does it cause the whole system to be slow in general.

And how to tackle both these cases...emails and slow cache...?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS Performance Degraded

Post by crythias »

Login? You said after login.
Specifically after saving ticket. Check the logs.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
flippertom
Znuny advanced
Posts: 120
Joined: 16 Apr 2015, 08:42
Znuny Version: 3.2.16

Re: OTRS Performance Degraded

Post by flippertom »

When I noticed the slow performance, I logged out and when I logged in again, even the log in took long time.
Will check the log next time the issue is reported after saving a ticket.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: OTRS Performance Degraded

Post by crythias »

If the login is taking a long time, then check how authentication is provisioned. If it's built-in versus external (like ldap/Active Directory) the built-in authentication appears to be problems with the database structure (could be, or just bad hardware). Check for the usual suspects: table crashes, filesystem issues, RAM and CPU utilization, etc.

External authentication or demographics may be a network connectivity issue, especially if at least one of the sources is unreachable.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked