[rt-devel] RT 2.0.9pre1, DBIx::SearchBuilder 0.46 mof_fastcgi Performance

[Rich West]

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. :)

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 ;)
>
>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 :)
>>
>>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 ;)
>>>
>>>	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 at 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 at wesmo.com
Wesmo Computer Services        .com .net .org .tv .cc    http://www.wesmo.com
Full Domain & Web Hosting      .BIZ .INFO & MORE!!