Stack Overflow
Stack Overflow

Questions tagged [sphinx]

Sphinx is a free software search engine for indexing database content. NOTE: For the Python documentation tool, use the [python-sphinx] tag.

Sphinx (SQL Phrase Index) is a standalone full-text search engine that provides efficient search functionality to third-party applications, especially SQL databases. This search engine was developed in 2001 by a Russian developer named Andrew Aksyonoff to guarantee a (1) good search quality, (2) performed at high speed (3) with a low resource consumption (Disk IO, CPU). It can be integrated with scripting languages such as Python and Java.

Sphinx is a free software search engine. It currently supports , , and ODBC-compliant databases as data sources natively. Other data sources can be indexed via a pipe in a custom format. It is distributed under the terms of the GNU General Public License version two or a proprietary license.

Starting from version 0.9.9, querying is possible using SphinxQL, a subset of SQL. Starting from version 1.10-beta, both incremental and batch indexing is supported.

Do not use this tag for the documentation tool written in Python; use for that.

External Resources

2436 questions
0
votes
1 answer

n_tied_num.mdef and alltriphones.mdef for reading was not found

While I was training my native language (Amharic) using SphinxTrain-5prealpha.... Fatal error happened when creating the PRUNE TREE and Training the Context dependent models. Training wav file is about 19 hours WAVFILE_SRATE 16000. check this link…
ash
  • 2,902
  • 3
  • 19
  • 34
0
votes
0 answers

SphinxSE with MariaDB not returning result

I am using MariaDB 10.1.19 and Sphinx 2.2.10 I am trying to query the Sphinx server using SphinxSE plugin available in MariaDB but I'm getting "OK" as response instead of result (rows). Query : SELECT * FROM from_sphinx_documents Where query…
Hemender Singh Thakuri
  • 21
  • 7
0
votes
0 answers

Regexp_filter in Sphinx not behaving as expected

I was using regexp_filter to do replacements in a client selection that is powered by sphinx. I tried to make the regexp more efficient so instead of regexp_filter=Dr(.)? Jones=>Doctor Louis regexp_filter=Dr(.)? Smith=>Doctor Alban I…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Use Sphinx to Compare Fields and/or update

I have a value in FieldA and another value in FieldB that is stored for comparison purposes by a downstream function. I need to compare if FieldA=FieldB which I do with Mysql: Select TableA T1 Inner Join TableB T2 On T1.ID=T2.ID and…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
0 answers

Rails thinking sphinx includes not working

I have the code like following Listing.search( Riddle::Query.escape(params[:search]), :include => params[:include], :page => page, :per_page => per_page, :star => true, :with => with, :with_all =>…
Premanandh Selvakumarasamy
  • 1,332
  • 7
  • 27
0
votes
1 answer

Sphinx - Breaks utf8 character to space

I have a string seule la présentation. When I do a phrase search "pr", sphinx matches this string but it should not as there is no word pr present in it. But when searched for "pre", it does not match. The problem seems to be with this utf8…
Samir Selia
  • 7,007
  • 2
  • 11
  • 30
0
votes
0 answers

Sphinx: create RT index without reload searchd

Is there any way to create RT without reloading the searchd? For example, I have script generating sphinx.conf file, where the number of indexes depends on how many instances of some class I have. If I create another instance and reload searchd,…
C1one_38
  • 65
  • 1
  • 11
0
votes
2 answers

Separate database for Sphinx search engine

I wonder if there is any way to keep main database clean of any Sphinx related tables? Details: I have a database indexed by Sphinx. Being pretty big I used main + delta indexing recipe but in order to achieve that I had to add additional tables for…
Alex
  • 5,510
  • 8
  • 35
  • 54
0
votes
0 answers

Can Sphinx accidentally 'cache' conf files?

I have an index I rotate as I make changes to the table or conf which had an associated wordform file where I created a wordform to map among other things: Ft > Fort I ended up removing that from the workdform and re-rotating and re-rotated…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
0 answers

Sphinx issues with specific partial cap words

My sphinx queries seem to behave as expected e.g. if I search for CIA it will find In the CIA and not is special or even is SPECIAL. If I search for LAN or VLA will not find VLAN only if I search for VLAN For some reason it breaks with CTS.…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

Escaping in Sphinx

I am trying to match a phrase in a document which unfortunately in the catalog I have is formatted like this: Includes sides?** *No* or Includes sides?** *Yes* searching for either one fails e.g. Search idx_test where MATCH('"Includes sides?**…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
3 answers

Is it possible to install Sphinx after php, mysql etc.. have already been installed?

I'm confused Does order matter when installing Sphinx Search. If mysql was already installed on my server, can I still install sphinx after or do I have to do them together or Sphinx before?
andrewk
  • 3,721
  • 4
  • 30
  • 37
0
votes
1 answer

Search special chars by space in sphinx

i have problem with sphinx search. I have string for indexing xyz a'qwerty I need to find it if i use xy - ok xy a - ok xyz a'qwerty - ok xyz a qwerty - ok xyz a qwe - not ok I rly can't reach right result, know someone how to do this? My index look…
Jimi
  • 33
  • 1
  • 2
  • 10
0
votes
1 answer

Extend sphinx search output with index names

I have 2 sphinx indexes: index1 and index2. When I search in index1: I've got two matches: { error: '', warning: '', status: [ 0 ], fields: [ 'name' ], attrs: [], matches: [ { id: 5731, weight: 2, attrs: {} }, { id: 17236, weight:…
Boris Zagoruiko
  • 12,705
  • 15
  • 47
  • 79
0
votes
0 answers

Sphinxsearch results weights with different rankers

I have one index "name_and_title_index" with two fields "name" and "title". Indextool gives me this information on interested keywords: keyword ,docs ,hits ,offset word7 ,56 ,57 ,519386707 word8 ,154 ,161 …
Anton
  • 56
  • 3
  • 6
1 2 3
…
99
100