Manual:profiling/fr table

From Linux Web Expert

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.


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