Unbelievable slow?!

Hello

I’m currently trying out request-tracker3.2 as Debian package and really
like its features.

Sadly, installed on my desktop (Celeron 600MHz, 768MB RAM, Mozilla,
MySQL) it is horrible slow where slow means about 4-5s to display a test
ticket in an else empty system!

I tried the following modes and watched the mysql logfile and the
network traffic with ngrep
mod_perl
HTTP uses chunked-encoding and I can watch the ticket tables
slowly building up
Configuration:
PerlRequire /usr/share/request-tracker3.2/libexec/webmux.pl

  PerlModule Apache::DBI
  PerlFreshRestart Off

  Alias /rt /usr/share/request-tracker3.2/html

  <Directory /usr/share/request-tracker3.2/html/NoAuth>
    SetHandler default-handler
  </Directory>

  <Directory /usr/share/request-tracker3.2/html>
    SetHandler perl-script
    PerlHandler RT::Mason
  </Directory>

fast-cgi
Not much faster, I wait 3s and then the ticket comes immediately
to display as it does not use chunked encoding.
Configuration:
AddDefaultCharset UTF-8
FastCgiIpcDir /tmp
FastCgiServer /usr/share/request-tracker3.2/libexec/mason_handler.fcgi -idle-timeout 120 -processes 4
AddHandler fastcgi-script fcgi
ScriptAlias /rt
/usr/share/request-tracker3.2/libexec/mason_handler.fcgi/

The MySQL logfiles shows some queries every now and then, I tried them
by hand but they completet in 0.0s.
top shows me that either apache or masing_handler.fcgi are using 90% cpu
time.

Is there anything that I could have configured wrong? I mean it’s plain
HTML with a little bit SQL, the page should show up after max 1s…

Any help appreciated!

bye,

-christian-

Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Authorized Reseller
Lï¿œtticher Straï¿œe 10 Tel 0241/701333-11
ch@westend.com D-52064 Aachen Fax 0241/911879

Sadly, installed on my desktop (Celeron 600MHz, 768MB RAM, Mozilla,
MySQL) it is horrible slow where slow means about 4-5s to display a test
ticket in an else empty system!

I tried the following modes and watched the mysql logfile and the
network traffic with ngrep
mod_perl
fast-cgi

I now also have tested speedycgi, postgresql as database and Windows IE
as remote browser trying to find the bottleneck but it was slow all the
time.
(MySQL is configured with larger buffers but as there is only 1 ticket
in the database and I use 4.0 with Query Cache this is defenitly not the
bottleneck)

Any hints where to add some debugging statements to see which function
takes most time?

bye,

-christian-

Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Authorized Reseller
Lï¿œtticher Straï¿œe 10 Tel 0241/701333-11
ch@westend.com D-52064 Aachen Fax 0241/911879

This might sound dumb, but are you sure this isn’t a DNS problem? I would
check that the computer on which you’ve installed RT on is registered
properly with the DNS. You could also try editing the lmhosts/and or hosts
file on your windows box to map directly to your debian box.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Christian
Hammers
Sent: Friday, August 27, 2004 12:15 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Unbelievable slow?!

Sadly, installed on my desktop (Celeron 600MHz, 768MB RAM, Mozilla,
MySQL) it is horrible slow where slow means about 4-5s to display a test
ticket in an else empty system!

I tried the following modes and watched the mysql logfile and the
network traffic with ngrep
mod_perl
fast-cgi

I now also have tested speedycgi, postgresql as database and Windows IE
as remote browser trying to find the bottleneck but it was slow all the
time.
(MySQL is configured with larger buffers but as there is only 1 ticket
in the database and I use 4.0 with Query Cache this is defenitly not the
bottleneck)

Any hints where to add some debugging statements to see which function
takes most time?

bye,

-christian-

Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Authorized Reseller
Lütticher Straße 10 Tel 0241/701333-11
ch@westend.com D-52064 Aachen Fax 0241/911879

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

Hi,

I just installed a fresh RT 3.2.1
I created several tickets thru both email and web interface.
I have this in my config file:

Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘error’);
Set($LogToFile , undef);
Set($LogDir, ‘/usr/local/rt1/var/log’);
Set($LogToFileNamed , “rt.log”); #log to rt.log

However the /usr/local/rt1/var/log/rt.log file doesn’t exist.
My question is - is there anything wrong with the config?

Thanks

Hi,

I just installed a fresh RT 3.2.1
I created several tickets thru both email and web interface.
I have this in my config file:

Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘error’);
Set($LogToFile , undef);
Set($LogDir, ‘/usr/local/rt1/var/log’);
Set($LogToFileNamed , “rt.log”); #log to rt.log

However the /usr/local/rt1/var/log/rt.log file doesn’t exist.
My question is - is there anything wrong with the config?

Thanks

You should define what to put in your log file
Change the line:
Set($LogToFile , undef);
to
Set($LogToFile , ‘debug’);
for example.

Regards

Nicolas Varney

Thanks, that worksFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
nvarney@edt.fr
Sent: Tuesday, August 31, 2004 10:03 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT logs

Hi,

I just installed a fresh RT 3.2.1
I created several tickets thru both email and web interface.
I have this in my config file:

Set($LogToSyslog , ‘debug’);
Set($LogToScreen , ‘error’);
Set($LogToFile , undef);
Set($LogDir, ‘/usr/local/rt1/var/log’);
Set($LogToFileNamed , “rt.log”); #log to rt.log

However the /usr/local/rt1/var/log/rt.log file doesn’t exist.
My question is - is there anything wrong with the config?

Thanks

You should define what to put in your log file
Change the line:
Set($LogToFile , undef);
to
Set($LogToFile , ‘debug’);
for example.

Regards

Nicolas Varney

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com