[otrs] OTRS6 performance

[Glen Eustace]

Our biggest issue is still the performance, OTRS5 used to hum along nicely on our hardware. OTR6 is pretty unusable at times it is SO SLOW.  I have had no success in actually identifying what is slow.  I did find an article regarding a potential missing index on a table and added it but it didn’t make much difference.  If anyone else has managed to fix the issue or you didnt see a slow down in performance after the upgrade, I’d love to know what is different between our environments.

We had OTRS5 on Fedora 24 but have OTRS6 on Centos7 with 4.13 kernel and Apache 2.4.6-67, perl 5.13. PosgreSQL 9.6.6 is on another server.

Any pointers would be appreciated.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 4446
Ph +64 6 357 8168, Mob +64 27 542 4015

“Specialising in providing low-cost professional Internet Services since 1997"

[Roy Kaldung]

Hi,

> On Jan 24, 2018, at 8:06 PM, Glen Eustace <geus...@godzone.net.nz> wrote:
>
> I did find an article regarding a potential missing index on a table and added it but it didn’t make much difference. If anyone else has managed to fix the issue or you didnt see a slow down in performance after the upgrade, I’d love to know what is different between our environments.

Did you enabled query logging in PostgreSQL? This should return problematic queries. And you should give the “Performance Log” of OTRS a chance.

- Roy

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

[Glen Eustace]

On 26/01/2018, at 5:46 AM, Roy Kaldung <kal...@gmail.com> wrote:

Did you enabled query logging in PostgreSQL? This should return problematic queries. And you should give the “Performance Log” of OTRS a chance.

Thanks.

I had already tried logging in postgresql and nothing really jumped out as being an issue.  I have enable the performance log so will see whether that shows anything interesting.

[aledr]

Extreme slow around here too.

Database Server:

    - openSUSE 42.1

    - Postgres 9.5.4

    - 4 vCPU

    - 8 GB RAM

Application Server :

    - openSUSE 42.3

    - Apache 2.4.23

    - 4 vCPU

    - 12 GB RAM

Here is performance log: https://file.io/dQvnzw

Thanks.

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

--

[ ]'s
Aledr - Alexandre

[Glen Eustace]

Just wanted to follow up.

Performance seems to be back to what we were having with OTRS 5 now that I have applied Patch Level 5, I notice Level 6 is now available so will apply that shortly.

Glen

[aledr]

Hi!

Moved to 6.0.6.

Agent Ticket Search for "new" and "open" costs 14 seconds.

Agent Ticket Zoom for tickets with only two articles costs 3 seconds.

Extreme slow.

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs