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 <vbv...@gmail.com> wrote: > 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 >
--------------------------------------------------------------------- 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
