[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