Slow performance on the database

Moderator: crythias

Post Reply
did12345
OTRS expert
Posts: 50
Joined: 04 Dec 2012, 15:24
OTRS Version?: 3.2.0

Slow performance on the database

Post by did12345 »

On OTRS 3.1.11 my users find that OTRS is very slow when they add a note to a ticket..

I did a benchmark on the system and here are the results:
Insert time : 4s
Update time: 7s
Select time: 7s --> should not take mothe than 6s on an average system
Delete time : 5s


Any ideas to improve theese timings?

I already added memory to the server (has actually 9GB) who's sole function is to host OTRS! ... :(
OTRS 4!

jojo
Moderator
Posts: 14636
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Slow performance on the database

Post by jojo »

Disk Speed could be also a cause for this
"Production": OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

arvas
OTRS newbie
Posts: 45
Joined: 15 Oct 2012, 09:08
OTRS Version?: 3.0.11

Re: Slow performance on the database

Post by arvas »

OTRS has a neat tool inside, i believe its called Support Assesmement inside the admin. See if you have any reds or yellows there.
I do not think you should do the OTRS benchmark, there is a big message saying do not do it on live machines :shock:
You might want to try hardware benchmarking tools if the Support assessment shows all clear, to check your harddisk and rams just in case.

did12345
OTRS expert
Posts: 50
Joined: 04 Dec 2012, 15:24
OTRS Version?: 3.2.0

Re: Slow performance on the database

Post by did12345 »

jojo wrote:Disk Speed could be also a cause for this
i'm going for disk speed and access... It's quite strange though, i have 10K RPM disks on my IBM x346 server....
and in the support assesment: everything is green! ...
OTRS 4!

CSL
OTRS wizard
Posts: 159
Joined: 11 Nov 2011, 19:27
OTRS Version?: 3.0.11

Re: Slow performance on the database

Post by CSL »

Check your database status: memory use, cache use, thread creation, cache sizes, etc. Check for swap use on the machine (any swap use is generally not good). Check database size - is it larger than 9GB? If so, your OS isn't going to be able to cache everything it will want to, and you'll probably be hitting disk access bottlenecks as the others have said when it has to unload and read new content into memory.

If you're using MySQL (? you haven't said) you can use a script such as mysqltuner to check these things for you and give recommendations:
https://github.com/rackerhacker/MySQLTuner-perl
Backend: OTRS 3.0.11 RedHat Enterprise Linux 6.2, Apache, MySQL with replication
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL

petiserk
OTRS newbie
Posts: 3
Joined: 15 Feb 2013, 17:36
OTRS Version?: 3.2---
Real Name: Peter Jagasits
Company: Kurt Co.
Contact:

Re: Slow performance on the database

Post by petiserk »

Hi did,

What is your architecture? Do you use Linux or Windows system? Where is your database on storage or local disk? What do you use, mysql or mssql?

Best Regards,
Peter

did12345
OTRS expert
Posts: 50
Joined: 04 Dec 2012, 15:24
OTRS Version?: 3.2.0

Re: Slow performance on the database

Post by did12345 »

hi i'm on a windows 2008 with mysql, storage is in on local disks
OTRS 4!

did12345
OTRS expert
Posts: 50
Joined: 04 Dec 2012, 15:24
OTRS Version?: 3.2.0

Re: Slow performance on the database

Post by did12345 »

CSL wrote:Check your database status: memory use, cache use, thread creation, cache sizes, etc. Check for swap use on the machine (any swap use is generally not good). Check database size - is it larger than 9GB? If so, your OS isn't going to be able to cache everything it will want to, and you'll probably be hitting disk access bottlenecks as the others have said when it has to unload and read new content into memory.

If you're using MySQL (? you haven't said) you can use a script such as mysqltuner to check these things for you and give recommendations:
https://github.com/rackerhacker/MySQLTuner-perl
Thnak you for your answer, the script only works on linux environments, sadly i'm on windows..

I just noticed in the logs, there is a persistant error as well:

[kernel:system:PID:PIDGET] unknown column 'process_change' in 'field list', SQL: 'SELECT Process_name, Process_id, Process_host, Process_create, Process_change'. rocess could not be found in the process table!


does anyone know how to stop this?
OTRS 4!

crythias
Moderator
Posts: 10110
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Slow performance on the database

Post by crythias »

rename the column without capital P.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask

spall
OTRS newbie
Posts: 5
Joined: 31 Jul 2012, 14:08
OTRS Version?: 3.1.7
Real Name: Simon Allison
Company: South Downs College

Re: Slow performance on the database

Post by spall »

Hi everyone,

There is a windows mysqltuner here

http://mysqltuner.codeplex.com/


hope this helps, I am about to try it myself.


Simon

Post Reply