Manual:profiling table

Other languages:
English • ‎français • ‎日本語
Manual:Contents MediaWiki database layout profiling table


The profiling table was used to store profiling -related data. This table doesn't exist unless created, e.g. by setting $wgProfiler['output'] = 'db' in your StartProfiler.php and running maintenance/update.php.

MediaWiki version: 1.35

The table has been removed in MediaWiki 1.35 [1].

FieldsEdit

pf_countEdit

Event count (an integer).

pf_timeEdit

Time sum (milliseconds).

pf_memoryEdit

Memory sum (KB).

pf_nameEdit

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

pf_serverEdit

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

Schema summaryEdit

MediaWiki version: 1.13

DESCRIBE profiling;

+-----------+--------------+------+-----+---------+-------+
| 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 |         |       |
+-----------+--------------+------+-----+---------+-------+
MediaWiki versions: 1.7 – 1.12

DESCRIBE profiling;

+-----------+--------------+------+-----+---------+-------+
| 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 |         |       |
+-----------+--------------+------+-----+---------+-------+
MediaWiki versions: 1.3 – 1.6

DESCRIBE profiling;

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

External linkEdit