Very slow performance
Moderator: crythias
-
- Znuny newbie
- Posts: 16
- Joined: 21 Feb 2018, 10:31
- Znuny Version: 5.0.22
- Real Name: Juan Antonio Ramos
- Company: PharmaMar
Very slow performance
Hi all,
I'm running OTRS 5.0.22 with SUSE 12 SP3 over Oracle 11.2.0.4.0.
I have a very bad response time from my system. Not always, but very often. Two exaples:
- One user wants to open a ticket and press "New ticket". It takes up to 70 secs to open the next window with the fields to be fill.
- One agent wants to close a ticket. He press Close. A blank windows appears and it takes 70 secs to see the fields that must been filled.
Any ideas or suggestions?
Thanks in advanced and best regards.
//Juan
I'm running OTRS 5.0.22 with SUSE 12 SP3 over Oracle 11.2.0.4.0.
I have a very bad response time from my system. Not always, but very often. Two exaples:
- One user wants to open a ticket and press "New ticket". It takes up to 70 secs to open the next window with the fields to be fill.
- One agent wants to close a ticket. He press Close. A blank windows appears and it takes 70 secs to see the fields that must been filled.
Any ideas or suggestions?
Thanks in advanced and best regards.
//Juan
-
- Znuny wizard
- Posts: 380
- Joined: 20 Sep 2010, 16:54
- Znuny Version: OTRS 6 CE
- Real Name: Alexey Yusov
- Company: Radiant System Group s.r.o
- Location: Prague
- Contact:
Re: Very slow performance
Try to set Sendmail module in Framework->Core->Sendmail to DoNotSendEmail and check again. May be your email server is very slow. Could you please share History from any Ticket.
Alexey Yusov
Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal
Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal
Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
-
- Znuny newbie
- Posts: 16
- Joined: 21 Feb 2018, 10:31
- Znuny Version: 5.0.22
- Real Name: Juan Antonio Ramos
- Company: PharmaMar
Re: Very slow performance
Hi alexus,
I tried, but no success. Still the same poor performance.
Thanks
I tried, but no success. Still the same poor performance.
Thanks
Re: Very slow performance
Which DB are you using?
Are there any message in the logs?
Regards.
Are there any message in the logs?
Regards.
Re: Very slow performance
Hi,
60sec or 120sec delay is often a DNS issue. Did you check your network?
Flo
60sec or 120sec delay is often a DNS issue. Did you check your network?
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny newbie
- Posts: 16
- Joined: 21 Feb 2018, 10:31
- Znuny Version: 5.0.22
- Real Name: Juan Antonio Ramos
- Company: PharmaMar
Re: Very slow performance
Our DB is Oracle 11.2.0.4.0. There are no messages in the log that could help.
We have also check the network and it seems to be fine.
Anyone is also using Oracle? I have read that OTRS works better with MySQL, but it should also works fine with Oracle. Why not?
Thanks.
We have also check the network and it seems to be fine.
Anyone is also using Oracle? I have read that OTRS works better with MySQL, but it should also works fine with Oracle. Why not?
Thanks.
Re: Very slow performance
Hi,
i know systems using Oracle, working fine. So delays usually should not be based on the database type.
AFAIK MySQL + Postgres are more performant, but Oracle works fine. This is another issue, I think.
Flo
i know systems using Oracle, working fine. So delays usually should not be based on the database type.
AFAIK MySQL + Postgres are more performant, but Oracle works fine. This is another issue, I think.
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny newbie
- Posts: 16
- Joined: 21 Feb 2018, 10:31
- Znuny Version: 5.0.22
- Real Name: Juan Antonio Ramos
- Company: PharmaMar
Re: Very slow performance
Thanks Flo,
That's what I thought. But what people are recommended me is to change the database. I wouldn't like. Good to know that there are some other people running OTRS with Oracle with good performance.
Cheers.
//Juan A.
That's what I thought. But what people are recommended me is to change the database. I wouldn't like. Good to know that there are some other people running OTRS with Oracle with good performance.
Cheers.
//Juan A.
Re: Very slow performance
Hi,
as far as I know, OTRS does not perform that good with Oracle DB as other oracle-optimized applications. But it works fine. One delay might be, if the perl oracle driver starts the connection (some seconds) but once it is established, it's fast.
As I said, delays might be other issues. Do you have a load balancer for the oracle DB?
Flo
as far as I know, OTRS does not perform that good with Oracle DB as other oracle-optimized applications. But it works fine. One delay might be, if the perl oracle driver starts the connection (some seconds) but once it is established, it's fast.
As I said, delays might be other issues. Do you have a load balancer for the oracle DB?
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny newbie
- Posts: 16
- Joined: 21 Feb 2018, 10:31
- Znuny Version: 5.0.22
- Real Name: Juan Antonio Ramos
- Company: PharmaMar
Re: Very slow performance
Hi Flo,
I don't know exactly whay you mean by "a load balancer for the oracle DB". I'm not an Oracle expert.
Does OTRS on top of Oracle use a pool of connections to avoid open a new connection for each request ?
If yes, where can we check the configuration of this pool to ensure is configured correctly for our environment and it’s working as expected ?
Thanks and KR
//Juan A.
I don't know exactly whay you mean by "a load balancer for the oracle DB". I'm not an Oracle expert.
Does OTRS on top of Oracle use a pool of connections to avoid open a new connection for each request ?
If yes, where can we check the configuration of this pool to ensure is configured correctly for our environment and it’s working as expected ?
Thanks and KR
//Juan A.
Re: Very slow performance
Hi,
as I said, I would search for other causes.
One question would be if you use load balancer. It's your environment. You have to know this, or ask your network guys
It would be one possible root cause. (I still think, it's a DNS issue)
OTRS uses one connection only and can not balance by its own.
Flo
as I said, I would search for other causes.
One question would be if you use load balancer. It's your environment. You have to know this, or ask your network guys
It would be one possible root cause. (I still think, it's a DNS issue)
OTRS uses one connection only and can not balance by its own.
Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
-
- Znuny newbie
- Posts: 16
- Joined: 21 Feb 2018, 10:31
- Znuny Version: 5.0.22
- Real Name: Juan Antonio Ramos
- Company: PharmaMar
Re: Very slow performance
Hi Flo,
We don't have a network load balancer.
I'll check DNS, but we don't have any other issues like this with any othe application/system. Our network is working quite good.
Thanks for your help.
//Juan A.
We don't have a network load balancer.
I'll check DNS, but we don't have any other issues like this with any othe application/system. Our network is working quite good.
Thanks for your help.
//Juan A.
-
- Znuny newbie
- Posts: 16
- Joined: 21 Feb 2018, 10:31
- Znuny Version: 5.0.22
- Real Name: Juan Antonio Ramos
- Company: PharmaMar
Re: Very slow performance
Hi all,
We have migrated from Oracle to MariaDB and... problema solved!! Our OTRS is now about 25 times faster thna before. Amazing.
Cheers
We have migrated from Oracle to MariaDB and... problema solved!! Our OTRS is now about 25 times faster thna before. Amazing.
Cheers
Re: Very slow performance
I'm happy for you, in my case instead with MariaDB performance are not so good