
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"

Hi,
On Jan 24, 2018, at 8:06 PM, Glen Eustace
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

On 26/01/2018, at 5:46 AM, Roy Kaldung
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. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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"

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.
On Thu, Jan 25, 2018 at 4:51 PM, Glen Eustace
On 26/01/2018, at 5:46 AM, Roy Kaldung
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.
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 <+64%206-357%208168>, Mob +64 27 542 4015 <+64%2027%20542%204015>
“Specialising in providing low-cost professional Internet Services since 1997"
--------------------------------------------------------------------- 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

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 -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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"

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.
On Thu, Mar 15, 2018 at 4:51 PM, 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
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 <+64%206-357%208168>, Mob +64 27 542 4015 <+64%2027%20542%204015>
“Specialising in providing low-cost professional Internet Services since 1997"
--------------------------------------------------------------------- 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
participants (3)
-
aledr
-
Glen Eustace
-
Roy Kaldung