RT 2.0.9pre1, DBIx::SearchBuilder 0.46 mof_fastcgi Performance

RT Developers
1

Running 2.0.9pre1 now. No obvious visible differences (of course, I
didn’t look too hard :slight_smile:

Interestingly, I still do not get the rt.jpg image… that, and it
doesn’t install the rt.jpg file into NoAuth/images when a “make upgrade”
is performed…

Just thought I would mention that, during either the install of 2.0.8 or
2.0.9pre1, I saw “Warning: prerequisite DBIx::SearchBuilder 0.46 not
found at /usr/local/lib/perl5/5.6.1/ExtUtils/MakeMaker.pm line 340.”

I have the DBIx::Searchbuilder 0.46-test1 (from the CVS tree)
installed… Hrmm.

The main deal for doing the 2.0.9pre1 and Searchbuilder upgrades was to
beat up on the massive delay for any interaction to RT2. On top of that,
I did those optimizations to MySQL (both on the INDEX side of the house
and the mysqld running options), but it still takes about 5-10 seconds
to even draw the log in screen.

Any other ideas as to how to trim down the delays? (Solaris 8, Apache
1.3.22, mod_fastcgi, MySQL 3.23.43 (on a separate host))

-Rich

Jesse Vincent wrote:

The new SearchBuilder should fix perf issues with mysql and some issues
with query generation on postgres

There are a number of minorish bug fixes that need to get into 2.0.9.
I’ll be trying to get to those in the next week or two.

This new RT prerelease includes the following:

Bumped version to 2.0.9pre1

file cvs_integration was initially added on branch rt-1-1.

Refactored images path to have a configurable URL, so it will work with fastcgi :wink:

Added support for timing of page display with &Debug=1

User.pm: a fix to allow you to create multiple users with no email address.

Added sub Due to Tickets.pm. fixes #910

Some work on the rpm build infrastructure

Added cpan2rpm to the tools directory, for autogenerating rpms of cpan modules

Added support for autobuilding an rpm with “make rpm”

Fixed templates to include the ticket subject if it was otherwise blank

work on web-based ticket creation. fixed bugs setting due dates, etc

fixed a user creation race condition in the mail gateway

use the new status abstraction in the web ui

moved to a dbix::searchbuilder 0.46 dependency

now initdb won’t whine if you don’t set a host

Added some docs about what 2.2 might hold

Abstracted out status enumeration and validation

added WebPath to fix some links in showlinks

Added an optional bit of configuration to not show the “History” header

Added a new option “Show commands” to show tranasaction

Added support for reenabling deleted queues and keywords

Added test harness glue

Added code to detect bogus ticket update types

Added support for unit testing

Added a test for Database Port definition to stop perl from whining

Added the beginnings of test support to RT.pm

bin/rt: Documentation cleanups. removing an unnecessary data tainting check
Fixes to initacls.Pg to allow installation with Unix Domain sockets

Richard West $14.95 Registrations mailto:rwest@wesmo.com
Wesmo Computer Services .com .net .org .tv .cc http://www.wesmo.com
Full Domain & Web Hosting .BIZ .INFO & MORE!!

2

That sounds like fastcgi isn’t keeping your script running.
does a ps show it running between requests?

Are you sure that the rt.jpg didn’t get installed during make upgrade?
Did you get the source from a tarball or cvs?

And yeah, if you’re running 0.46-test1, that’s not 0.46, which was released
last night ;)On Fri, Oct 19, 2001 at 11:05:17AM -0400, Rich West wrote:

Running 2.0.9pre1 now. No obvious visible differences (of course, I
didn’t look too hard :slight_smile:

Interestingly, I still do not get the rt.jpg image… that, and it
doesn’t install the rt.jpg file into NoAuth/images when a “make upgrade”
is performed…

Just thought I would mention that, during either the install of 2.0.8 or
2.0.9pre1, I saw “Warning: prerequisite DBIx::SearchBuilder 0.46 not
found at /usr/local/lib/perl5/5.6.1/ExtUtils/MakeMaker.pm line 340.”

I have the DBIx::Searchbuilder 0.46-test1 (from the CVS tree)
installed… Hrmm.

The main deal for doing the 2.0.9pre1 and Searchbuilder upgrades was to
beat up on the massive delay for any interaction to RT2. On top of that,
I did those optimizations to MySQL (both on the INDEX side of the house
and the mysqld running options), but it still takes about 5-10 seconds
to even draw the log in screen.

Any other ideas as to how to trim down the delays? (Solaris 8, Apache
1.3.22, mod_fastcgi, MySQL 3.23.43 (on a separate host))

-Rich

Jesse Vincent wrote:

The new SearchBuilder should fix perf issues with mysql and some issues
with query generation on postgres

There are a number of minorish bug fixes that need to get into 2.0.9.
I’ll be trying to get to those in the next week or two.

This new RT prerelease includes the following:

Bumped version to 2.0.9pre1

file cvs_integration was initially added on branch rt-1-1.

Refactored images path to have a configurable URL, so it will work with fastcgi :wink:

Added support for timing of page display with &Debug=1

User.pm: a fix to allow you to create multiple users with no email address.

Added sub Due to Tickets.pm. fixes #910

Some work on the rpm build infrastructure

Added cpan2rpm to the tools directory, for autogenerating rpms of cpan modules

Added support for autobuilding an rpm with “make rpm”

Fixed templates to include the ticket subject if it was otherwise blank

work on web-based ticket creation. fixed bugs setting due dates, etc

fixed a user creation race condition in the mail gateway

use the new status abstraction in the web ui

moved to a dbix::searchbuilder 0.46 dependency

now initdb won’t whine if you don’t set a host

Added some docs about what 2.2 might hold

Abstracted out status enumeration and validation

added WebPath to fix some links in showlinks

Added an optional bit of configuration to not show the “History” header

Added a new option “Show commands” to show tranasaction

Added support for reenabling deleted queues and keywords

Added test harness glue

Added code to detect bogus ticket update types

Added support for unit testing

Added a test for Database Port definition to stop perl from whining

Added the beginnings of test support to RT.pm

bin/rt: Documentation cleanups. removing an unnecessary data tainting check
Fixes to initacls.Pg to allow installation with Unix Domain sockets

–
Richard West $14.95 Registrations mailto:rwest@wesmo.com
Wesmo Computer Services .com .net .org .tv .cc http://www.wesmo.com
Full Domain & Web Hosting .BIZ .INFO & MORE!!

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.

3

That sounds like fastcgi isn’t keeping your script running.
does a ps show it running between requests?

As a note here I just switched from mod_perl to fastcgi and it is working
fine but is slower than mod_perl. The mason_handler.fcgi is only running
while a request is being processed like refreshing a page or clicking on a
link. After the request is done it closes down and does not continue to
run. My main screen takes about 5-10 seconds to display as well and we
have a very small test DB that we are running with right now, its
currently less than 50 tickets in the DB.

System is Solaris 8, rt 2.0.8 release. Apache
1.3.19 Mod_perl/Mod_ssl/mod_fcgi/mod_php4.

4

That sounds like you haven’t configured mod_fastcgi to actually make sure
fastcgi scripts stay runningOn Fri, Oct 19, 2001 at 02:39:50PM -0500, Sanity wrote:

On Fri, 19 Oct 2001, Jesse Vincent wrote:

That sounds like fastcgi isn’t keeping your script running.
does a ps show it running between requests?

As a note here I just switched from mod_perl to fastcgi and it is working
fine but is slower than mod_perl. The mason_handler.fcgi is only running
while a request is being processed like refreshing a page or clicking on a
link. After the request is done it closes down and does not continue to
run. My main screen takes about 5-10 seconds to display as well and we
have a very small test DB that we are running with right now, its
currently less than 50 tickets in the DB.

System is Solaris 8, rt 2.0.8 release. Apache
1.3.19 Mod_perl/Mod_ssl/mod_fcgi/mod_php4.

rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.

5

Both the linux installation and Solaris installation have been happily
keeping the fcgi process running…

As far as the latest RT install, I did it from CVS. I had to manually
copy the rt.jpg image to the NoAuth/images directory. Interestingly,
while not logged in, even after stopping and starting the server, if I
go directly to https://host.mydomain.com/rt2/NoAuth/images/rt.jpg, it
drops me to the login screen (with no graphic).

And, yes, I’m running the test1 of DBIx… I’ll upgrade. :slight_smile:

Hopefully, that will help to reduce the 15.18 second access time that we
are seeing…

-Rich

Jesse Vincent wrote:

That sounds like fastcgi isn’t keeping your script running.
does a ps show it running between requests?

Are you sure that the rt.jpg didn’t get installed during make upgrade?
Did you get the source from a tarball or cvs?

And yeah, if you’re running 0.46-test1, that’s not 0.46, which was released
last night :wink:

Running 2.0.9pre1 now. No obvious visible differences (of course, I
didn’t look too hard :slight_smile:

Interestingly, I still do not get the rt.jpg image… that, and it
doesn’t install the rt.jpg file into NoAuth/images when a “make upgrade”
is performed…

Just thought I would mention that, during either the install of 2.0.8 or
2.0.9pre1, I saw “Warning: prerequisite DBIx::SearchBuilder 0.46 not
found at /usr/local/lib/perl5/5.6.1/ExtUtils/MakeMaker.pm line 340.”

I have the DBIx::Searchbuilder 0.46-test1 (from the CVS tree)
installed… Hrmm.

The main deal for doing the 2.0.9pre1 and Searchbuilder upgrades was to
beat up on the massive delay for any interaction to RT2. On top of that,
I did those optimizations to MySQL (both on the INDEX side of the house
and the mysqld running options), but it still takes about 5-10 seconds
to even draw the log in screen.

Any other ideas as to how to trim down the delays? (Solaris 8, Apache
1.3.22, mod_fastcgi, MySQL 3.23.43 (on a separate host))

-Rich

Jesse Vincent wrote:

The new SearchBuilder should fix perf issues with mysql and some issues
with query generation on postgres

There are a number of minorish bug fixes that need to get into 2.0.9.
I’ll be trying to get to those in the next week or two.

This new RT prerelease includes the following:

Bumped version to 2.0.9pre1

file cvs_integration was initially added on branch rt-1-1.

Refactored images path to have a configurable URL, so it will work with fastcgi :wink:

Added support for timing of page display with &Debug=1

User.pm: a fix to allow you to create multiple users with no email address.

Added sub Due to Tickets.pm. fixes #910

Some work on the rpm build infrastructure

Added cpan2rpm to the tools directory, for autogenerating rpms of cpan modules

Added support for autobuilding an rpm with “make rpm”

Fixed templates to include the ticket subject if it was otherwise blank

work on web-based ticket creation. fixed bugs setting due dates, etc

fixed a user creation race condition in the mail gateway

use the new status abstraction in the web ui

moved to a dbix::searchbuilder 0.46 dependency

now initdb won’t whine if you don’t set a host

Added some docs about what 2.2 might hold

Abstracted out status enumeration and validation

added WebPath to fix some links in showlinks

Added an optional bit of configuration to not show the “History” header

Added a new option “Show commands” to show tranasaction

Added support for reenabling deleted queues and keywords

Added test harness glue

Added code to detect bogus ticket update types

Added support for unit testing

Added a test for Database Port definition to stop perl from whining

Added the beginnings of test support to RT.pm

bin/rt: Documentation cleanups. removing an unnecessary data tainting check
Fixes to initacls.Pg to allow installation with Unix Domain sockets

–
Richard West $14.95 Registrations mailto:rwest@wesmo.com
Wesmo Computer Services .com .net .org .tv .cc http://www.wesmo.com
Full Domain & Web Hosting .BIZ .INFO & MORE!!

Richard West $14.95 Registrations mailto:rwest@wesmo.com
Wesmo Computer Services .com .net .org .tv .cc http://www.wesmo.com
Full Domain & Web Hosting .BIZ .INFO & MORE!!