Help:Maintenance script rebuildFulltextSearchTable.php

From Linux Web Expert

Template:MW file/noslash Template:MW file/noslash The "rebuildFulltextSearchTable.php" maintenance script rebuilds the database table used for the full-text search feature. The maintenance script was introduced in Semantic MediaWiki 2.5.0Released on an unknown date unknown versions of MediaWiki1 and currently only works if configuration parameter $smwgDefaultStoreSets the storage backend to be used for the semantic data is set to SMWSQLStore3 (= default setting) and here only for MySQL/MariaDB1 and SQLite2, i.e. PostgreSQL3 and SPARQL stores are currently not supported. Note that this script enforces an five second countdown period prior to its actual execution.

Semantic MediaWiki 3.2.0Released on an unknown date unknown versions of MediaWiki brought an improved client output to this maintenance script.4

It is recommended to run this script in daily intervals as part of the general wiki maintenance.

Usage

php rebuildFulltextSearchTable.php [--v|--quick|--optimize|--report-runtime|--with-maintenance-log]
This only shows the script specific parameters.

Parameters

Maintenance scripts provide generic maintenance parameters, script dependent parameters and depending on the maintenance script script specific parameters which are described on this page if provided.

Script specific parameters
Parameter Description
--v Be verbose about the progress5
--quick Skip the five second countdown sequence5
--optimize Run possible table optimization67
--report-runtime Return memory usage and runtime of the respective script execution1
--with-maintenance-log Add a log entry to "Special:Logs" on the wiki and report the script's runtime8

File:OOjs UI icon lightbulb-yellow.svg <translate> Note:</translate> If you are using this parameter make sure that MediaWiki's configuration parameter $wgMaxNameChars (MediaWiki.org) is set to a value not lower than "32".9 Otherwise an exception will be issued informing about the minimum value for this setting ("32" or higher is recommended).10


Examples

#scite could not render a citation text for reference "gh:smw:1763" because type "issue" was not assigned to a template.
#scite could not render a citation text for reference "gh:smw:1764" because type "issue" was not assigned to a template.
#scite could not render a citation text for reference "gh:smw:2120" because type "pullrequest" was not assigned to a template.
#scite could not render a citation text for reference "gh:smw:4553" because type "pullrequest" was not assigned to a template.

References

  1. a b c gh:smw:1481 
  2. ^ gh:smw:1801 
  3. ^ gh:smw:1956 
  4. ^ gh:smw:4553 
  5. a b gh:smw:1763 
  6. ^ gh:smw:2120 
  7. ^  |  Optimizing InnoDB Full-Text Indexes notları "Running OPTIMIZE TABLE on a table with a full-text index rebuilds the full-text index, removing deleted Document IDs and consolidating multiple entries for the same word, where possible."
  8. ^ gh:smw:1764 
  9. ^ gh:smw:1983 
  10. ^ gh:smw:1985