[rt-users] Speeding up RT3

Jason A. Diegmueller doogles at doogles.com
Mon Oct 4 10:19:48 EDT 2004


Matthew--

Yes, that's precisely my problem.  -F ("faking timestamps"?) will provide 
output, but as with your case, the times are all of (total elapsed time is 
negative, which is of course impossible).

perl 5.8.5
RT 3.2.2

I tried this on an RT 3.0.12 insance as well, same deal.  This appears 
only to affect webmux.pl, because I can run it against any other perl 
scripts ("rt help", as an example) and get sane (albeit useless) numbers.

Devel::Profiler appears to return sane numbers when run against webmux.pl, 
however I can't get it to work recursively (ie, if I run it against 
standalone_httpd it doesn't profile the behavior of webmux.pl).

-jd


On Mon, 4 Oct 2004, Matthew Watson wrote:

> Funny you should mention this.. I'm having exactly the same
> Problems
>
> DProf is giving me a lot of these errors
>
> unstacked calls in outer
> Garbled profile is missing some exit time stamps:
>
> The only way I can get it to show results is with dprofpp -F
>
> And this is what comes out
>
> Total Elapsed Time = -4.27563 Seconds
>  User+System Time =        0 Seconds
> Exclusive Times
> %Time ExclSec CumulS #Calls sec/call Csec/c  Name
> 0.00   7.492 12.054     18   0.4162 0.6697
> Locale::Maketext::Lexicon::Gettext
>                                             ::parse
> 0.00   3.903  4.564  34594   0.0001 0.0001
> Locale::Maketext::Lexicon::Gettext
>                                             ::transform
> 0.00   0.589 13.217      2   0.2946 6.6083
> Locale::Maketext::Lexicon::import
> 0.00   0.540  0.486  29981   0.0000 0.0000  Encode::decode_utf8
> 0.00   0.519  0.547     18   0.0288 0.0304
> Locale::Maketext::Lexicon::lexicon
>                                             _get_
> 0.00   0.448  1.313     32   0.0140 0.0410
> HTML::Mason::Commands::BEGIN
> 0.00   0.207  0.292      1   0.2069 0.2924
> Convert::ASN1::parser::yyparse
> 0.00   0.189  0.891     12   0.0158 0.0743  RT::I18N::BEGIN
> 0.00   0.179  0.651     18   0.0099 0.0361  RT::Tickets::BEGIN
> 0.00   0.169  0.188     15   0.0113 0.0126  Convert::ASN1::BEGIN
> 0.00   0.149  2.173     13   0.0115 0.1672  RT::Record::BEGIN
> 0.00   0.148  0.166      6   0.0247 0.0276
> DBIx::SearchBuilder::Handle::BEGIN
> 0.00   0.139  1.594     14   0.0099 0.1138  RT::User::BEGIN
> 0.00   0.129  3.839     13   0.0099 0.2953  RT::Mason::BEGIN
> 0.00   0.129  0.719      9   0.0143 0.0799  Net::LDAP::BEGIN
>
>
> Which doesn't look quite right, are these the same issues you are
> getting?
>
>
> Matthew Watson
>
>
>> -----Original Message-----
>> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
>> bounces at lists.bestpractical.com] On Behalf Of Jason A. Diegmueller
>> Sent: Monday, 4 October 2004 2:46 PM
>> To: rt-users at lists.fsck.com
>> Subject: Re: [rt-users] Speeding up RT3
>>
>> All this talk about profiling and indexeing has me playing again
> tonight.
>> A forewarning, I am not a coder, and I don't do perl.
>>
>> I'm trying desparately to use DProf to figure out where all my time is
>> being burnt up when loading larger tickets -- database?  Webserver?
>> Something else?  However, I keep getting strange dprofpp errors
>> and numbers that don't make sense (ttoal time in the negatives).
>>
>> This is a relatively clean perl 5.8.5 install (upgraded just
> yesterday).
>>
>> Am I missing a module?  Am I doing something wrong?
>>
>> This appears to work on anything but standalone_httpd & webmux.pl.  If
> I
>> run dprofpp -p rt, I get realistic figures (although, of course, it
>> doesn't actually product any valuable output) which makes me think
> there
>> is something specific and/or tricky about standalone_http.
>>
>> I'm currently running RT 3.2.2.
>>
>> Thanks!
>>
>> --
>>
>> [evelocity03:jdiegmueller] [/usr/local/rt/bin] # dprofpp -p
>> standalone_httpd
>> You can connect to your RT server at http://localhost:8080/
>>
>> <display a ticket>
>>
>> [evelocity03:jdiegmueller] [/usr/local/rt/bin] # dprofpp
>> Exporter::Heavy::heavy_export
>> Garbled profile, unexpected exit time stamp at /usr/local/bin/dprofpp
> line
>> 666, <fh> line 755.
>>
>> Faking 12 exit timestamp(s).
>> Total Elapsed Time = -8.35145 Seconds
>>    User+System Time =        0 Seconds
>> Exclusive Times
>> %Time ExclSec CumulS #Calls sec/call Csec/c  Name
>>   0.00   1.030  1.810  74161   0.0000 0.0000  RT::Record::__Value
>>   0.00   0.918  4.497  14592   0.0001 0.0003  RT::Principal::HasRight
>>   0.00   0.899  2.198  48964   0.0000 0.0000
>> DBIx::SearchBuilder::Record::Cacha
>>                                               ble::new
>>   0.00   0.859  4.387  49090   0.0000 0.0001  RT::Record::LoadByCols
>>   0.00   0.790  0.719  49090   0.0000 0.0000
>> DBIx::SearchBuilder::Record::Cacha
>>
>> ble::_gen_alternate_RecordCache_ke
>>                                               y
>>   0.00   0.750  0.516 155929   0.0000 0.0000
>> DBIx::SearchBuilder::Record::id
>>   0.00   0.720  3.709  49090   0.0000 0.0001
>> DBIx::SearchBuilder::Record::Cacha
>>                                               ble::LoadByCols
>>   0.00   0.710  0.857  99034   0.0000 0.0000
>> Cache::Simple::TimedExpiry::fetch
>>   0.00   0.700  0.885  74161   0.0000 0.0000
>> DBIx::SearchBuilder::Record::Cacha
>>                                               ble::__Value
>>   0.00   0.630  1.397  49090   0.0000 0.0000
>> DBIx::SearchBuilder::Record::Cacha
>>
>> ble::_lookup_primary_RecordCache_k
>>                                               ey
>>   0.00   0.590  1.103  49090   0.0000 0.0000
>> DBIx::SearchBuilder::Record::Cacha
>>                                               ble::_fetch
>>   0.00   0.550  1.319  48964   0.0000 0.0000
>> DBIx::SearchBuilder::Record::new
>>   0.00   0.540  0.390  99870   0.0000 0.0000
>> Cache::Simple::TimedExpiry::expire
>>   0.00   0.530  0.383  98278   0.0000 0.0000  RT::Base::CurrentUser
>>   0.00   0.520  0.407  74812   0.0000 0.0000
>> DBIx::SearchBuilder::Record::__Val
>>                                               ue
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Be sure to check out the RT wiki at http://wiki.bestpractical.com
>
> This email and any files transmitted with it are confidential and intended solely for the
> use of the individual or entity to whom they are addressed. Please notify the sender
> immediately by email if you have received this email by mistake and delete this email
> from your system. Please note that any views or opinions presented in this email are solely
> those of the author and do not necessarily represent those of the organisation.
> Finally, the recipient should check this email and any attachments for the presence of
> viruses. The organisation accepts no liability for any damage caused by any virus
> transmitted by this email.
>
>



More information about the rt-users mailing list