semantic-mediawiki.org


● General 

●Semantic MediaWiki

●Introduction

●Getting support

●Community portal

●Open Semantic Data Association

●SMWCon

●Recent changes
 


● Users 

●Manual

●Getting started

●Report a bug

●Sandbox wiki

●MediaWiki
 


● Admini­strators 

●Manual

●Store and search environment

●Features and supplementary functions

●Installation

●Configuration

●Maintenance

●Report a bug

●Sandbox wiki

●MediaWiki
 


● Devel­opers 

●Manual

●Source code

●Code documentation

●Report a bug

●Sandbox wiki

●MediaWiki
 


● ?

●Getting support

●Frequent questions

●Missing content

●Missing translation

●Found an error
 




● ...  

●Discussion
 
●View source

●History
 








●Log in

●Request account
 

















 v3.2.0+ 
 Status:effective
 Progress:100%
 Version:3.2.0+



 

Maintenance script "rebuild­Fulltext­Search­Table.php"

 
From semantic-mediawiki.org
Jump to:navigation, search
 

rebuildFulltextSearchTable.php
Allows to rebuild the full text search data table
Further Information
Provided by: Semantic MediaWiki
Added: 2.5.0
Removed: still in use
Location (path): ./extensions/SemanticMediaWiki/maintenance/
Table of Contents

Contents

  • 1 Usage
  • 2 Parameters
  • 3 Examples

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 14 March 2017 and compatible with MW 1.23.0 - 1.29.x.1 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 7 September 2020 and compatible with MW 1.31.0 - 1.35.x. 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[edit]

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

Parameters[edit]

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

Note Note:  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[edit]

  • Using maintenance script "rebuildFulltextSearchTable.php" with the --quick and --report-runtime parameters
  • Using maintenance script "rebuildFulltextSearchTable.php" with the the --v parameter
  • Using maintenance script "rebuildFulltextSearchTable.php" without a parameter



References

  1. a b c  |  Semantic MediaWiki: GitHub pull request gh:smw:1481
  • ^  |  Semantic MediaWiki: GitHub pull request gh:smw:1801
  • ^  |  Semantic MediaWiki: GitHub pull request gh:smw:1956
  • ^  Semantic MediaWiki: GitHub pull request gh:smw:4553
  • a b  Semantic MediaWiki: GitHub issue gh:smw:1763
  • ^  Semantic MediaWiki: GitHub pull request gh:smw:2120
  • ^  |  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."
  • ^  Semantic MediaWiki: GitHub issue gh:smw:1764
  • ^  Semantic MediaWiki: GitHub issue gh:smw:1983
  • ^  Semantic MediaWiki: GitHub pull request gh:smw:1985

  • Retrieved from "https://www.semantic-mediawiki.org/w/index.php?title=Help:Maintenance_script_rebuildFulltextSearchTable.php&oldid=74272"
     

    Categories: 
    ●Maintenance scripts
    ●Document
     












    ●What links here

    ●Related changes

    ●Special pages

    ●Printable version

    ●Permanent link

    ●Page information

    ●Cite this page

    ●Browse properties
     













    ●This page was last edited on 17 February 2020, at 10:07.

    ●Content is available under "Attribution 3.0 Germany" (CC BY 3.0 DE) unless otherwise noted.
     














    ●Privacy policy

    ●About <semantic-mediawiki.org> (Imprint)

    ●Disclaimers
     




    "Attribution 3.0 Germany" (CC BY 3.0 DE)
    Powered by MediaWiki
    Powered by Semantic MediaWiki