This is used by the MediaWiki default search engine. We don't use that. This table can be safely truncated on all wikis (most should be empty already anyway).
It seems as though this has been dropped on a couple of wikis (probably ages ago)...if we're looking for parity with core we should probably recreate the empty tables on those?
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | LSobanski | T54921 Database tables to be dropped on Wikimedia wikis and other WMF databases (tracking) | |||
| Resolved | • Marostegui | T167978 Truncate 'searchindex' table on all wikis |
Yes, answering the question- all tables in core should exist on our installation. If they are not used on the WMF, they should exist empty (TRUNCATE).
The current situation is:
s1 -> the table isn't there
s2 -> the table isn't there
s3 table present on 682 wikis, all of them are empty apart from:
azwiki 1 cywiki 1 dawiki 4 elwiki 1 etwiki 1 euwiktionary 1 glwiki 1 hiwiki 1 iswiki 1 itwikiquote 1 kuwiktionary 1 mgwiktionary 9 mswiki 1 rel13testwiki 1 simplewiki 2 skwiki 1 slwiki 2 specieswiki 1 tawiki 1 ukwiktionary 1 usabilitywiki 296 uzwiki 1
s4:
commonswiki 15 rows
s5:
dewiki 15 wikidatawiki 0
s6:
frwiki 12 jawiki 2 ruwiki 13
s7:
arwiki 1 cawiki 2 eswiki 13 fawiki 2 frwiktionary 0 hewiki 2 huwiki 2 kowiki 0 metawiki 2 rowiki 1 ukwiki 1 viwiki 0