gistfile1.txt

19:15 cake ~ # nano /etc/sphinxsearch/sphinx.conf

19:16 cake ~ # tail -n2 /etc/sphinxsearch/sphinx.conf

echo "\n\n# ".time()."\n\n";

19:16 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 192899 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192899 docs, 24348201 bytes
total 45.590 sec, 534066 bytes/sec, 4231.15 docs/sec
total 366 reads, 0.123 sec, 424.5 kb/call avg, 0.3 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:16 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:17 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 192899 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192899 docs, 24348201 bytes
total 45.761 sec, 532063 bytes/sec, 4215.28 docs/sec
total 366 reads, 0.354 sec, 424.5 kb/call avg, 0.9 msec/call avg
total 278 writes, 0.235 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=11357).

19:17 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:17 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 192899 docs, 24.3 MB
collected 648342 attr values
sorted 1.3 Mvalues, 100.0% done
sorted 21.3 Mhits, 100.0% done
total 192899 docs, 24348201 bytes
total 46.113 sec, 528008 bytes/sec, 4183.15 docs/sec
total 366 reads, 0.792 sec, 424.5 kb/call avg, 2.1 msec/call avg
total 278 writes, 0.225 sec, 876.3 kb/call avg, 0.8 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=11357).

19:18 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)))