|
|
| (One intermediate revision by one user not shown) |
| Line 1: |
Line 1: |
| − | One way is udp: {{:UDP based profiling}}
| + | #redirect [[UDP based profiling]] |
| − | | + | |
| − | Another with SQL:
| + | |
| − | <pre>
| + | |
| − | 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
| + | |
| − | </pre>
| + | |
| − | | + | |
| − | [[Category:Benchmark]]
| + | |
