Manticore Test part 2

log.txt

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))