OTRS extremely slow

[Eraserhead]

Hi,

OTRS is very slow for me. I'm the only user on the system right now. It is installed on a VPS with 512MB virtual RAM and 1Ghz virtual CPU.

I have enabled the performance log, i see a lot of extreme response times which correspond with my experience. Only i have no idea how to improve them. Any help will be appreciated!

otrsperformance.JPG

[Wolfgangf]

512MB RAM look rather small for database, webserver, ...; I suppose this box is heavily swapping
You can also install the support module and run it to see the performance hints

[jojo]

yeah, 512 MB is usable for a 1 person demo...

You really need to increase memory (at least 2G on a small system) and also should have a fast disk

[Eraserhead]

Thanks for the response guise

Even with 1 user i need 2GB? OK

I also tried the Support module and it gave me these warnings:

Check "max_allowed_packet" setting.
"max_allowed_packet" should be higher then 7 MB (it's 1 MB).

Check "query_cache_size" setting.
The setting "query_cache_size" should be used, you will get improvements up to 30 % of speed.

Check log for error log entries.
You have more error log entries: Module GD/Graph.pm not found!, Module GD.pm not found!

Check if the system uses Apache::DBI.
Apache::DBI should be used to get a better performance (pre-establish database connections).

Do you think if i fix these issues that i will see a significant performance increase?

[Wolfgangf]

absolutelly!

[Eraserhead]

What should value should i give query_cache_size ?
I probably should also change query cache limit?

[Wolfgangf]

i have something like

Code: Select all

set-variable = query_cache_size=1000000000

in my /etc/my.cnf

[Eraserhead]

Thanks. I resolved all those messages except for the DBI one. I found this FAQ article: http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=331

So i went inside apache2-perl-startup.pl and it turned out that these lines already were uncommented:

use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'some-pass');
use DBI ();

The only thing i noticed it still said 'some-pass' so i changed that to the value i found here in Kernel/Config.pm:

# (The database user.)
$Self->{'DatabaseUser'} = 'otrs';
# DatabasePw
# (The password of database user. You also can use bin/otrs.CryptPassword.pl
# for crypted passwords.)
$Self->{'DatabasePw'} = '***';
# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
$Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

I rebooted the server but it still said:

Check if the system uses Apache::DBI.
Apache::DBI should be used to get a better performance (pre-establish database connections).

What did i do wrong?

[Eraserhead]

Bump ^

[Wolfgangf]

did you also active this in the startup script?

Code: Select all

# enable this if you use mysql
use DBD::mysql ();
use Kernel::System::DB::mysql;

[Eraserhead]

OK i just uncommented those lines but i'm still getting the same warning message with the Support test.

[jojo]

did you restart apache afterwards?

[Eraserhead]

Yes, but didn't work. But someone helped me out and it's all good now. Don't know what he changed to get DBI working but he said the setting query_cache_size=1000000000 was too high. Thanks for your support!

[ferrosti]

1GB for a query_cache on a 512MB machine is usally no good idea

max_allowed_packet should at least be the maximum size of a single email. In case you allow 16MB for a single mail, don´t go below this value, rather add 50%.