Hi
My experience is that OTRS is extremely slow at search. Looking for all emails with a special FROM adr takes more time than it takes for google to look the whole internet for something. Is it problem with our setup or is it general issue?
Also when you have found number tickets and do something to one of tickets i.e. closing then you have repeat the slow search to see the tickets again. Kind annoying but not a big problem if search was fast.
Erling
OTRS and search
Moderator: crythias
-
- Znuny ninja
- Posts: 1029
- Joined: 13 Apr 2009, 12:26
- Znuny Version: 6.0.13
- Real Name: Wolfgang Fürtbauer
- Company: PBS Logitek GmbH
- Location: Pinsdorf
Re: OTRS and search
"slow on search" is a bit generic
probably you should start by checking performance of otrs by running Sysconfig -> [ Support Assessment ] and follow the instructions from there
also try the SQL on the left top of [ Support Assessment ] and check the values
another point is probably running mysqltuner https://github.com/rackerhacker/MySQLTuner-perl (if you run a MySQL database)
how about your hardware? is your IO throughput OK? Which discs (10K, 15K, ...)
enough memory? swapping
So, a lot you can do for your performance ...
Of course you can also install a 2700 mainboard performance cluster per shelf (how many shelfs would you like
)like google and your search will be a bit faster then
P.S: fill your signature please
probably you should start by checking performance of otrs by running Sysconfig -> [ Support Assessment ] and follow the instructions from there
also try the SQL on the left top of [ Support Assessment ] and check the values
another point is probably running mysqltuner https://github.com/rackerhacker/MySQLTuner-perl (if you run a MySQL database)
how about your hardware? is your IO throughput OK? Which discs (10K, 15K, ...)
enough memory? swapping
So, a lot you can do for your performance ...
Of course you can also install a 2700 mainboard performance cluster per shelf (how many shelfs would you like

P.S: fill your signature please
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
-
- Znuny newbie
- Posts: 5
- Joined: 13 Dec 2010, 15:52
- Znuny Version: 3.0.3not
- Real Name: Erling D. Andersen
- Company: MOSEK
- Contact:
Re: OTRS and search
I understand your point about hardware. But my OTRS installation is for a small (<=10) user OTRS installation. So if you compare the size of the hardware for us and Google and the size of databases, then my dedicated server is most likely bigger than all Googles data centers in a relative sense.
I would think that find find all tickets from certain email should be instantaneous. It is not. I can
I would think that find find all tickets from certain email should be instantaneous. It is not. I can
-
- Znuny ninja
- Posts: 1029
- Joined: 13 Apr 2009, 12:26
- Znuny Version: 6.0.13
- Real Name: Wolfgang Fürtbauer
- Company: PBS Logitek GmbH
- Location: Pinsdorf
Re: OTRS and search
eda - did you check the sysconfig -> Support assassement already?
what did mysqltuner say?
what did mysqltuner say?
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
-
- Znuny newbie
- Posts: 5
- Joined: 13 Dec 2010, 15:52
- Znuny Version: 3.0.3not
- Real Name: Erling D. Andersen
- Company: MOSEK
- Contact:
Re: OTRS and search
Hi
sqltuner said we run optimize on our table. We did not quite understand what you meant by
did you check the sysconfig -> Support assassement already?
what is the exact step to do it. Sorry about our ignorance.
sqltuner said we run optimize on our table. We did not quite understand what you meant by
did you check the sysconfig -> Support assassement already?
what is the exact step to do it. Sorry about our ignorance.
-
- Znuny ninja
- Posts: 1029
- Joined: 13 Apr 2009, 12:26
- Znuny Version: 6.0.13
- Real Name: Wolfgang Fürtbauer
- Company: PBS Logitek GmbH
- Location: Pinsdorf
Re: OTRS and search
if mysqltuner tells you: run optimize, please refer to the mysql admin docu
anyway, you can runfrom the commandline
For Support Assesement: go to [Admin] and you'll find it in the menu then
anyway, you can run
Code: Select all
mysqlcheck -o otrs
For Support Assesement: go to [Admin] and you'll find it in the menu then
Produktiv:
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
OTRS 6.0.13/ ITSM 6.0.13
OS: SUSE Linux (SLES 12, Leap), MySql 5.5.x, 5.6.x
Windows 2012 AD Integration (agents and customers), Nagios integration (incidents, CMDB), Survey, TimeAccounting
Re: OTRS and search
Search in OTRS is implemented in a very poor way. Don't expect it to get much faster than it is ... unless you touch the source code of course.