Slow performance on the database
Moderator: crythias
Slow performance on the database
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! ...
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!
Re: Slow performance on the database
Disk Speed could be also a cause for this
"Production": OTRS™ 8, 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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Re: Slow performance on the database
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
You might want to try hardware benchmarking tools if the Support assessment shows all clear, to check your harddisk and rams just in case.
I do not think you should do the OTRS benchmark, there is a big message saying do not do it on live machines
You might want to try hardware benchmarking tools if the Support assessment shows all clear, to check your harddisk and rams just in case.
Re: Slow performance on the database
i'm going for disk speed and access... It's quite strange though, i have 10K RPM disks on my IBM x346 server....jojo wrote:Disk Speed could be also a cause for this
and in the support assesment: everything is green! ...
OTRS 4!
Re: Slow performance on the database
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
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
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
-
- Znuny newbie
- Posts: 3
- Joined: 15 Feb 2013, 17:36
- Znuny Version: 3.2---
- Real Name: Peter Jagasits
- Company: Kurt Co.
Re: Slow performance on the database
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
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
Re: Slow performance on the database
hi i'm on a windows 2008 with mysql, storage is in on local disks
OTRS 4!
Re: Slow performance on the database
Thnak you for your answer, the script only works on linux environments, sadly i'm on windows..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
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!
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Slow performance on the database
rename the column without capital P.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
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
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
-
- Znuny newbie
- Posts: 5
- Joined: 31 Jul 2012, 14:08
- Znuny Version: 3.1.7
- Real Name: Simon Allison
- Company: South Downs College
Re: Slow performance on the database
Hi everyone,
There is a windows mysqltuner here
http://mysqltuner.codeplex.com/
hope this helps, I am about to try it myself.
Simon
There is a windows mysqltuner here
http://mysqltuner.codeplex.com/
hope this helps, I am about to try it myself.
Simon