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.

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.34</tvar> is unsupported version</translate>">
<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       |         |               |
+-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Liens externes