Search found 13 matches

by obione85
24 Jan 2020, 12:42
Forum: General
Topic: 100% CPU usage after changing the server
Replies: 25
Views: 11279

Re: 100% CPU usage after changing the server

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 :(
by obione85
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...
by obione85
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...
by obione85
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.
by obione85
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 :(
by obione85
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: ...
by obione85
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...
by obione85
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.
by obione85
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.
by obione85
13 Dec 2018, 21: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

root wrote: 13 Dec 2018, 13:35 Hi,

How many escalated tickets do you have in your system and what's the average age of them?

- Roy
71 escalated and the average should be around 30 days. Top 10 is more than 200 Days old.
by obione85
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 ...
by obione85
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.
by obione85
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 ...