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
