Manual:profiling/fr table
From Linux Web Expert
↑ Manuel:Contenu | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>profiling/fr</tvar> table</translate> |
La table profiling était utilisée pour enregistrer les données relatives au profilage .
Cette table n'existe que si elle a été créée, par exemple en initialisant $wgProfiler['output'] = 'db'
dans votre StartProfiler.php et en exécutant maintenance/update.php
.
<translate> ≤</translate> 1.34
<translate> MediaWiki version:</translate> |
La table a été supprimée en MediaWiki 1.35 gerrit:545308.
Champs
pf_count
Compteur d'événements (un entier).
pf_time
Temps total (millisecondes).
pf_memory
Mémoire totale (kb).
pf_name
Nom de méthode (par exemple Title::getNamespace).
pf_server
Hôte (par exemple lucy-HP-Compaq-Elite-8300-SF).
Résumé du schéma
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.34</tvar> is unsupported version</translate>"> 1.13 – 1.34
<translate> MediaWiki versions:</translate> |
DESCRIBE profiling/fr;
+-----------+--------------+------+-----+---------+-------+ | 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 | | | +-----------+--------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.12</tvar> is unsupported version</translate>">
1.7 – 1.12
<translate> MediaWiki versions:</translate> |
DESCRIBE profiling/fr;
+-----------+--------------+------+-----+---------+-------+ | 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 | | | +-----------+--------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.6</tvar> is unsupported version</translate>">
1.3 – 1.6
<translate> MediaWiki versions:</translate> |
DESCRIBE profiling/fr;
+----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | pf_count | int(11) | NO | | 0 | | | pf_time | float | NO | | 0 | | | pf_name | varchar(255) | NO | PRI | | | +----------+--------------+------+-----+---------+-------+
Les index
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.34</tvar> is unsupported version</translate>"> 1.7 – 1.34
<translate> MediaWiki versions:</translate> |
SHOW INDEX IN profiling/fr;
+-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+