DB error log
[lhc/web/wiklou.git] / includes / Profiling.php
1 <?php
2 # This file is only included if profiling is enabled
3 function wfProfileIn( $functionname )
4 {
5 global $wgProfiler;
6 $wgProfiler->profileIn( $functionname );
7 }
8
9 function wfProfileOut( $functionname = "missing" )
10 {
11 global $wgProfiler;
12 $wgProfiler->profileOut( $functionname );
13 }
14
15 function wfGetProfilingOutput( $start, $elapsed ) {
16 global $wgProfiler;
17 return $wgProfiler->getOutput( $start, $elapsed );
18 }
19
20 function wfProfileClose()
21 {
22 global $wgProfiler;
23 $wgProfiler->close();
24 }
25
26 class Profiler
27 {
28 var $mStack = array(), $mWorkStack = array(), $mCollated = array();
29 var $mCalls = array(), $mTotals = array();
30 /*
31 function Profiler()
32 {
33 $this->mProfileStack = array();
34 $this->mWorkStack = array();
35 $this->mCollated = array();
36 }
37 */
38
39 function profileIn( $functionname )
40 {
41 global $wgDebugFunctionEntry;
42 if ( $wgDebugFunctionEntry && function_exists( "wfDebug" ) ) {
43 wfDebug( "Entering $functionname\n" );
44 }
45 array_push( $this->mWorkStack, array($functionname, count( $this->mWorkStack ), microtime() ) );
46 }
47
48 function profileOut( $functionname)
49 {
50 global $wgDebugProfiling, $wgDebugFunctionEntry;
51
52 if ( $wgDebugFunctionEntry && function_exists( "wfDebug" ) ) {
53 wfDebug( "Exiting $functionname\n" );
54 }
55
56 $bit = array_pop( $this->mWorkStack );
57
58 if ( !$bit ) {
59 wfDebug( "Profiling error, !\$bit: $functionname\n" );
60 } else {
61 if ( $wgDebugProfiling ) {
62 if ( $functionname == "close" ) {
63 wfDebug( "Profile section ended by close(): {$bit[0]}\n" );
64 } elseif ( $bit[0] != $functionname ) {
65 wfDebug( "Profiling error: in({$bit[0]}), out($functionname)\n" );
66 }
67 }
68 array_push( $bit, microtime() );
69 array_push( $this->mStack, $bit );
70 }
71 }
72
73 function close()
74 {
75 while ( count( $this->mWorkStack ) ) {
76 $this->profileOut( "close" );
77 }
78 }
79
80 function getOutput( $scriptStart, $scriptElapsed )
81 {
82 if( !count( $this->mStack ) ) {
83 return "No profiling output\n";
84 }
85 $this->close();
86 $width = 125;
87 $format = "%-" . ($width - 28) . "s %6d %6.3f %6.3f %6.3f%%\n";
88 $titleFormat = "%-" . ($width - 28) . "s %9s %9s %9s %9s\n";
89 $prof = "\nProfiling data\n";
90 $prof .= sprintf( $titleFormat, "Name", "Calls", "Total", "Each", "%" );
91 $this->mCollated = array();
92 $this->mCalls = array();
93
94 # Estimate profiling overhead
95 $profileCount = count( $this->mStack );
96 wfProfileIn( "-overhead-total" );
97 for ($i=0; $i<$profileCount ; $i++) {
98 wfProfileIn( "-overhead-internal" );
99 wfProfileOut( "-overhead-internal" );
100 }
101 wfProfileOut( "-overhead-total" );
102
103 # Collate
104 foreach ( $this->mStack as $entry ) {
105 $fname = $entry[0];
106 $thislevel = $entry[1];
107 $start = explode( " ", $entry[2]);
108 $start = (float)$start[0] + (float)$start[1];
109 $end = explode( " ", $entry[3]);
110 $end = (float)$end[0] + (float)$end[1];
111 $elapsed = $end - $start;
112
113 if ( !array_key_exists( $fname, $this->mCollated ) ) {
114 $this->mCollated[$fname] = 0;
115 $this->mCalls[$fname] = 0;
116 }
117
118 $this->mCollated[$fname] += $elapsed;
119 $this->mCalls[$fname] ++;
120 }
121
122 $total = @$this->mCollated["-total"];
123 $overhead = $this->mCollated["-overhead-internal"] / $profileCount;
124 $this->mCalls["-overhead-total"] = $profileCount;
125
126 # Output
127 foreach ( $this->mCollated as $fname => $elapsed ) {
128 $calls = $this->mCalls[$fname];
129 # Adjust for overhead
130 if ( $fname[0] != "-" ) {
131 $elapsed -= $overhead * $calls;
132 }
133
134 $percent = $total ? 100. * $elapsed / $total : 0;
135 $prof .= sprintf( $format, $fname, $calls, (float)($elapsed * 1000),
136 (float)($elapsed * 1000) / $calls, $percent );
137
138 global $wgProfileToDatabase;
139 if( $wgProfileToDatabase ) {
140 Profiler::logToDB( $fname, (float)($elapsed * 1000), $calls );
141 }
142 }
143 $prof .= "\nTotal: $total\n\n";
144
145 return $prof;
146 }
147
148
149 /* static */ function logToDB($name, $timeSum, $eventCount)
150 {
151 $name = wfStrencode( $name );
152 $sql = "UPDATE profiling ".
153 "SET pf_count=pf_count+{$eventCount}, ".
154 "pf_time=pf_time + {$timeSum} ".
155 "WHERE pf_name='{$name}'";
156 wfQuery($sql , DB_WRITE);
157
158 $rc = wfAffectedRows();
159 if( $rc == 0) {
160 $sql = "INSERT IGNORE INTO profiling (pf_name,pf_count,pf_time) ".
161 "VALUES ('{$name}', {$eventCount}, {$timeSum}) ";
162 wfQuery($sql , DB_WRITE);
163 $rc = wfAffectedRows();
164 }
165 // When we upgrade to mysql 4.1, the insert+update
166 // can be merged into just a insert with this construct added:
167 // "ON DUPLICATE KEY UPDATE ".
168 // "pf_count=pf_count + VALUES(pf_count), ".
169 // "pf_time=pf_time + VALUES(pf_time)";
170 }
171
172 }
173
174
175 $wgProfiler = new Profiler();
176 $wgProfiler->profileIn( "-total" );
177 ?>