Manual:compressOld.php

From Linux Web Expert

Revision as of 06:14, 27 January 2023 by imported>FuzzyBot (Updating to match new version of source page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

詳細

compressOld.php file is a maintenance script to compress the text of old page revisions using gzip.

If used with option -t gzip, it compresses each revision text (including the current revision of all pages) and saves it back to the same table record.

If used with option -t concat, it compresses only previous revisions of each page but keeps the current revision uncompressed. The texts of all previous revisions of each page are concatenated and saved to the first table record created for that page. The remaining intermediary records are converted into stubs pointing to that first record. The concatenation allows for better compression. (This is a simplified explanation; depending on page size and the options used, the resulting structure for a given page can be more complex than this after the script is run.)

File:OOjs UI icon alert-destructive.svg <translate> Caution:</translate> Keep in mind that after compression, the compressed texts will no longer be searchable/replaceable via SQL scripts. For this reason, if all revisions are compressed, including the current ones, Replace Text extension will no longer work since it makes use of SQL queries.

使用法

php compressOld.php <database> [options...]

オプション

オプション/パラメーター 説明
-t <種類> set compression type to either:

gzip: compress revisions independently
concat: concatenate revisions and compress in chunks (default)

-c <チャンク サイズ> maximum number of revisions in a concat chunk, default to 20.
-b <開始日> earliest date to check for uncompressed revisions. The date must be provided as a MediaWiki timestamp.
-e <終了日> latest revision date to compress. The date must be provided as a MediaWiki timestamp.
-s <開始ID> the old_id to start from (referring to the text table for type gzip, and to the page table for type concat)
-n <終了ID> the page_id to stop at (only when using concat compression type)
--extdb <クラスター> store specified revisions in an external cluster (untested)

例:

compressOld.php -e 20141231235959 

This will concatenate and compress all revisions (except the current page revisions), which have been created before January 1st 2015.

関連項目