Help
Add this page to your book
Show book (0 pages)
Suggest pagesUser talk:MWJames
[edit] A barnstar for you!
 |
The Original Barnstar |
| Thanks for all the help testing and supporting SphinxSearch extension! Svemir Brkic 20:44, 7 September 2011 (UTC) |
[edit] Sie erhalten einen Orden!
 |
Der Technikerorden |
| Thx for Reporting so many Bugs and Testing our extension. I hope you continue to use our our extension. SBachenberg (talk) 07:12, 21 April 2012 (UTC) |
Contents
| Thread title | Replies | Last modified |
|---|---|---|
| Any luck fixing MathJax? | 2 | 08:13, 23 April 2012 |
| Search results sorting | 5 | 14:48, 12 September 2011 |
| SphinxSearch | 6 | 14:48, 28 June 2011 |
I had a similar problem to the one you mentioned in the MathJax discussion except involving the tags... I was wondering if you found a more robust way of writing the mediawiki extension for it. If so, please leave me a message. Thanks also for putting together your list of extensions, it's definitely very helpful!
Since SVN r112835, Extension:Math comes with a MathJax implementation, so it might be that some of the Extension:MathJax problems have been fixed.
The Extension:MathJax has been updated to include options in handling $ and $$, turning on and off, etc and protecting certain tags, you might have a look...
Hi James - you may like to try this: Extension:SphinxSearch/Page_rank
Thanks for effort, right now we are testing and it looks good. Maybe their should be a note that this change will impact the index time since the main index will take around four to five times longer to build the index.
For the incremental index we changed to DATE_FORMAT(CURRENT_TIMESTAMP() - INTERVAL 12 HOUR, '%Y%m%d%h%i%s') to minimize the incremental index time while running the merge function more often.
/path/to/sphinx/bin/indexer --config /path/to/sphinx.conf --rotate --merge wiki_main wiki_incremental --merge-dst-range deleted 0 0
There are probably faster ways to gather the same data. For example, the temporary table could be changed into a regular table and updated on a separate schedule. Or it could be replaced with a different kind of join. I need to update some of the larger wikis I am managing to be able to test with enough data.
BTW, why are you merging the two indexes? For me sphinx works just fine when I tell it to use both of them, and merging process needs to load both of them into RAM to merge them, so it is probably slow on a large wiki. What is the benefit for you?
For us the incremental index is just a temporary index that contains the last 12 hours of changed content. To avoid a main re-indexing (happen once a month for 2GB wiki db) the merge process is running every 6th hour to store the delta in the main index. The IO for the merge process might be higher but it is relatively fast and does have only a minimal impact on the server workload.
That makes sense. How long do these 3 processes take in your case (main index. incremental index, and merge)? Svemir Brkic 11:02, 12 September 2011 (UTC)
I'm having a bunch of issues with the SphinxSearch extension, which you apparently got running successfully. Can you have a look at my problem, maybe you already fixed it, or know how to get around it.
First thing that comes to my mind is to us 0.7.2 from the SVN trunk.
Did that. Figured out the PHP errors, but it's still not working. Updated problem description.
Just to clarify, I assume you did
- run the indexer
- configured the spinx.conf so it is connected to the mysql
Other things that crossed my mind are:
- I thing there was a change in regards to the ports, so your spinx.conf should say port = 9312 instead of port = 3312.
- In your SphinxSearch.php file try to find $wgSphinxSearch_mode and changed it to $wgSphinxSearch_mode = SPH_MATCH_EXTENDED2;
Indexer has ran and the config is correct (I can run the search from command line where it works as it should). Neither ports are getting the desired result (I always get Query failed: connection to localhost:xxxx failed (errno=111, msg=Connection refused) ) and modifying $wgSphinxSearch_mode does not seem to change anything.
The next thing I remember was that we had some trouble with IP vs localhost. In case the server is referred to as to localhost the best thing is to change it and write as IP such as:
SphinxSearch.php $wgSphinxSearch_host = '127.0.0.1'; $wgSphinxSearch_port = 9312;
spinx.conf >> # data source definition for the main index sql_host = 127.0.0.1 >> # searchd settings listen = 127.0.0.1
