Sphinx

debug.sh

#wstars sphinx index files location 
cd  /var/intafeen/sphinx/
# remove all indexes 
rm *
su searchd
# rerun index
/usr/local/bin/indexer --config /usr/local/etc/sphinx.conf venues_idx

    ls -alh
  
     rm *
# rerun index with verbose mode  
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf venues_idx --verbose
# rerun index with buildstops
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf venues_idx ----buildstops
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf venues_idx --buildstops
     ls
     rm *
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf venues_idx --buildstops
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf venues_idx --verbose
     /usr/local/bin/indexer  venues_idx --buildstops
# chech index freq words 
     /usr/local/bin/indexer  venues_idx --buildstops word_freq.txt 1000
     ls
     vi word_freq.txt 
     grep dom word_freq.txt 
     /usr/local/bin/indexer  venues_idx --buildstops word_freq.txt 
     /usr/local/bin/indexer  venues_idx --buildstops word_freq.txt 100000
     grep dom word_freq.txt 
     grep dom word_freq.txt -n
     more word_freq.txt | grep dom
     more word_freq.txt | grep dom 
     mn GREP
     man grep
     /usr/local/bin/indexer  venues_idx --buildstops word_freq.txt 100000 --buildfreqs
     grep dom word_freq.txt -n
     mysql -P 9306
     exit
     #run delta index
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf delta_idx
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf --all
     #merge two index results 
     /usr/local/bin/indexer --config /usr/local/etc/sphinx.conf --merge venues_idx delta_idx
     search Dom
     exit
     crontab -e
# search in idex about keeword     
    search <keeword>



search Dom
crontab -e
/etc/init.d/searchd stop
 /etc/init.d/searchd start
 
#restart
sudo /etc/init.d/searchd stop
sudo /etc/init.d/searchd start

ref

http://sphinxsearch.com/docs/archives/2.0.1/
http://www.howtoforge.com/sphinx-as-mysql-storage-engine-sphinxse