Hello.
I've setup NYTProf to start with apache. Clicked some pages. There where
several nytprof.$$.out.pid files. Not all files were decrypted with
nytprofhtml. I've found big seconds on two of files. I don't know what
to search for very well, so this is some text:
Profile of /srv/httpd/bin/httpd for 40.4s (of 40.6s), executing 51799
statements and 39622 subroutine calls in 174 source files and 53 string evals.
Top 15 Subroutines Calls P F Exclusive
Time Inclusive
Time Subroutine
1 1 1 3.00s 3.00s DBD::mysql::db::_login
(xsub)
13711 1 1 571ms 619ms
Encode::utf8::decode_xs (xsub)
1 1 1 383ms 1.00s
Kernel::System::Fred::STDERRLog::CORE:readline (opcode)
29 8 7 222ms 498ms Kernel::System::Main::Require
1 1 1 114ms 142ms Kernel::Config::Defaults::new
25 1 1 73.3ms 782ms
Kernel::System::ObjectManager::_ObjectBuild (recurses: max depth 1, inclusive
time 157ms)
1 1 1 66.5ms 98.3ms
Kernel::System::ObjectManager::BEGIN@24
4 1 1 49.0ms 49.9ms Template::Document::new
13711 1 1 47.8ms 47.8ms Encode::Encoding::renewed
1 1 1 46.3ms 46.4ms
Template::Parser::BEGIN@41
1 1 1 41.7ms 1.05s Kernel::System::Fred::STDERRLog::DataGet
10 3 1 40.3ms 120ms Template::Config::load
4 4 4 36.2ms 39.8ms
utf8::SWASHNEW
20 20 20 33.9ms 96.8ms base::import
(recurses: max depth 1, inclusive time 135µs)
1 1 1 28.8ms 29.0ms
Kernel::System::ObjectManager::BEGIN@30
See all 2571 subroutines
Source Code Files — ordered by exclusive time then name Stmts Exclusive
Time Reports Source File
124 3.02s line • block • sub DBD/mysql.pm
114 1.05s line • block • sub
/srv/otrs//Kernel/System/Fred/STDERRLog.pm
1 123ms line • block • sub -e
2338 112ms line • block • sub
/srv/otrs/Kernel/Config/Files/ZZZAAuto.pm
716 76.2ms line • block • sub /srv/otrs//Kernel/Output/HTML/Layout.pm
2230 68.8ms line • block • sub
/srv/otrs//Kernel/Language/en_ITSMChangeManagement.pm
1580 66.3ms line • block • sub
/srv/otrs//Kernel/System/ObjectManager.pm
210 53.0ms line • block • sub Template/Document.pm (including 13
string evals)
16 42.3ms line • block • sub Template/Grammar.pm
5995 42.0ms line • block • sub /srv/otrs//Kernel/Config/Defaults.pm
(including 1 string eval)
1932 41.4ms line • block • sub utf8_heavy.pl
2426 40.2ms line • block • sub /srv/otrs/Kernel/cpan-lib/JSON/PP.pm
(including 20 string evals)
13010 36.0ms line • block • sub
/srv/otrs/Kernel/cpan-lib/Apache2/Reload.pm
2205 31.2ms line • block • sub /srv/otrs//Kernel/System/Main.pm
163 29.3ms line • block • sub /srv/otrs//Kernel/System/DB.pm
6 28.4ms line • block • sub /srv/otrs//Kernel/System/Group.pm
203 21.2ms line • block • sub
/srv/httpd/../modperl/lib/perl/5.14.2/ModPerl/RegistryCooker.pm (including 1
string eval)
6 20.7ms line • block • sub /srv/otrs//Kernel/System/LinkObject.pm
710 19.6ms line • block • sub
/srv/otrs//Kernel/Language/en_CA_ITSMChangeManagement.pm
710 19.2ms line • block • sub
/srv/otrs//Kernel/Language/en_GB_ITSMChangeManagement.pm
1820 18.1ms line • block • sub Template/Context.pm
56 16.2ms line • block • sub Cwd.pm (including 2 string evals)
348 15.5ms line • block • sub Template/Provider.pm
10 15.2ms line • block • sub
/srv/otrs//Kernel/Output/HTML/Layout/Ticket.pm
36 15.0ms line • block • sub File/Find.pm
29 14.3ms line • block • sub Template/Parser.pm
1503 13.6ms line • block • sub Template/Filters.pm
748 13.3ms line • block • sub File/stat.pm
12 13.3ms line • block • sub
/srv/otrs//Kernel/Output/HTML/Layout/LinkObject.pm
57 13.2ms line • block • sub
/srv/otrs//Kernel/System/Web/InterfaceAgent.pm
23 13.0ms line • block • sub /srv/otrs//Kernel/System/User.pm
49 12.8ms line • block • sub POSIX.pm
16 11.9ms line • block • sub Template/Directive.pm
28 10.7ms line • block • sub
/srv/otrs//Kernel/System/AuthSession/DB.pm
2306 10.5ms line • block • sub Class/Struct.pm (including 1 string
eval)
63 10.4ms line • block • sub /srv/otrs//Kernel/System/Time.pm
543 10.4ms line • block • sub /srv/otrs//Kernel/System/Encode.pm
59 10.1ms line • block • sub /srv/otrs//Kernel/System/DB/mysql.pm
443 9.69ms line • block • sub /srv/otrs//Kernel/Language.pm
And another:
Profile of /srv/httpd/bin/httpd for 48.8s (of 51.6s), executing 1211808
statements and 324088 subroutine calls in 318 source files and 109 string evals.
Top 15 Subroutines Calls P F Exclusive
Time Inclusive
Time Subroutine
27422 1 1 987ms 1.07s
Encode::utf8::decode_xs (xsub)
11 1 1 672ms 882ms Template::Parser::_parse
2 1 1 640ms 1.71s
Kernel::System::Fred::STDERRLog::CORE:readline (opcode)
228 19 12 633ms 1.05s Kernel::System::Main::Require
104 1 1 410ms 1.86s
Kernel::System::ObjectManager::_ObjectBuild (recurses: max depth 1, inclusive
time 267ms)
421 4 1 252ms 252ms
Kernel::System::Main::CORE:ftis (opcode)
27 2 1 223ms 228ms Template::Document::new
100 1 1 186ms 186ms
Kernel::System::Main::CORE:readline (opcode)
2 1 1 185ms 1.08s JavaScript::Minifier::minify
3 1 1 174ms 270ms Kernel::Config::Defaults::new
15 1 1 160ms 160ms
Template::Provider::CORE:readline (opcode)
16352 2 1 159ms 249ms JavaScript::Minifier::action4
23 1 1 138ms 138ms DBI::db::do
(xsub)
6 6 6 117ms 142ms
utf8::SWASHNEW
15642 5 1 115ms 352ms JavaScript::Minifier::action3
See all 4654 subroutines
Source Code Files — ordered by exclusive time then name Stmts Exclusive
Time Reports Source File
1 39.3s line • block • sub -e
50 1.79s line • block • sub
/srv/otrs//Kernel/System/Fred/STDERRLog.pm
319261 1.09s line • block • sub
/srv/otrs/Kernel/cpan-lib/JavaScript/Minifier.pm
450013 973ms line • block • sub Template/Parser.pm
9738 785ms line • block • sub /srv/otrs//Kernel/System/Main.pm
12143 345ms line • block • sub /srv/otrs//Kernel/System/DB.pm
84131 275ms line • block • sub
/srv/otrs/Kernel/cpan-lib/CSS/Minifier.pm
3332 232ms line • block • sub Template/Document.pm (including 56
string evals)
9406 226ms line • block • sub
/srv/otrs//Kernel/System/ObjectManager.pm
3121 193ms line • block • sub Template/Provider.pm
6996 170ms line • block • sub
/srv/otrs/Kernel/Config/Files/ZZZAAuto.pm
23868 147ms line • block • sub /srv/otrs//Kernel/Config/Defaults.pm
(including 1 string eval)
18762 143ms line • block • sub utf8_heavy.pl
33285 130ms line • block • sub Template/Context.pm
14866 130ms line • block • sub /srv/otrs//Kernel/Output/HTML/Layout.pm
21569 110ms line • block • sub Template/Directive.pm
14800 102ms line • block • sub
/srv/otrs//Kernel/Output/Template/Document.pm
14016 93.1ms line • block • sub /Parser.yp
23534 82.7ms line • block • sub Template/Filters.pm
90 79.0ms line • block • sub /srv/otrs//Kernel/System/Ticket.pm
6676 77.3ms line • block • sub
/srv/otrs//Kernel/Language/en_ITSMChangeManagement.pm
10857 71.4ms line • block • sub /srv/otrs/Kernel/cpan-lib/JSON/PP.pm
(including 20 string evals)
27122 67.0ms line • block • sub
/srv/otrs/Kernel/cpan-lib/Apache2/Reload.pm
5935 53.4ms line • block • sub
/srv/otrs//Kernel/System/Ticket/TicketSearch.pm
1546 40.3ms line • block • sub
/srv/otrs//Kernel/Output/Template/Provider.pm
42 40.1ms line • block • sub Template/Grammar.pm
11195 39.0ms line • block • sub /srv/otrs//Kernel/System/Encode.pm
4878 38.6ms line • block • sub
/srv/otrs/Kernel/Output/HTML/Templates/Standard/AgentNavigationBar.tt
223 37.3ms line • block • sub
/srv/otrs//Kernel/System/ITSMChange/ITSMWorkOrder.pm
881 35.0ms line • block • sub /srv/otrs//Kernel/System/ITSMChange.pm
1287 32.0ms line • block • sub File/Path.pm
34 32.0ms line • block • sub
/srv/otrs//Kernel/Modules/AgentTimeAccountingEdit.pm
4096 31.0ms line • block • sub
/srv/otrs//Kernel/System/Cache/FileStorable.pm
12 30.3ms line • block • sub
/srv/otrs//Kernel/System/Ticket/Article.pm
5399 29.7ms line • block • sub Template/Stash.pm
314 29.2ms line • block • sub
/srv/otrs//Kernel/System/Web/InterfaceAgent.pm
2737 28.0ms line • block • sub /srv/otrs//Kernel/System/DB/mysql.pm
439 27.8ms line • block • sub DBD/mysql.pm
1041 27.8ms line • block • sub
/srv/otrs//Kernel/Output/HTML/TicketOverview/Small.pm
8 25.6ms line • block • sub
/srv/otrs//Kernel/System/Ticket/TicketACL.pm
1331 25.2ms line • block • sub /srv/otrs//Kernel/System/User.pm
574 24.8ms line • block • sub /srv/otrs//Kernel/System/Group.pm
88 24.3ms line • block • sub
/srv/otrs//Kernel/System/TimeAccounting.pm
1142 24.3ms line • block • sub
/srv/otrs//Kernel/Modules/AgentTicketQueue.pm
2116 24.3ms line • block • sub
/srv/otrs//Kernel/Language/en_CA_ITSMChangeManagement.pm
3186 23.8ms line • block • sub
/srv/otrs//Kernel/System/Fred/ConfigLog.pm
2116 23.1ms line • block • sub
/srv/otrs//Kernel/Language/en_GB_ITSMChangeManagement.pm
120 22.4ms line • block • sub File/Temp.pm
3003 22.4ms line • block • sub
/srv/otrs//Kernel/Output/HTML/Layout/Template.pm
1260 22.3ms line • block • sub Storable.pm
1697 22.3ms line • block • sub
/srv/otrs//Kernel/Output/Template/Plugin/OTRS.pm
284 22.2ms line • block • sub
/srv/otrs//Kernel/System/DynamicField/Backend.pm
302 21.2ms line • block • sub
/srv/otrs//Kernel/Output/HTML/Layout/Ticket.pm
54 20.9ms line • block • sub
/srv/otrs//Kernel/System/Daemon/SchedulerDB.pm
2533 20.9ms line • block • sub
/srv/otrs//Kernel/System/AuthSession/DB.pm
2969 20.3ms line • block • sub /srv/otrs//Kernel/Language.pm
26 19.9ms line • block • sub /srv/otrs/Kernel/cpan-lib/Date/Pcalc.pm
6 19.9ms line • block • sub /srv/otrs//Kernel/System/LinkObject.pm
2010 19.8ms line • block • sub /srv/otrs/Kernel/cpan-lib/Mail/Field.pm
(including 3 string evals)
146 19.7ms line • block • sub
/srv/otrs//Kernel/Output/HTML/FilterElementPost/CloseTicketView.pm
36 17.7ms line • block • sub /srv/otrs/Kernel/cpan-lib/MIME/Parser.pm
1286 17.3ms line • block • sub /srv/otrs//Kernel/System/Web/Request.pm
18 17.3ms line • block • sub /srv/otrs//Kernel/System/EmailParser.pm
36 17.2ms line • block • sub
/srv/otrs//Kernel/System/ITSMConfigItem.pm
36 17.2ms line • block • sub
/srv/otrs//Kernel/System/DynamicField/Driver/RemoteDB.pm
104 16.9ms line • block • sub
/srv/otrs//Kernel/Output/HTML/FilterContent/Fred.pm (variables that impact
regex performance for whole application seen here)
327 16.7ms line • block • sub
/srv/httpd/../modperl/lib/perl/5.14.2/ModPerl/RegistryCooker.pm (including 1
string eval)
38 16.0ms line • block • sub
/srv/otrs//Kernel/System/DynamicField/Driver/ITSMConfigItemReference.pm
1497 15.7ms line • block • sub File/stat.pm
2000 15.7ms line • block • sub
/srv/otrs/Kernel/Output/HTML/Templates/Standard/AgentTicketOverviewNavBar.tt
36 15.3ms line • block • sub File/Find.pm
32 15.2ms line • block • sub /srv/otrs/Kernel/cpan-lib/MIME/Entity.pm
12 15.1ms line • block • sub
/srv/otrs//Kernel/System/DynamicField/Driver/BaseDateTime.pm
2135 14.9ms line • block • sub /srv/otrs//Kernel/System/Cache.pm
55 14.6ms line • block • sub POSIX.pm
1622 14.6ms line • block • sub
/srv/otrs/Kernel/Output/HTML/Templates/Standard/Header.tt
56 14.2ms line • block • sub Cwd.pm (including 2 string evals)
4446 14.2ms line • block • sub Class/Struct.pm (including 1 string
eval)
347 14.0ms line • block • sub /srv/otrs//Kernel/System/DynamicField.pm
36 13.9ms line • block • sub
/srv/otrs//Kernel/System/DynamicField/Driver/Date.pm
906 13.0ms line • block • sub /srv/otrs//Kernel/System/Loader.pm
978 12.8ms line • block • sub /srv/otrs//Kernel/System/Time.pm
2009 12.6ms line • block • sub File/Basename.pm
60 12.3ms line • block • sub /srv/otrs//Kernel/System/Queue.pm
1776 11.6ms line • block • sub /srv/otrs//Kernel/System/JSON.pm
24 11.6ms line • block • sub
/srv/otrs//Kernel/System/DynamicField/Driver/Multiselect.pm
10 11.4ms line • block • sub
/srv/otrs//Kernel/System/ITSMConfigItem/Version.pm
1034 10.6ms line • block • sub Template/Service.pm
12 10.6ms line • block • sub
/srv/otrs//Kernel/Output/HTML/Layout/LinkObject.pm
24 10.4ms line • block • sub
/srv/otrs//Kernel/System/Ticket/ArticleStorageDB.pm
6 10.1ms line • block • sub
/srv/otrs//Kernel/Output/HTML/Layout/FAQ.pm
10 9.89ms line • block • sub
/srv/otrs//Kernel/System/DynamicField/Driver/BaseSelect.pm
Filename -e
Statements Executed 0 statements in 39.3s
Subroutines Calls P F Exclusive
Time Inclusive
Time Subroutine
1 1 1 522µs 1.92ms
Kernel::System::Fred::STDERRLog::BEGIN@82
1 1 1 13µs 13µs
Kernel::System::CheckItem::BEGIN@282
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments Time
on line Calls Time
in subs Code
0 23 9.46s Profile data that couldn't be
associated with a specific line:
# spent 9.39s making 3 calls to ModPerl::Registry::handler, avg 3.13s/call
# spent 67.0ms making 8 calls to Apache2::Reload::handler, avg 8.38ms/call
# spent 1.92ms making 1 call to Kernel::System::Fred::STDERRLog::BEGIN@82
# spent 516µs making 3 calls to Apache::DBI::__ANON__, avg 172µs/call
# spent 366µs making 1 call to Apache::DBI::childexit
# spent 165µs making 3 calls to CGI::_reset_globals, avg 55µs/call
# spent 116µs making 1 call to File::Temp::END
# spent 97µs making 1 call to DBI::END
# spent 13µs making 1 call to Kernel::System::CheckItem::BEGIN@282
# spent 7µs making 1 call to APR::Pool::DESTROY
1 1 39.3s No source code available for non-file
'-e'.
You probably need to use a more recent version of perl. See savesrc option in
documentation.
2
- -
82
# spent 1.92ms (522µs+1.39) within Kernel::System::Fred::STDERRLog::BEGIN@82
which was called:
# once (522µs+1.39ms) by Kernel::System::Fred::STDERRLog::CORE:open at line 0
So what is -e file and executed 0 statements 39 seconds. Also
ModPerl::Registry::handler takes 3 seconds per call.
What could be the problem. If need more debug, please advise.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs