Re: [Maria-developers] sphinx vs mariadb
![](https://secure.gravatar.com/avatar/4fc604ab23418de13c2916a85be32da1.jpg?s=120&d=mm&r=g)
Hello Kristian, Thursday, May 27, 2010, 1:20:59 PM, you wrote: KN> [Cc:ed maria-developers@ for general interest, hope that's ok] That's fine. Seems you bcc-ed though. ;)
Mine was 1.10. Downgrading to 1.9.6 did the trick, thanks. KN> Ok, good, at some point we can get someone to help sort out what KN> the problem might be with 1.10.
Or at least add some check that'd *clearly* complain about improper version. Fighting with 1.10 was.. emotional.
1. Use prebuilt searchd binary, sphinx.conf file and test index KN> My idea is that mysql-test-run.pl will look for an already KN> installed searchd and indexer binary (in eg. SPHINXSEARCH_INDEXER, KN> SPHINXSEARCH_SEARCD, and maybe $PATH). If not found, sphinxse
That's also good. For some reason I though everything should be self contained (ie. work immediately out of bzr clone). KN> tests will be skipped, if found mysql-test-run.pl will generate a KN> simple .conf and start the daemon for the test. There is already a Hmm, why *generate* that? I'd just bundle .conf and source .xml data for indexer. Maybe prebuilt .sp* indexes too. Indexes are binary but test ones can be kept tiny. -- Best regards, Andrew mailto:shodan@shodan.ru
![](https://secure.gravatar.com/avatar/99fde0c1dfd216326aae0aff30d493f1.jpg?s=120&d=mm&r=g)
Andrew Aksyonoff
1. Use prebuilt searchd binary, sphinx.conf file and test index KN> My idea is that mysql-test-run.pl will look for an already KN> installed searchd and indexer binary (in eg. SPHINXSEARCH_INDEXER, KN> SPHINXSEARCH_SEARCD, and maybe $PATH). If not found, sphinxse
That's also good. For some reason I though everything should be self contained (ie. work immediately out of bzr clone).
I got something working for this. I pushed it here: lp:~knielsen/maria/5.2-sphinxse It still have a few rough edges that I want to polish, but now I can do this: export SPHINXSEARCH_INDEXER=/home/knielsen/devel/maria/sphinxsearch/bin/indexer export SPHINXSEARCH_SEARCHD=/home/knielsen/devel/maria/sphinxsearch/bin/searchd ./mtr sphinx.sphinx To run this test case: ----------------------------------------------------------------------- --source include/have_sphinx.inc --source include/have_sphinxse.inc --replace_result $SPHINXSEARCH_PORT SPHINXSEARCH_PORT eval create table ts ( id int unsigned not null, w int not null, q varchar(255) not null, index(q) ) engine=sphinx connection="sphinx://127.0.0.1:$SPHINXSEARCH_PORT/*"; select * from ts where q='test'; drop table ts; ----------------------------------------------------------------------- I hope this sounds reasonable, I wanted to give you the chance to see more concretely what I had in mind.
KN> tests will be skipped, if found mysql-test-run.pl will generate a KN> simple .conf and start the daemon for the test. There is already a
Hmm, why *generate* that? I'd just bundle .conf and source .xml data for indexer. Maybe prebuilt .sp* indexes too. Indexes are binary but test ones can be kept tiny.
Well, .conf must be generated from a template due to allocation of ports etc. But I have to admit I didn't even think of bundling this stuff, just blindly ran `indexer test1`. I'm too tired now to think clearly what's best right now ;-) Feel free to come with suggestions. - Kristian.
![](https://secure.gravatar.com/avatar/4fc604ab23418de13c2916a85be32da1.jpg?s=120&d=mm&r=g)
Hello Kristian, Friday, May 28, 2010, 2:37:07 AM, you wrote: KN> It still have a few rough edges that I want to polish, but now I can do this: KN> export SPHINXSEARCH_INDEXER=/home/knielsen/devel/maria/sphinxsearch/bin/indexer KN> export SPHINXSEARCH_SEARCHD=/home/knielsen/devel/maria/sphinxsearch/bin/searchd KN> ./mtr sphinx.sphinx Just tried and this does not seem to work for me... shodan@dev1:~/maria/mysql-test$ set | grep SPHINX SPHINXSEARCH_INDEXER=/home/shodan/s/bin/indexer SPHINXSEARCH_SEARCH=/home/shodan/s/bin/searchd shodan@dev1:~/maria/mysql-test$ ls -la /home/shodan/s/bin/indexer -rwxr-xr-x 1 shodan shodan 4013095 2010-06-02 13:22 /home/shodan/s/bin/indexer shodan@dev1:~/maria/mysql-test$ ./mtr sphinx.sphinx Logging: ./mtr sphinx.sphinx ... TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 sphinx.sphinx [ skipped ] Test requires Sphinx runtime/binaries KN> I hope this sounds reasonable, I wanted to give you the chance to KN> see more concretely what I had in mind. Yep, looks good. -- Best regards, Andrew mailto:shodan@shodan.ru
![](https://secure.gravatar.com/avatar/4fc604ab23418de13c2916a85be32da1.jpg?s=120&d=mm&r=g)
Hello Andrew, Wednesday, June 2, 2010, 3:32:53 PM, you wrote: AA> Just tried and this does not seem to work for me... AA> SPHINXSEARCH_SEARCH=/home/shodan/s/bin/searchd Please disregard, just noticed a stupid typo. I'll be adding a few more tests now, thanks. -- Best regards, Andrew mailto:shodan@shodan.ru
participants (2)
-
Andrew Aksyonoff
-
Kristian Nielsen