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.commailto:dritchie@mtcperformance.com 847.485.3608 Direct | 847.303.0022 Main | 847.303.0397 Fax MTC Performance 1827 Walden Office Square, Suite 200 Schaumburg, IL 60173 MTCPerformance | spiffs․com --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs -- -- Marc Bonsels Research & Development OTRS AG Norsk-Data-Straße 1 61352 Bad Homburg Germany T: +49 (0) 6172 681988 0 F: +49 (0) 9421 56818 18 I: http://www.otrs.com/ Business location: Bad Homburg, Country Court: Bad Homburg, HRB 10751, VAT ID: DE256610065 Chairman: Burchard Steinbild, Managing Board: André Mindermann (CEO), Christopher Kuhn, Sabine Riedel