https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-sphinx-on-ubuntu-16-04


sudo apt-get install sphinxsearch
sudo nano /etc/sphinxsearch/sphinx.conf
sudo indexer --all

crontab -e
@hourly /usr/bin/indexer --rotate --config /etc/sphinxsearch/sphinx.conf --all >> /var/www/html/uramori.jp/storage/logs/laravel.log 2>&1
@hourly cd /var/www/html/uramori.jp/sphinx-3.3.1/bin && ./indexer --all --rotate >> /var/www/html/uramori.jp/storage/logs/laravel.log 2>&1

sudo sed -i 's/START=no/START=yes/g' /etc/default/sphinxsearch
sudo systemctl restart sphinxsearch.service
sudo systemctl status sphinxsearch.service

mysql -h127.0.0.1 -P9306


$ searchd --status
$ searchd --config /home/myuser/sphinx.conf --status
$ searchd --config /etc/sphinxsearch/sphinx.conf --stop
$ searchd --config /home/myuser/sphinx.conf --stopwait

sudo cp /var/www/html/linkdata/sphinx_config/sphinx.conf /etc/sphinxsearch





$ sudo apt-get install libmysqlclient-dev libpq-dev unixodbc-dev
$ sudo apt-get install libmariadb-client-lgpl-dev-compat

$ wget -q http://sphinxsearch.com/files/sphinx-3.0.2-2592786-linux-amd64.tar.gz
$ tar zxf sphinx-3.0.2-2592786-linux-amd64.tar.gz
$ cd sphinx-3.0.2-2592786-linux-amd64/bin

$ ./searchd

1. Get the binaries.
2. Create sphinx.conf, with at least 1 index section.
3. Run indexer --all once, to initially create the indexes.
4. Run searchd
5. Run queries.
6. Run indexer --all --rotate regularly, to update the indexes.



=================
check port:
sudo netstat -tunlp
kill -9 port_id

//count all file in a folder
find . -type f | wc -l

https://fiddle.tiny.cloud/xghaab

================
/var/run/mysqld/mysqld.sock

WARNING: access denied to PID 24474


#stop current instance
searchd --stop

#change the owner of indexes and logs
chown www-data:www-data /path/to/index/folder/ -r
chown -R www-data:www-data /var/log/sphinxsearch/
chown www-data:www-data /var/log/query.log
chown www-data:www-data /var/log/search.log
chown www-data:www-data /var/log/sphinxsearch/searchd.log

sudo -u www-data searchd
sudo -u www-data ./indexer --all
sudo -u www-data ./searchd

sudo -u www-data ./indexer --all --rotate