Sometime OTRS gets too slow and I found this only when "copying tmp table" happening in mysql by show processlist command and which gets all tables locked and results otrs very slow or densest open and after this process completes, issue resolves .
What is the reason and solution for this.
otrs copying tmp table issue
Moderator: crythias
-
- Znuny newbie
- Posts: 59
- Joined: 24 Jul 2012, 18:20
- Znuny Version: 3.1.7
- Real Name: Girish Mungra
Re: otrs copying tmp table issue
i am having the same problem. Can anyone help?
OTRS 3.1.7 on Linux RedHat with MySQL database connected to an Active Directory for Agents and Customers.
Re: otrs copying tmp table issue
please consult your MySQL DBA. You need more resources and tuning on your mysql instance
"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