WMDE/Wikidata/SQL

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.