Manual:profiling テーブル
From mediawiki.org
This page is a translated version of the page Manual:Profiling table and the translation is 69% complete.
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 バージョン:
≦ 1.34
The table has been removed in MediaWiki 1.35 gerrit:545308.
フィールド
pf_count
イベントの件数 (整数)。
pf_time
経過時間の合計 (ミリ秒)。
pf_memory
メモリの合計 (キロバイト)。
pf_name
メソッド名 (例: Title::getNamespace)。
pf_server
Host (e.g. lucy-HP-Compaq-Elite-8300-SF).
スキーマの要約
MediaWiki バージョン:
1.13 – 1.34
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 | | | +-----------+--------------+------+-----+---------+-------+
MediaWiki バージョン:
1.7 – 1.12
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 | | | +-----------+--------------+------+-----+---------+-------+
MediaWiki バージョン:
1.3 – 1.6
DESCRIBEprofiling;
+----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | pf_count | int(11) | NO | | 0 | | | pf_time | float | NO | | 0 | | | pf_name | varchar(255) | NO | PRI | | | +----------+--------------+------+-----+---------+-------+
インデックス
MediaWiki バージョン:
1.7 – 1.34
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 | | | +-----------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+