Manual: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.

The table has been removed in MediaWiki 1.35 gerrit:545308.

Event count (an integer).

Time sum (milliseconds).

Memory sum (KB).

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

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

DESCRIBEprofiling;

+-----------+--------------+------+-----+---------+-------+
| 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 | | |
+-----------+--------------+------+-----+---------+-------+

DESCRIBEprofiling;

+-----------+--------------+------+-----+---------+-------+
| 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 | | |
+-----------+--------------+------+-----+---------+-------+

DESCRIBEprofiling;

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

SHOWINDEXINprofiling;

+-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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 | | |
+-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

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

• MediaWiki database tables