same issue here ... we migrated to a new server, when we upgraded to OTRS 6
our testenvironment is like 3 times faster than our production OTRS. The testsystem has only 1/4 of RAM and CPU.
All benchmarks were slower on the production system. We were not able to fix this until now
Search found 13 matches
- 24 Jan 2020, 12:42
- Forum: General
- Topic: 100% CPU usage after changing the server
- Replies: 25
- Views: 11279
- 10 Jan 2019, 11:21
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
Re: OTRS 5 to 6 - Performance and some other issues
while troubleshooting our performance issue, i found this query, which takes ages. # Thread_id: 20931 Schema: otrs_db QC_hit: No # Query_time: 5.047590 Lock_time: 0.000520 Rows_sent: 655 Rows_examined: 755596 SET timestamp=1547111492; SELECT DISTINCT st.id, st.tn, st.create_time FROM ticket st INNER...
- 10 Jan 2019, 09:47
- Forum: General
- Topic: Index Missing
- Replies: 1
- Views: 1881
Re: Index Missing
would you be so kind to tell us which index was missing and how you created it? i also got an OTRS 6 running, and Queue load really slow, while everything else is very fast. dashboard page load: 500ms queue page load with less than 10 tickets: 3000ms queue page load with 100 open tickets: up to 1900...
- 20 Dec 2018, 09:44
- Forum: General
- Topic: AgentTicketQueue slow
- Replies: 8
- Views: 11869
Re: AgentTicketQueue slow
sounds like this is our problem as well. got the error message "delta calculation took too long, aborting." from time to time and i can see the HTTPD processes using a lot of CPU when i browse the queues.
- 19 Dec 2018, 13:25
- Forum: General
- Topic: AgentTicketQueue slow
- Replies: 8
- Views: 11869
Re: AgentTicketQueue slow
have you been able to resolve this?
same problem here
same problem here
- 18 Dec 2018, 11:30
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
Re: OTRS 5 to 6 - Performance and some other issues
CacheTTL increased to 3600. OTRS Performance Log enabled. Its a little bit better today. A shoking information though: This is a sysbench OLTP Read Write Test with 64 threads on the livesystem: sysbench 1.0.9 (using system LuaJIT 2.0.4) Number of threads: 64 SQL statistics: queries performed: read: ...
- 17 Dec 2018, 11:47
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
Re: OTRS 5 to 6 - Performance and some other issues
There are 2 entries in our Config.pm about CacheTTL This one, which is not active: # # cache time to live in sec. - cache database queries # CacheTTL => 0, and This one, which is active and CacheTTL is 0 CustomerCompanyKey => 'customer_id', CustomerCompanyValid => 'valid_id', CustomerCompanyListFiel...
- 14 Dec 2018, 10:38
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
Re: OTRS 5 to 6 - Performance and some other issues
another thing that makes me think, that the DB is the bottleneck:
when i load the dashboard with all the settings active, it will take 4-5 seconds ... sometimes goes up to 8-10 seconds.
If i disable all settings, that will show me tickets, the page loads in less that a second.
when i load the dashboard with all the settings active, it will take 4-5 seconds ... sometimes goes up to 8-10 seconds.
If i disable all settings, that will show me tickets, the page loads in less that a second.
- 14 Dec 2018, 09:47
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
Re: OTRS 5 to 6 - Performance and some other issues
slow query log is enabled since yesterday evening. Until now, nothing was logged.
Also updated linux integration services yesterday.
will let you know if anything helps.
Also updated linux integration services yesterday.
will let you know if anything helps.
- 13 Dec 2018, 21:54
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
- 13 Dec 2018, 12:54
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
Re: OTRS 5 to 6 - Performance and some other issues
most of my problems are gone by now, but the performance is still an issue When i use Apache Benchmark to get some load, the server has some random lag on some of the tests. When i go hardcore and put in 1000 requests, the server goes into unresponsive mode for minutes. (same thing on the much less ...
- 13 Dec 2018, 10:46
- Forum: Allgemeines
- Topic: Fehlermeldung "Doppelter Eintrag"
- Replies: 4
- Views: 53402
Re: Fehlermeldung "Doppelter Eintrag"
hat sich hier noch etwas ergeben? Den gleichen Fehler habe ich in OTRS 6.0.14 auch.
- 07 Dec 2018, 10:36
- Forum: General
- Topic: OTRS 5 to 6 - Performance and some other issues
- Replies: 11
- Views: 4983
OTRS 5 to 6 - Performance and some other issues
Hi guys, im new on the board, but ive been reading here for a few years now and i was always amazed how crythias seems to have an answer to every OTRS question asked :D we ran an OTRS 5 on a CentOS 6 host that got migrated to a CentOS7 host using OTRS 6 (Community Edition). Performance is fine most ...