We have checked and there are no queries hanging in mysql.
Do you still need this information? I have to get it from the Database Administrator
Thank You
Dennis
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]
On Behalf Of Marc Bonsels
Sent: Thursday, February 26, 2015 3:49 PM
To: otrs@otrs.org
Subject: Re: [otrs] Otrs Slow Response/lockup
Hi Dennis,
Whats the value for innodb_log_file_size in your MySQL?
Marc
Am 26.02.15 um 19:17 schrieb Ritchie, Dennis:
Approximately every 2 days, I have to restart Apache and OTRS on my Centos 6.6, Mysql 5.6.16, Perl 5.10.1, and OTRS 4.03 System:
This is due to the following:
When I open up a browser window to log into the OTRS Application, I get a white screen, if I am already logged in and try to change screens, I get the spinning wheel of death.
Restarting Apache gives me a login screen.
I see in the Apache Access logs the following:
"GET / HTTP/1.1" 302 26 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.28 Safari/537.36"
And nothing in the error log at all.
I am seeing this approx. the same time as when I have a system slowdown (I have the performance log turned on):
Interface: Agent, Module: AgentTicketClose;TicketID=6208, Period: 2 minutes
DATE REQUESTS MIN MAX AVERAGE
02/26/2015 10:34 1 926s 926s 926s
Interface: Agent, Module: AgentTicketCompose&AJAXUpdate, Period: 2 minutes
DATE REQUESTS MIN MAX AVERAGE
02/26/2015 10:34 1 926s 926s 926s
Interface: Agent, Module: AgentTicketCompose&SendEmail, Period: 2 minutes
DATE REQUESTS MIN MAX AVERAGE
02/26/2015 10:35 1 926s 926s 926s
I am seeing this kind of response time in many different areas:
Interface: Agent, Module: AgentSearch&AJAX,
Interface: Agent, Module: AgentTicketAttachment;ArticleID
Interface: Agent, Module: AgentTicketZoom;TicketID=
Showing that the system is seeing a 15 1/2 minute time to do a job (if I am reading this correctly).
Other than all of the interface(s) being the Agent, Module something, there is nothing else common between all of the slowdowns.
Does anyone have any thoughts on where to look?
Thank You
Dennis Ritchie
IT
dritchie@mtcperformance.com
847.485.3608 Direct | 847.303.0022 Main | 847.303.0397 Fax
MTC Performance
1827 Walden Office Square, Suite 200Schaumburg, IL 60173
MTCPerformance | spiffs․com
---------------------------------------------------------------------OTRS mailing list: otrs - Webpage: http://otrs.org/Archive: http://lists.otrs.org/pipermail/otrsTo unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
--
--