Sphinx Search (sphinx.conf)
Sphinx Search - Exemplo
Categoria: Banco de dados
Software: Sphinx Search
[ Hits: 7.717 ]
Por: Candido Tominaga
Na compilação padrão, você deve colocar esse arquivo em /usr/local/etc/sphinx.conf
Exemplo de uma configuração:
source oficial { type = mysql sql_host = localhost sql_user = usuario sql_pass = senha sql_db = oficial sql_port = 3306 sql_query = SELECT veiculo_id, veiculo_status, veiculo_vencimento, regiao_id, cidade_id, floor(rand() * 1000000000) as rnd, veiculo_modelo, veiculo_marca, veiculo_combustivel FROM veiculo sql_attr_uint = regiao_id sql_attr_uint = cidade_id sql_attr_uint = rnd sql_attr_uint = veiculo_status sql_attr_timestamp = veiculo_vencimento # Versao 0.9.7 sql_group_column = regiao_id sql_group_column = cidade_id sql_group_column = rnd sql_group_column = pat sql_group_column = veiculo_status sql_date_column = veiculo_vencimento sql_group_column = veiculo_particular } index idx_oficial { source = oficial path = /var/data/oficial docinfo = extern mlock = 0 morphology = none # stopwords = /var/data/stopwords.txt # wordforms = /var/data/wordforms.txt # exceptions = /var/data/exceptions.txt min_word_len = 2 charset_type = sbcs # min_prefix_len = 0 # min_infix_len = 0 # prefix_fields = filename # infix_fields = url, domain enable_star = 1 # ngram_len = 1 # ngram_chars = U+3000..U+2FA1F # phrase_boundary = ., ?, !, U+2026 # horizontal ellipsis # phrase_boundary_step = 100 html_strip = 1 # html_index_attrs = img=alt,title; a=title; # html_remove_elements = style, script # preopen = 1 } index idx_oficialstemmed : idx_oficial { path = /var/data/idx_oficial morphology = stem_en } ############################################################################# ## indexer settings ############################################################################# indexer { # memory limit, in bytes, kiloytes (16384K) or megabytes (256M) # optional, default is 32M, max is 2047M, recommended is 256M to 1024M mem_limit = 128M # maximum IO calls per second (for I/O throttling) # optional, default is 0 (unlimited) # # max_iops = 40 # maximum IO call size, bytes (for I/O throttling) # optional, default is 0 (unlimited) # # max_iosize = 1048576 } ############################################################################# ## searchd settings ############################################################################# searchd { # IP address to bind on # optional, default is 0.0.0.0 (ie. listen on all interfaces) # # address = 127.0.0.1 # address = 192.168.0.1 address = 127.0.0.1 # searchd TCP port number # mandatory, default is 3312 port = 3312 # log file, searchd run info is logged here # optional, default is 'searchd.log' log = /var/log/searchd.log # query log file, all search queries are logged here # optional, default is empty (do not log queries) query_log = /var/log/query.log # client read timeout, seconds # optional, default is 5 read_timeout = 5 # maximum amount of children to fork (concurrent searches to run) # optional, default is 0 (unlimited) # max_children = 30 # PID file, searchd process ID file name # mandatory pid_file = /var/log/searchd.pid # max amount of matches the daemon ever keeps in RAM, per-index # WARNING, THERE'S ALSO PER-QUERY LIMIT, SEE SetLimits() API CALL # default is 1000 (just like Google) max_matches = 1000 # seamless rotate, prevents rotate stalls if precaching huge datasets # optional, default is 1 seamless_rotate = 1 # whether to forcibly preopen all indexes on startup # optional, default is 0 (do not preopen) preopen_indexes = 0 # whether to unlink .old index copies on succesful rotation. # optional, default is 1 (do unlink) unlink_old = 1 } # --eof--
Atualizar o macOS no Mac - Opencore Legacy Patcher
Crie alias para as tarefas que possuam longas linhas de comando - bash e zsh
Criando um gateway de internet com o Debian
Configuração básica do Conky para mostrar informações sobre a sua máquina no Desktop
Aprenda a criar músicas com Inteligência Artificial usando Suno AI
Instalando Zoom Client no Ubuntu 24.04 LTS
Instalando Zoom Client no Fedora 40
Instalando Navegador Firefox no Debian 12
Bloqueando propagandas no Youtube e outros sites com o uBlocker Origin
Configurando static ipv6 em placa de rede eth0[DUVIDA] (2)
Sistema da Coréia do Norte - Red Star OS (59)