Mattsmith321
Pages I am have worked on / am working on:
Notes
editSELECT id, weight() AS w, w + ((view_cnt + 1) / 10) + (link_cnt * 10) + edit_cnt + (category_cnt * 10) - (edit_age / 10) AS page_rank, view_cnt, link_cnt, edit_age, edit_cnt, category_cnt FROM wiki_main WHERE MATCH('blue ribbon') AND page_namespace=0 AND page_is_redirect=0 ORDER BY page_rank DESC OPTION field_weights=(page_title=100, old_text=1);
SELECT * FROM wiki_main,wiki_incremental WHERE MATCH('control') AND page_namespace=0 AND page_is_redirect=0 ORDER BY weight() + ((view_cnt + 1) / 10) + (link_cnt * 10) + edit_cnt + (category_cnt * 10) - (edit_age / 10) ;
'old_text' => 1, 'page_title' => 100
Changes: sphinx.conf - new queries - query log output - sphinxql listener LocalSettings.php - new params my.ini
Advanced changes
LocalSettings.php
$wgSearchType = 'SphinxMWSearch';
require_once( "$IP/extensions/SphinxSearch/SphinxSearch.php" );
$wgSphinxSearch_ranker = SPH_RANK_PROXIMITY_BM25;
$wgSphinxSearch_sortmode = SPH_SORT_EXPR;
$wgSphinxSearch_sortby = '@weight + ((view_cnt + 1) / 10) + (link_cnt * 10) + edit_cnt + (category_cnt * 10) - (edit_age / 10)';
$wgEnableMWSuggest = true;
$wgEnableSphinxPrefixSearch = false;
- Weights of individual indexed columns. This gives page titles extra weight
$wgSphinxSearch_weights = array( 'old_text' => 1, 'page_title' => 10 );
- $wgSphinxSearch_sortmode = SPH_SORT_EXPR;
- $wgSphinxSearch_sortby = '@weight + page_counter + (pl_count * 10)';
Indexing
editc:\Wiki\Sphinx\sphinx-2.0.6-release-win32\bin>indexer --config C:\Wiki\Sphinx\sp hinx-2.0.6-release-win32\sphinx.conf --all Indexing times for 57,000 articles:
- Default: 2 mins
- Basic:
- Advanced: