Manual:Profiling table/en

The profiling table was used to store -related data. This table doesn't exist unless created, e.g. by setting  in your StartProfiler.php and running.

The table has been removed in 545308.

pf_count
Event count (an integer).

pf_time
Time sum (milliseconds).

pf_memory
Memory sum (KB).

pf_name
Method name (e.g. Title::getNamespace).

pf_server
Host (e.g. lucy-HP-Compaq-Elite-8300-SF).

Schema summary
+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field    | Type         | Null | Key | Default | Extra |
 * pf_count | int(11)      | NO   |     | 0       |       |
 * pf_time  | float        | NO   |     | 0       |       |
 * pf_memory | float       | NO   |     | 0       |       |
 * pf_name  | varchar(255) | NO   | PRI |         |       |
 * pf_server | varchar(30) | NO   | PRI |         |       |

+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field    | Type         | Null | Key | Default | Extra |
 * pf_count | int(11)      | NO   |     | 0       |       |
 * pf_time  | float        | NO   |     | 0       |       |
 * pf_name  | varchar(255) | NO   | PRI |         |       |
 * pf_server | varchar(30) | NO   | PRI |         |       |

+--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field   | Type         | Null | Key | Default | Extra |
 * pf_count | int(11)     | NO   |     | 0       |       |
 * pf_time | float        | NO   |     | 0       |       |
 * pf_name | varchar(255) | NO   | PRI |         |       |

Indexes
 +---+++--+-+---+-+--++--++-+---+ +---+++--+-+---+-+--++--++-+---+ +---+++--+-+---+-+--++--++-+---+
 * Table    | Non_unique | Key_name       | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * profiling |         0 | pf_name_server |            1 | pf_name     | NULL      |        NULL |     NULL | NULL   |      | HASH       |         |               |
 * profiling |         0 | pf_name_server |            2 | pf_server   | NULL      |           0 |     NULL | NULL   |      | HASH       |         |               |

External link

 * https://phabricator.wikimedia.org/source/mediawiki/browse/master/maintenance/archives/patch-profiling.sql;2ed4b3245004cfa5de5e4b1ea3fcb9cab6c57c51