Skip to content

Instantly share code, notes, and snippets.

@barryhunter
Created Mar 26, 2018
Embed
What would you like to do?
18:36 cake ~ # grep expand_keywords /etc/sphinxsearch/sphinx.d/tags.conf
expand_keywords = 1
18:36 cake ~ # ls -l /etc/sphinxsearch/sphinx.d/tags.conf
-rw-r--r-- 1 manticore manticore 1552 Mar 26 18:02 /etc/sphinxsearch/sphinx.d/tags.conf
18:37 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:38 cake ~ # touch /etc/sphinxsearch/sphinx.d/tags.conf
18:38 cake ~ # sudo -u manticore /usr/bin/indexer --config /etc/sphinxsearch/sphinx.conf tags --rotate
Manticore 2.6.2 0bbd194@180223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2018, Manticore Software LTD (http://manticoresearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'tags'...
WARNING: dict=crc deprecated, use dict=keywords instead
WARNING: dict=crc deprecated, use dict=keywords instead
collected 192898 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192898 docs, 24348167 bytes
total 46.219 sec, 526796 bytes/sec, 4173.53 docs/sec
total 366 reads, 0.663 sec, 424.5 kb/call avg, 1.8 msec/call avg
total 278 writes, 0.259 sec, 876.3 kb/call avg, 0.9 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=24882).
18:39 cake ~ # grep expand_keywords /etc/sphinxsearch/sphinx.d/tags.conf
expand_keywords = 1
18:39 cake ~ # ls -l /etc/sphinxsearch/sphinx.d/tags.conf
-rw-r--r-- 1 manticore manticore 1552 Mar 26 18:38 /etc/sphinxsearch/sphinx.d/tags.conf
18:39 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:39 cake ~ # nano /etc/sphinxsearch/sphinx.d/tags.conf
18:40 cake ~ # grep expand_keywords /etc/sphinxsearch/sphinx.d/tags.conf
expand_keywords = star
18:40 cake ~ # ls -l /etc/sphinxsearch/sphinx.d/tags.conf
-rw-r--r-- 1 manticore manticore 1555 Mar 26 18:40 /etc/sphinxsearch/sphinx.d/tags.conf
18:40 cake ~ # sudo -u manticore /usr/bin/indexer --config /etc/sphinxsearch/sphinx.conf tags --rotate
Manticore 2.6.2 0bbd194@180223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2018, Manticore Software LTD (http://manticoresearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'tags'...
WARNING: dict=crc deprecated, use dict=keywords instead
WARNING: dict=crc deprecated, use dict=keywords instead
collected 192898 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192898 docs, 24348167 bytes
total 45.427 sec, 535980 bytes/sec, 4246.29 docs/sec
total 366 reads, 0.293 sec, 424.5 kb/call avg, 0.8 msec/call avg
total 278 writes, 0.232 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=24882).
18:41 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree OR(\n AND(KEYWORD(str, querypos=1)), \n AND(KEYWORD(str*, querypos=1)))
18:41 cake ~ # sudo -u manticore /usr/bin/indexer --config /etc/sphinxsearch/sphinx.conf tags --rotate
Manticore 2.6.2 0bbd194@180223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2018, Manticore Software LTD (http://manticoresearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'tags'...
WARNING: dict=crc deprecated, use dict=keywords instead
WARNING: dict=crc deprecated, use dict=keywords instead
collected 192898 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192898 docs, 24348167 bytes
total 45.568 sec, 534315 bytes/sec, 4233.10 docs/sec
total 366 reads, 0.537 sec, 424.5 kb/call avg, 1.4 msec/call avg
total 278 writes, 0.248 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=24882).
18:42 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:42 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:47 cake ~ # sudo -u manticore /usr/bin/indexer --config /etc/sphinxsearch/sphinx.conf tags --rotate
Manticore 2.6.2 0bbd194@180223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2018, Manticore Software LTD (http://manticoresearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'tags'...
WARNING: dict=crc deprecated, use dict=keywords instead
WARNING: dict=crc deprecated, use dict=keywords instead
collected 192898 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192898 docs, 24348167 bytes
total 45.749 sec, 532208 bytes/sec, 4216.41 docs/sec
total 366 reads, 0.677 sec, 424.5 kb/call avg, 1.8 msec/call avg
total 278 writes, 0.244 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=24882).
18:48 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:48 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:48 cake ~ # grep expand_keywords /etc/sphinxsearch/sphinx.d/tags.conf
expand_keywords = star
18:49 cake ~ # nano /etc/sphinxsearch/sphinx.d/tags.conf
18:49 cake ~ # grep expand_keywords /etc/sphinxsearch/sphinx.d/tags.conf
expand_keywords = 1
18:49 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:49 cake ~ # sudo -u manticore /usr/bin/indexer --config /etc/sphinxsearch/sphinx.conf tags --rotate
Manticore 2.6.2 0bbd194@180223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2018, Manticore Software LTD (http://manticoresearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'tags'...
WARNING: dict=crc deprecated, use dict=keywords instead
WARNING: dict=crc deprecated, use dict=keywords instead
collected 192898 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192898 docs, 24348167 bytes
total 46.050 sec, 528724 bytes/sec, 4188.81 docs/sec
total 366 reads, 0.340 sec, 424.5 kb/call avg, 0.9 msec/call avg
total 278 writes, 0.241 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=24882).
18:50 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree OR(\n AND(KEYWORD(str, querypos=1)), \n AND(KEYWORD(str*, querypos=1)))
18:50 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree OR(\n AND(KEYWORD(str, querypos=1)), \n AND(KEYWORD(str*, querypos=1)))
18:50 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree OR(\n AND(KEYWORD(str, querypos=1)), \n AND(KEYWORD(str*, querypos=1)))
18:50 cake ~ # sudo -u manticore /usr/bin/indexer --config /etc/sphinxsearch/sphinx.conf tags --rotate
Manticore 2.6.2 0bbd194@180223 release
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2018, Manticore Software LTD (http://manticoresearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'tags'...
WARNING: dict=crc deprecated, use dict=keywords instead
WARNING: dict=crc deprecated, use dict=keywords instead
collected 192898 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192898 docs, 24348167 bytes
total 45.481 sec, 535343 bytes/sec, 4241.24 docs/sec
total 366 reads, 0.429 sec, 424.5 kb/call avg, 1.1 msec/call avg
total 278 writes, 0.322 sec, 876.3 kb/call avg, 1.1 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=24882).
18:51 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
18:51 cake ~ # echo "set profiling=1;select * from tags where match('str') limit 0; show plan;" | mysql -h192.168.77.90 --protocol=tcp -P9306
Variable Value
transformed_tree AND(KEYWORD(str, querypos=1))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment