Manuel:runBatchedQuery.php

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

Détails

Le fichier runBatchedQuery.php est un script de maintenance qui lance une requête de base de données à l'aide de traitements par lots et attend la réponse des esclaves. 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 obligatoire
--set SET clause obligatoire
--key Column name, the values of which are unique obligatoire
--where WHERE clause optionnel
--batch-size Batch size optionnel 1000
--db Database name, or omit to use the current wiki. optionnel current wiki db

Usage

php maintenance/runBatchedQuery.php --table tableName --key columnName --set newValue [ --where| --batch-size| --db ]

See also