Profiling
From Wikitech
14:38 TimStarling: ok, here's how to do the profiling 14:38 TimStarling: I'm doing it now if you want to watch :) 14:39 TimStarling: you log into suda, and run a "truncate table profiling" query on en 14:39 TimStarling: then (usually in a different window) you open CommonSettings.php 14:40 TimStarling: you search for profiling 14:40 TimStarling: you find a commented-out section 14:40 TimStarling: uncomment it 14:41 TimStarling: like that 14:41 TimStarling: the sample rate is 50 by default, that means it profiles 1 in every 50 requests 14:41 TimStarling: it will take a while at this rate to build up some decent data 14:42 TimStarling: run: sql enwiki -vvv < ~tstarling/sql/profiling.sql 14:43 TimStarling: make a local copy of that SQL and adjust the screen width if you desire 14:45 TimStarling: anyway, once you have enough data, you comment out the section in - CommonSettings.php again 14:46 TimStarling: then run the SQL again, copy the data to a subpage of m:Profiling, and analyse - the results