Too Slow Opening tickets and reviewing tickets

[hmaldonado]

OTRS4 is too slow since a week openning and revieweing tickets.

I searched for the Maintenance tasks and see those running every 15 days.

I did not see the: /opt/otrs/bin/otrs.CleanUp.pl

Any ideas?

Apr 24 00:20:01 15ctsf1051 CROND[2554]: (otrs) CMD ($HOME/bin/otrs.DeleteCache.pl --expired >> /dev/null)
Apr 24 00:30:02 15ctsf1051 CROND[2758]: (otrs) CMD ($HOME/bin/otrs.LoaderCache.pl -o delete >> /dev/null)
May 1 00:20:01 15ctsf1051 CROND[5287]: (otrs) CMD ($HOME/bin/otrs.DeleteCache.pl --expired >> /dev/null)
May 1 00:30:01 15ctsf1051 CROND[5509]: (otrs) CMD ($HOME/bin/otrs.LoaderCache.pl -o delete >> /dev/null)
May 8 00:20:01 15ctsf1051 CROND[21522]: (otrs) CMD ($HOME/bin/otrs.DeleteCache.pl --expired >> /dev/null)
May 8 00:30:01 15ctsf1051 CROND[21738]: (otrs) CMD ($HOME/bin/otrs.LoaderCache.pl -o delete >> /dev/null)
May 15 00:20:01 15ctsf1051 CROND[4439]: (otrs) CMD ($HOME/bin/otrs.DeleteCache.pl --expired >> /dev/null)
May 15 00:30:01 15ctsf1051 CROND[4649]: (otrs) CMD ($HOME/bin/otrs.LoaderCache.pl -o delete >> /dev/null)

[Giulio Soleni]

Hi,
if you have many (means thousands) tickets you may consider switching from RuntimeDB indexes to StaticDB indexes to improve the performances...

To do this you should change the following settings in SysConfig:

Kernel::System::Ticket::ArticleSearchIndex::RuntimeDB ...change to StaticDB
Kernel::System::Ticket::IndexAccelerator::RuntimeDB ...change to StaticDB

And then run the Index rebuilds from command line.
I do not remember the rebuild commands on OTRS 4 version ... on OTRS 5 there are three...
/opt/otrs/bin/otrs.Console.pl Maint::Ticket::FulltextIndexRebuild
/opt/otrs/bin/otrs.Console.pl Maint::Ticket::QueueIndexRebuild
/opt/otrs/bin/otrs.Console.pl Maint::Ticket::EscalationIndexRebuild

MIND that these rebuild commands may take a long time to complete: depending on the amount of tickets whose indexes need to be rebuilt FulltextIndexRebuild may take half an hour or even more...
I suggest to run them out of working hours

Another completely different cause that may affect the loading of webpages of OTRS consoles is a failed or poor internet connection.
You may take a look to the following settings...
Framework → Core::Package Package::Timeout
Framework → Core::WebUserAgent WebUserAgent::Timeout

HTH
Giulio

[hmaldonado]

Thanks Giulio¡¡
I'll checkthat...