On 13.05.2014 17:30, Bogdan Iosif wrote:
You need to install a private MySQL instance for OTRS, on the same machine where the rest of OTRS components are installed (server 2: otrs, apache+modperl). I'm quite sure this will solve your performance problems.
I did some test on this: -------------------------------------------- Installed mysql on otrs server Mysql host on otrs configuration is 127.0.0.1 Result: SQL KEY VALUE TIME COMMENT Insert Time: 10000 3 s :-) Looks fine! Update Time: 10000 5 s :-) Looks fine! Select Time: 10000 5 s :-) Looks fine! Delete Time: 10000 4 s :-) Looks fine! Multiplier: * 1 s KEY VALUE TIME COMMENT Insert Time: 50000 16 s Ok Update Time: 50000 25 s :-) Looks fine! Select Time: 50000 25 s :-) Looks fine! Delete Time: 50000 21 s Ok Multiplier: * 5 s ---------------------------------- mysql is on otrs server Mysql host on otrs configuration is otrshost.com KEY VALUE TIME COMMENT Insert Time: 10000 4 s Ok Update Time: 10000 5 s :-) Looks fine! Select Time: 10000 4 s :-) Looks fine! Delete Time: 10000 5 s Ok Multiplier: * 1 s KEY VALUE TIME COMMENT Insert Time: 50000 17 s Ok Update Time: 50000 24 s :-) Looks fine! Select Time: 50000 25 s :-) Looks fine! Delete Time: 50000 21 s Ok Multiplier: * 5 s ----------------------------- mysql is on other server Mysql host on otrs configuration is ip of the mysql server KEY VALUE TIME COMMENT Insert Time: 10000 5 s Ok Update Time: 10000 5 s :-) Looks fine! Select Time: 10000 6 s Ok Delete Time: 10000 5 s Ok Multiplier: * 1 s KEY VALUE TIME COMMENT Insert Time: 50000 20 s Ok Update Time: 50000 25 s :-) Looks fine! Select Time: 50000 30 s Ok Delete Time: 50000 24 s Ok Multiplier: * 5 s -------------------------- mysql is on other server Mysql host on otrs configuration is mysqlhost.com KEY VALUE TIME COMMENT Insert Time: 10000 4 s Ok Update Time: 10000 5 s :-) Looks fine! Select Time: 10000 6 s Ok Delete Time: 10000 4 s :-) Looks fine! Multiplier: * 1 s KEY VALUE TIME COMMENT Insert Time: 50000 22 s Ok Update Time: 50000 26 s Ok Select Time: 50000 29 s Ok Delete Time: 50000 22 s Ok Multiplier: * 5 s ---------------------------------- mysql is on another server Mysql host on otrs configuration is mysqlhost.com In apache on otrs host following was changed: keepalive on UseCanonicalName off HostnameLookups off KEY VALUE TIME COMMENT Insert Time: 10000 4 s Ok Update Time: 10000 5 s :-) Looks fine! Select Time: 10000 6 s Ok Delete Time: 10000 4 s :-) Looks fine! Multiplier: * 1 s KEY VALUE TIME COMMENT Insert Time: 50000 20 s Ok Update Time: 50000 25 s :-) Looks fine! Select Time: 50000 29 s Ok Delete Time: 50000 22 s Ok Multiplier: * 5 s In all cases despite of different SQL Benchmark results, accessing tickets, dashboard, sysconfig remained same speed. -- Mimiko desu.