Manual:runBatchedQuery.php

This page is a translated version of the page Manual:RunBatchedQuery.php and the translation is 30% complete.

Detalhes

O ficheiro runBatchedQuery.php é um script de manutenção para executar consultas em bancos de dados em lotes e esperar por escravos. This is used on large wikis to prevent excessive replication lag when executing large write queries.

Options

Option Description Required Default value
--table Table name Required
--set SET clause Required
--key Column name, the values of which are unique Required
--where WHERE clause Optional
--batch-size Batch size Optional 1000
--db Database name, or omit to use the current wiki. Optional current wiki db

Usage

php maintenance/run.php runBatchedQuery --table tableName --key columnName --set newValue [ --where| --batch-size| --db ]
In MediaWiki version 1.39.12 and earlier, you must invoke maintenance scripts using php maintenance/scriptName.php instead of php maintenance/run.php scriptName.

See also