Actor migration/hi

ऐतिहासिक रूप से, मीडियाविकि ने उपयोगकर्ताओं को संदर्भों (जैसे कि एक संशोधन या एक छवि के लेखक) को  जोड़ी के रूप में संग्रहीत किया है, गुमनाम संपादन के लिए   के साथ। यह भंडारण स्थान की बर्बादी थी, विकी पर प्रदर्शन की वजह से बड़ी संख्या में संशोधन हुए, और उपयोगकर्ताओं को नाम बदलने या T133452 जैसे नए प्रकार के लेखकों को पेश करना बहुत कठिन बना दिया। MediaWiki 1.31 introduces the concept of actors (someone who makes an action, such as an edit or a log event; currently either a registered user or an anonymous one), and a migration process towards a new database schema, with fields like  and   replaced by fields like. Due to the huge size of the English Wikipedia revision table, which must be fully migrated before the changes can be cleaned up, the migration is being done gradually, over several MediaWiki releases. It is expected to finish in MediaWiki 1.34.

The migration will create an table record for every distinct   /   pair, and replace those pairs with a reference to the actor row ID. The following columns are being migrated:

To avoid doing a costly ALTER TABLE on the extremely huge revision tables of large Wikipedia wikis,  and   are initially copied to the  table and from there back to. The revision_actor_temp table will be dropped afterwards.

If you are a wiki owner, you probably don't need to do anything, the migration will happen automatically when you run. If you want to control when the migration happens, see and the  maintenance script.

If you are an extension developer, and your extension does direct DB access to some of the affected fields, you'll need to update your queries (and ideally use the  methods, such as, instead of manually constructing your query). During the migration period, you can also use the  class to get schema/field information that respects any   settings.

If you are a tool developer using, there might be performance implications, even if you don't use any of the affected fields directly. See wikitech:News/Actor storage changes on the Wiki Replicas for additional information.