| Status: | effective |
| Progress: | 100% |
| Version: | 3.2.0+ |
Maintenance script "rebuildFulltextSearchTable.php"
| 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 | |
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
Usage[edit]
php rebuildFulltextSearchTable.php [--v|--quick|--optimize|--report-runtime|--with-maintenance-log]
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: If you are using this parameter make sure that MediaWiki's
Examples[edit]
References
- 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 notes "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
