WMDE/Wikidata/SQL

DB locations

• wikidatawiki database is stored on the s8 WMF shard.
• testwikidatawiki is on the s3 WMF shard.
• commonswiki is on the s4 WMF shard.
• Full text is stored on the same MariaDB#External_storage as other wikis.

Wikidata specific tables

You can read more details in the docs https://doc.wikimedia.org/Wikibase/master/php/md_docs_topics_storage.html

Repo tables

Change dispatch related tables:

• wb_changes
• wb_changes_dispatch
• wb_changes_subscription

Secondary terms index

• wbt_item_terms
• wbt_property_terms
• wbt_term_in_lang
• wbt_text_in_lang
• wbt_text
• wbt_type

Other:

• wb_id_counters
  • Simple tables storing counters for wikibase entity ids
• wb_items_per_site
  • Links client site + title pairs to item ids.
  • NOTE: This reflects the sitelinks found on items
• wb_property_info
  • Secondary storage for property info (datatype, formatter url etc)
• wbqc_constraints (WikibaseQualityConstraints)
• wbs_propertypairs (PropertySuggester)

Client tables

• wbc_entity_usage
  • Data usage tracking system for client sites.