Sphinx daemon in Ubuntu
Read the bottom of this post to see the updated version! After install Sphinx Search following the instructions here, I wanted to get the daemon (searchd) running automatically after my Ubuntu Server box restarts. The trick is to install the daemon in the init.d doing the following (as a root sudo -s): First, create /etc/init.d/searchd with this content: #!/bin/sh case "${1:-''}"...
Read MoreSphinx index and MySQL
The problem I’ve been trying to optimize multiple MySQL databases to perform full-text searches. My first attempt was using MyISAM table engine with full-text index support (at this moment the only engine with full-text search compatibility). At the very beginning this was acceptable (performance-wise). But as soon the data on the table was growing the first issues...
Read More