Using maintenance script "rebuildFulltextSearchTable.php" with the --quick
and --report-runtime
parameters
From semantic-mediawiki.org
Maintenance script example | |
---|---|
This page shows an example on how to use maintenance script "rebuildFulltextSearchTable.php" with the --quick and --report-runtime parameters.
| |
Script | |
Keywords | |
The following command rebuilds the database table used for the full-text search feature prompting elaborate progress information.
- Shell command
php rebuildFulltextSearchTable.php php rebuildFulltextSearchTable.php --quick --report-runtime
- Prompt shown
The script rebuilds the search index from property tables that
support a fulltext search. Any change of the index rules (altered
stopwords, new stemmer etc.) and/or a newly added or altered table
requires to run this script again to ensure that the index complies
with the rules set forth by the DB or Sanitizer.
- ICU (Intl) PHP-extension 52.1
- Tesa::Sanitizer 0.2
- Tesa::Transliterator 0.2
- Tesa::LanguageDetector (disabled)
The following properties are exempted from the fulltext search index.
- _ASKFO, _ASKST, _IMPO, _LCODE, _UNIT, _CONV, _TYPE, _ERRT, __sil_iwl_lang
- __sil_ill_lang
The entire index table is going to be purged first and
it may take a moment before the rebuild is completed due to
dependencies on table content and selected options.
The index table was purged.
Rebuilding the text index from (rows finished/expected):
- smw_di_blob 100% (895/895)
- smw_di_uri 100% (71/71)
- smw_fpt_pval 100% (91/91)
- smw_fpt_list 100% (4/4)
- smw_fpt_serv 100% (1/1)
- smw_fpt_text 100% (47/47)
- smw_fpt_dtitle 100% (48/48)
- smw_fpt_media 100% (13/13)
- smw_fpt_mime 100% (13/13)
- smw_fpt_sci_cite_key 100% (65/65)
- smw_fpt_sci_cite_reference 100% (66/66)
- smw_fpt_sci_cite_text 100% (65/65)
- smw_fpt_sci_doi 100% (9/9)
- smw_fpt_sci_pmcid 100% (12/12)
- smw_fpt_sci_pmid 100% (2/2)
Memory used: 3911416 (b: 24641480, a: 28552896) with a runtime of 2.8 sec