I don't have any other ideas then. Try using a more common Linux distro and
try both 32 and 64 bit Apache + mod_perl.
Your hardware seems slow as far as MySQL is concerned and the CPU is
probably also slow. Based on what I've seen on my system, the CPU is indeed
the bottleneck for OTRS but I thought my hardware is crap and when I saw
it's at least twice as fast as yours, I thought that's the problem.
On Wed, May 14, 2014 at 9:00 AM, Mimiko
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. --------------------------------------------------------------------- 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