Hello, I have problem with otrs which is very slow. I thought the problem is in MySQL but now I see the problem is in Perl. When I am opening page then processor load is on 100% for about 10 seconds (sometimes longer). I use it on FreeBSD with dual core processor (SMP support is turned on). I tried to turn on php_mod in apache but there was a problem with pictures (I didn't see them) and speed was better but still slow. I am very sad that otrs isn't written in php :-(. -- Regards, Bc. Radek Krejca STARNET, s. r. o. radek@ceskedomeny.cz
You just need to use mod_perl ! OTRS needs mod_perl Performance will not be an issue then... -----Oorspronkelijk bericht----- Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Bc. Radek Krejca Verzonden: donderdag 16 augustus 2007 10:13 Aan: otrs@otrs.org Onderwerp: [otrs] OTRS is too slow Hello, I have problem with otrs which is very slow. I thought the problem is in MySQL but now I see the problem is in Perl. When I am opening page then processor load is on 100% for about 10 seconds (sometimes longer). I use it on FreeBSD with dual core processor (SMP support is turned on). I tried to turn on php_mod in apache but there was a problem with pictures (I didn't see them) and speed was better but still slow. I am very sad that otrs isn't written in php :-(. -- Regards, Bc. Radek Krejca STARNET, s. r. o. radek@ceskedomeny.cz _______________________________________________ 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 Support or consulting for your OTRS system? =http://www.otrs.com/
Hi, Also using OTRS for a while now and I can tell that's the big complaint I can also have about OTRS. I'm totally agree with Bc. Radek Krejca. We're already using mod_perl but OTRS is still too slow. Response times are very high for a proper everyday usage. I'm also very sad that PHP hasn't been chosed for this software. Any way to improve response times of OTRS would be very much appreciate. BR, Laurent Le jeudi 16 août 2007 à 10:24 +0200, Peter van Beugen a écrit :
You just need to use mod_perl ! OTRS needs mod_perl Performance will not be an issue then...
-----Oorspronkelijk bericht----- Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Bc. Radek Krejca Verzonden: donderdag 16 augustus 2007 10:13 Aan: otrs@otrs.org Onderwerp: [otrs] OTRS is too slow
Hello,
I have problem with otrs which is very slow. I thought the problem is in MySQL but now I see the problem is in Perl.
When I am opening page then processor load is on 100% for about 10 seconds (sometimes longer).
I use it on FreeBSD with dual core processor (SMP support is turned on).
I tried to turn on php_mod in apache but there was a problem with pictures (I didn't see them) and speed was better but still slow.
I am very sad that otrs isn't written in php :-(.
Hi Laurent, You can try to optimize your database, that made a huge difference for me. AFAIK the command would be : mysqlcheck -o -B otrs_database You can also look into running mod_deflate, which will also give you a bit more speed. HTH Patric Laurent Minost wrote:
Hi,
Also using OTRS for a while now and I can tell that's the big complaint I can also have about OTRS. I'm totally agree with Bc. Radek Krejca.
We're already using mod_perl but OTRS is still too slow. Response times are very high for a proper everyday usage. I'm also very sad that PHP hasn't been chosed for this software.
Any way to improve response times of OTRS would be very much appreciate.
BR,
Laurent
-- Q: I want to be a sysadmin. What should I do? A: Seek professional help. ---------------------------------------------------------------------- Free pop3 email with a spam filter. http://www.bluebottle.com/tag/5
Hi Patric, Thks for your reply. I'm already using an optimize script in cron each night for all OTRS tables since OPTIMIZE seems not being done in OTRS source code when DELETE are used through the interface so tables are already up to date. Problem seems not being on the MySQL side since MySQL server is well tuned ( home-made tuning and through tuning-primer.sh advices ) and answering pretty well through PHP and other scripts. We don't try to use deflate/gzip modules since we are basically using OTRS on our Lan at the moment and I'm not pretty sure if it would be a thing that will increase performance. BR, Laurent Le jeudi 16 août 2007 à 11:16 +0200, Patric a écrit :
Hi Laurent,
You can try to optimize your database, that made a huge difference for me. AFAIK the command would be :
mysqlcheck -o -B otrs_database
You can also look into running mod_deflate, which will also give you a bit more speed.
HTH Patric
Laurent Minost wrote:
Hi,
Also using OTRS for a while now and I can tell that's the big complaint I can also have about OTRS. I'm totally agree with Bc. Radek Krejca.
We're already using mod_perl but OTRS is still too slow. Response times are very high for a proper everyday usage. I'm also very sad that PHP hasn't been chosed for this software.
Any way to improve response times of OTRS would be very much appreciate.
BR,
Laurent
Well.. Ours is lightning fast with around 32k tickets and no mod perl(cant
use mod perl if you are hosting more than 1 otrs through single instance of
apache). Running on Xserve G5¹s with each 2gb memory, nothing special.
Upgrading to the latest version of mysql really did the most for us,
separating the database server and the web server, and editing the my.cnf to
have much larger caches. We also use FS storage for articles.
At first I didn¹t like the idea of perl (was using deskpro) but after using
OTRS for 2 years we have realized its not so bad. The only reason I wanted
PHP is because I can understand it :)
Just be thankful its not java!
-Andy
On 8/16/07 7:52 AM, "Laurent Minost"
Hi Patric,
Thks for your reply.
I'm already using an optimize script in cron each night for all OTRS tables since OPTIMIZE seems not being done in OTRS source code when DELETE are used through the interface so tables are already up to date. Problem seems not being on the MySQL side since MySQL server is well tuned ( home-made tuning and through tuning-primer.sh advices ) and answering pretty well through PHP and other scripts.
We don't try to use deflate/gzip modules since we are basically using OTRS on our Lan at the moment and I'm not pretty sure if it would be a thing that will increase performance.
BR,
Laurent
Le jeudi 16 août 2007 à 11:16 +0200, Patric a écrit :
Hi Laurent,
You can try to optimize your database, that made a huge difference for me. AFAIK the command would be :
mysqlcheck -o -B otrs_database
You can also look into running mod_deflate, which will also give you a bit more speed.
HTH Patric
Laurent Minost wrote:
Hi,
Also using OTRS for a while now and I can tell that's the big complaint I can also have about OTRS. I'm totally agree with Bc. Radek Krejca.
We're already using mod_perl but OTRS is still too slow. Response times are very high for a proper everyday usage. I'm also very sad that PHP hasn't been chosed for this software.
Any way to improve response times of OTRS would be very much appreciate.
BR,
Laurent
_______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/
--
Hello, thanks for responses. 16. srpna 2007, 11:16, you wrote: P> You can try to optimize your database, that made a huge difference for me. P> AFAIK the command would be : But there isn't problem with database because I watch it and query takes about 1 second max. but then is running only Perl process. When I tried to use mod_perl I have problem witch pictures and speed wasn't dramatically better. Perl is very big too it takes a lot of resources but it isn't problem for me because I have machine only for otrs. Radek -- Regards, Bc. Radek Krejca STARNET, s. r. o. radek@ceskedomeny.cz
Hello, I am triyng to use mod_perl again. Speed isn't good but it's little bit better. But I don't see pictures and in my apache error-log are theese messagess: [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/overview.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/phone-new.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/search.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/mail_new.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/misc.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/h-line.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/prefer.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/personal.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/new-message.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at /usr/local/otrs/var/httpd/htdocs/images/Standard/up.png line 1.\n What is it? 16. srpna 2007, 10:24, you wrote: PvB> You just need to use mod_perl ! PvB> OTRS needs mod_perl PvB> Performance will not be an issue then... PvB> -----Oorspronkelijk bericht----- PvB> Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens Bc. PvB> Radek Krejca PvB> Verzonden: donderdag 16 augustus 2007 10:13 PvB> Aan: otrs@otrs.org PvB> Onderwerp: [otrs] OTRS is too slow PvB> Hello, PvB> I have problem with otrs which is very slow. I thought the problem PvB> is in MySQL but now I see the problem is in Perl. PvB> When I am opening page then processor load is on 100% for about 10 PvB> seconds (sometimes longer). PvB> I use it on FreeBSD with dual core processor (SMP support is turned PvB> on). PvB> I tried to turn on php_mod in apache but there was a problem with PvB> pictures (I didn't see them) and speed was better but still slow. PvB> I am very sad that otrs isn't written in php :-(. -- Regards, Bc. Radek Krejca STARNET, s. r. o. radek@ceskedomeny.cz
Bc. Radek Krejca wrote:
I am triyng to use mod_perl again. Speed isn't good but it's little bit better. But I don't see pictures and in my apache error-log are theese messagess:
[Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/overview.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/phone-new.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/search.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/mail_new.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/misc.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/h-line.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/prefer.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/personal.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/new-message.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/up.png line 1.\n
What is it?
I guess there is something wrong with your mod_perl configuration. The images are being read as if they were scripts or something. Please post your config. Nils Breunese.
Hello,
httpd.conf:
----------------------------------------------------------------------------------------------
LoadModule perl_module libexec/apache2/mod_perl.so
# if mod_perl is used
<IfModule mod_perl.c>
# load all otrs modules
Perlrequire /usr/local/otrs/scripts/apache2-perl-startup.pl
# Apache::Reload - Reload Perl Modules when Changed on Disk
PerlModule Apache2::Reload
PerlInitHandler Apache2::Reload
PerlModule Apache2::RequestRec
# set mod_perl2 options
<Location />
# ErrorDocument 403 /customer.pl
ErrorDocument 403 /index.pl
SetHandler perl-script
PerlResponseHandler ModPerl::Registry
Options +ExecCGI
PerlOptions +ParseHeaders
PerlOptions +SetupEnv
Order allow,deny
Allow from all
</Location>
</IfModule>
----------------------------------------------------------------------------------------
ssl.conf
----------------------------------------------------------------------------------------
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
<IfDefine SSL>
Listen 443
AddType application/x-x509-ca-cert .crt
AddType application/x-pkcs7-crl .crl
SSLPassPhraseDialog builtin
SSLSessionCache dbm:/var/run/ssl_scache
SSLSessionCacheTimeout 300
SSLMutex file:/var/run/ssl_mutex
##
## SSL Virtual Host Context
##
I am triyng to use mod_perl again. Speed isn't good but it's little bit better. But I don't see pictures and in my apache error-log are theese messagess:
[Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/overview.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/phone-new.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/search.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/mail_new.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/misc.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/h-line.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/prefer.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/personal.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/new-message.png line 1.\n [Mon Aug 27 10:35:40 2007] [error] Unrecognized character \\x89 at / usr/local/otrs/var/httpd/htdocs/images/Standard/up.png line 1.\n
What is it?
NBL> I guess there is something wrong with your mod_perl configuration. NBL> The images are being read as if they were scripts or something. NBL> Please post your config. NBL> Nils Breunese. -- Regards, Bc. Radek Krejca STARNET, s. r. o. radek@ceskedomeny.cz
Bc. Radek Krejca wrote:
# set mod_perl2 options <Location /> # ErrorDocument 403 /customer.pl ErrorDocument 403 /index.pl SetHandler perl-script PerlResponseHandler ModPerl::Registry Options +ExecCGI PerlOptions +ParseHeaders PerlOptions +SetupEnv Order allow,deny Allow from all </Location>
You have specified to use mod_perl for all files under / (effectively all site files), so mod_perl is also trying to process your images as perl code. That is why you're getting that error. Nils Breunese.
Hello,
yes, youre right, I have overlook it, I am idiot. Thank you, now it
works. But I have to set it in ssl.conf this section is needless I
deleted it (I am using https). Corret is this:
# set mod_perl2 options <Location /> # ErrorDocument 403 /customer.pl ErrorDocument 403 /index.pl SetHandler perl-script PerlResponseHandler ModPerl::Registry Options +ExecCGI PerlOptions +ParseHeaders PerlOptions +SetupEnv Order allow,deny Allow from all </Location>
NBL> You have specified to use mod_perl for all files under / (effectively NBL> all site files), so mod_perl is also trying to process your images as NBL> perl code. That is why you're getting that error. NBL> Nils Breunese. -- Regards, Bc. Radek Krejca STARNET, s. r. o. radek@ceskedomeny.cz
participants (6)
-
Andy Lubel -
Bc. Radek Krejca -
Laurent Minost -
Nils Breunese (Lemonbit) -
Patric -
Peter van Beugen