[HOWTO] Install Sphinx for A Script Pro
Hi,
Here's a small howto on installing Sphinx Search (http://sphinxsearch.com/) and configuring it to work with Adult Script Pro. By using sphinx
you will be able to allow users to search for video on your adult tube site by title, description and tags. The search results will be automatically
ordered by relevance (its almost the same as using mysql MATCH_AGAINST, but faster and it can support even 1.000.000 videos).
You will need ssh root access. The installation itself is quite easy, depending on your distribution:
Ubuntu (tested on Ubuntu 10.10):
1 2 | sudo apt-get update sudo apt-get install sphinxsearch |
CentOs (tested on 5.4):
1 | yum install sphinx |
Configuring sphinx si also straight forward, all you need to do is edit the sphinx configuration file and add:
source videos { type = mysql sql_host = localhost sql_user = mysql-username sql_pass = mysql-password sql_db = mysql-database sql_sock = /var/lib/mysqld/mysqld.sock (this depends on your server) sql_port = 3306 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT v.video_id, v.title, v.description, v.mobile, v.add_time, \ v.rating, v.total_views, v.duration, v.video_id AS video, \ #added in RC4 GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS tags \ FROM video AS v \ LEFT JOIN video_tags AS t ON (t.video_id = v.video_id) \ WHERE v.status = 1 \ GROUP BY v.video_id sql_attr_uint = video #added in RC4 sql_attr_uint = mobile sql_attr_uint = total_views sql_attr_float = duration sql_attr_float = rating sql_attr_timestamp = add_time sql_attr_multi = uint categories FROM query; SELECT video_id, cat_id FROM video_category sql_query_info = SELECT video_id, add_date FROM video WHERE video_id=$id } index videos { source = videos path = /var/lib/sphinxsearch/data/videos (this depends on your distribution) charset_type = utf-8 min_prefix_len = 3 enable_star = 1 } searchd { port = 3312 log = /var/log/sphinxsearch/searchd.log (this depends on your distribution) query_log = /var/log/sphinxsearch/query.log (this depends on your distribution) pid_file = /var/log/sphinxsearch/searchd.pid (this depends on your distribution) }
The sphinx data and log folders might depend on your distribution.
After this you need to create the initial index with the following command:
1 | indexer --all --config /path/to/your/sphinx/configuration/file .conf |
You will also need to create a cron file and place it into the /etc/cron.hourly (or add it to cron from cpanel or console). The script
should be named sphinx and chmoded to 755, with the following contents:
#!/bin/bash /usr/bin/indexer --all --rotate --config /path/to/your/sphinx/configuration/file.conf
Thats it :-)
If you dont have the time do the installation yourself, or you dont like the linux console, just drop us a email and we can do the installation
for 49$.
source videos { type = mysql sql_host = localhost sql_user = mysql-username sql_pass = mysql-password sql_db = mysql-database sql_sock = /var/lib/mysqld/mysqld.sock (this depends on your server) sql_port = 3306 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT v.video_id, v.title, v.description, v.mobile, v.add_time, \ v.rating, v.total_views, v.duration, \ GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS tags \ FROM video AS v \ LEFT JOIN video_tags AS t ON (t.video_id = v.video_id) \ AND v.status = 1 \ GROUP BY v.video_id sql_attr_uint = mobile sql_attr_uint = total_views sql_attr_float = duration sql_attr_float = rating sql_attr_timestamp = add_time sql_attr_multi = uint categories FROM query; SELECT video_id, cat_id FROM video_category sql_query_info = SELECT video_id, add_date FROM video WHERE video_id=$id } index videos { source = videos path = /var/lib/sphinxsearch/data/videos (this depends on your distribution) charset_type = utf-8 min_prefix_len = 3 enable_star = 1 } searchd { port = 3312 log = /var/log/sphinxsearch/searchd.log (this depends on your distribution) query_log = /var/log/sphinxsearch/query.log (this depends on your distribution) pid_file = /var/log/sphinxsearch/searchd.pid (this depends on your distribution) }
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 智能桌面机器人:用.NET IoT库控制舵机并多方法播放表情
· Linux glibc自带哈希表的用例及性能测试
· 深入理解 Mybatis 分库分表执行原理
· 如何打造一个高并发系统?
· .NET Core GC压缩(compact_phase)底层原理浅谈
· 新年开篇:在本地部署DeepSeek大模型实现联网增强的AI应用
· DeepSeek火爆全网,官网宕机?本地部署一个随便玩「LLM探索」
· Janus Pro:DeepSeek 开源革新,多模态 AI 的未来
· 上周热点回顾(1.20-1.26)
· 【译】.NET 升级助手现在支持升级到集中式包管理