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