Skip to content

Instantly share code, notes, and snippets.

@barryhunter
Created Mar 26, 2018
Embed
What would you like to do?
Manticore Test part 2
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))
18:59 cake ~ # service manticore restart
manticore stop/waiting
manticore start/running, process 11357
18:59 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:59 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:59 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.637 sec, 522070 bytes/sec, 4136.09 docs/sec
total 366 reads, 0.097 sec, 424.5 kb/call avg, 0.2 msec/call avg
total 278 writes, 0.234 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=11357).
19:00 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)))
19:00 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)))
19:00 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.741 sec, 532301 bytes/sec, 4217.15 docs/sec
total 366 reads, 0.322 sec, 424.5 kb/call avg, 0.8 msec/call avg
total 278 writes, 0.246 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=11357).
19:01 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