Moving OTRS to new server, very slow
Hi, I'm moving my old OTRS installation to a fresh server. In a later step, I want to upgrade to a newer version. New VM: Fresh Debian stable 64bit, dedicated mysql-server 5.6, OTRS 2.4.12 Old VM: Old Debian stable 32bit, small localhost mysql, OTRS 2.4.12 The old server is quite fast, the new is very slow: Response::Agent: 64s taken (URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich) Response::Agent: 63s taken (URL:Action=AdminLog:mdiederich) Response::Agent: 64s taken (URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich) Response::Agent: 64s taken (URL:Action=AdminLog:mdiederich) Response::Agent: 64s taken (URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich) Response::Agent: 63s taken (URL:Action=AdminLog:mdiederich) Response::Agent: 64s taken (URL:Action=AgentTicketQueue&QueueID=2&View=:mdiederich) Response::Agent: 64s taken (URL:Action=AdminLog:mdiederich) Response::Agent: 64s taken (URL:Action=AdminSysConfig&Subaction=Edit&SysConfigSubGroup=Core&SysConfigGroup=Framework&:mdiederich) Response::Agent: 63s taken (URL:Action=AdminLog:mdiederich) Response::Agent: 66s taken (URL:Action=AdminSysConfig&Subaction=Update:mdiederich) Response::Agent: 64s taken (URL:Action=AdminSysConfig&Subaction=Edit&SysConfigSubGroup=Core::PerformanceLog&SysConfigGroup=Framework&:mdiederich) # apache2ctl -M Loaded Modules: core_module (static) .... perl_module (shared) I use the apache2-httpd-new.include.conf and modified the otrs-2.4.12/scripts/apache2-perl-startup.pl: use DBD::mysql (); use Kernel::System::DB::mysql; I checked the DNS records, I checked the AdminLog and now I have no other ideas. CheckMXRecord is disabled Thanks for any help. -- Viele Grüße, Michael Diederich
Hi, On Wed, Oct 8, 2014 at 11:45 AM, Michael Diederich < michael.diederich@gmail.com> wrote:
Hi,
I'm moving my old OTRS installation to a fresh server. In a later step, I want to upgrade to a newer version.
New VM: Fresh Debian stable 64bit, dedicated mysql-server 5.6, OTRS 2.4.12 Old VM: Old Debian stable 32bit, small localhost mysql, OTRS 2.4.12
I moved the old localhost mysql to the decicated mysql-server. Still no
change - the old otrs is fast and the new otrs is terribly slow.
old server:
Apache/2.2.9
# apache2ctl -M
Loaded Modules:
...
cgi_module (shared)
...
perl_module (shared)
..
Syntax OK
#/etc/apache2/conf.d/otrs2
ScriptAlias /otrs/ "/opt/otrs/bin/cgi-bin/"
Alias /otrs-web/ "/opt/otrs/var/httpd/htdocs/"
No clue why, but for the future DenverCoder9: I installed the Apache2 DBD perl module: perl -MCPAN -e 'install Apache::DBI' and changed the apache2-perl-startup.pl use CGI (); CGI->compile(':all'); #use CGI (); #CGI->compile(':cgi'); use CGI::Carp (); use Apache::DBI (); Apache::DBI->connect_on_init('DBI:mysql:otrs;host=loadbalancer', 'otrs', '....'); use DBI (); and now it is as fast as the old system. I already migrated the old database to the new dedicated mysqlserver but this was not part of the problem (or of the solution). Michael
participants (1)
-
Michael Diederich