| Status: | effective |
| Progress: | 100% |
| Version: | 2.5.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.
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 progress4 |
--quick
|
Skip the five second countdown sequence4 |
--optimize
|
Run possible table optimization56 |
--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 runtime7
|
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
- 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
