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

Use different table column for sphinx search weight sorting

Rather than the default sorting in sphinx, I would like to sort/weight results based on a field in another table. My schema looks like this: node { id weight } node_text { id node_id text } (Note: There is only one node_text for each…
Xeoncross
  • 55,620
  • 80
  • 262
  • 364
0
votes
2 answers

Sphinx wildcard match on realtime index

I have created realtime index: index berni_filter2 { rt_mem_limit = 512M type = rt path = /var/lib/sphinxsearch/data/berni_filter rt_attr_uint = product_id rt_attr_uint = store_id rt_field …
gvozd1989
  • 300
  • 1
  • 16
0
votes
3 answers

Full text search by summaries

Is it possible to create a summary of a large document using some out-of-the-box search engines, like Lucene, Solr or Sphinx and search documents most relevant to a query? I don't need to search inside the document or create a snippet. Just get 5…
Denis Kulagin
  • 8,472
  • 17
  • 60
  • 129
0
votes
1 answer

Sphinx Search use_boundaries in SINPPET

I have an index rt with following configuration index rt { type = rt min_stemming_len = 4 morphology = stem_en wordforms = /home/mis/syns.txt exceptions = /home/mis/exp.txt # english charset defined with alias …
Abhilash Joseph
  • 1,196
  • 1
  • 14
  • 28
0
votes
1 answer

Wrong matching results with Sphinx

Mysql query in sphinx config: SELECT c.id, c.name, p.vendor FROM categories AS c LEFT JOIN ( SELECT DISTINCT vendor, category_id FROM clothes ) p ON c.id = p.category_id ORDER BY c.name Query…
966p
  • 535
  • 2
  • 7
  • 17
0
votes
1 answer

Automatic change searchd.production.pid ownership to desired owner after Sphinx restart

I have two users in my server: root and development. Everytime Sphinx is restarted, the ownership of searchd.production.pid always changed to root. I always use the development to do any cap, update code, etc. though. I have this in my…
Victor
  • 13,010
  • 18
  • 83
  • 146
0
votes
1 answer

Index & in Sphinx?

I keep adding to my exceptions.txt file in m Sphinx configuration for acornyms that contain & e.g: A&E => A&E so that it is not indexed as two separate letters. However it is getting monotonous and I wonder if I can/should somehow just make '&'…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
0 answers

Using $ (dollar sign) in sphinx search

I'm trying to set up fulltext search using sphinx (v2.3.2-beta) for my music-related website. When a user searchs for 'kesha', he must also find 'Ke$ha'. In order to do this, I added this to my charset_table: U+0024->s, U+FF04->s, U+FE69->s After…
Bram
  • 51
  • 7
0
votes
1 answer

searchd.development.pid.lock permission?

Whenever I try to run my app on my local machine, I get this, and of course, it's not working. There is no searchd.development.pid file in the log directory. MB:my_app victor$ ./script/server => Booting WEBrick => Rails 2.3.8 application starting on…
Victor
  • 13,010
  • 18
  • 83
  • 146
0
votes
0 answers

Using 'OR' in SphinxQL

I can use pipes in side the MATCH in SphinxQl e.g. Select * from idx_A where MATCH('(@(Title) Apple)|(@(Body) Orange)') but not outside the match Select * from idx_A where MATCH('(@(Title) Apple)|(@(Body) Orange)') and Title='Apple' or…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

Using custom variables in Sphinx queries

I need execute 2 queries by one queue and passing result of first query to IF expression of other query as well as ordinary MySQL queries. As example, I try pass @average variable into second query: SET @average=(SELECT AVG(weight()) avg_rank FROM…
Daniyal
  • 129
  • 2
  • 9
0
votes
2 answers

How does Sphinx store null fields, and how does this affect performance?

I'm thinking about using asking sphinx to index many fields (in the hundreds), many of which will be null. My question is how much having many null fields will affect performance? This situation arises not from having incredibly denormalized data,…
Ben Crouse
  • 8,290
  • 5
  • 35
  • 50
0
votes
1 answer

Magento mirasvit sphinx search module is not working with mana layered navigation module

I am using magento community version 1.9 and I have integrated mirasvit sphinx search extension but it is not working with Layered Navigation module. I am filtering search result with Mana layered Navigation but it is still showing me the same…
Mohd Zahid
  • 59
  • 4
0
votes
1 answer

Regexp_filter on specific field of Sphinx Index?

I have been using regexp_fitler to good effect in my Sphinx configurations, however as far as I know it applies to the entire index in my select. If my select for idx_example is: Select Name,Description,City,State from TableA and I do a…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

ThinkingSphinx group_by causing slow searches

Setup: Rails 4 MySQL ThinkingSphinx I have a model (Record) in my app with almost 500 million rows. This model has 32 fields, but the only two I care about for a particular Sphinx search are name and token. name is what I am searching against…
CDub
  • 13,146
  • 4
  • 51
  • 68
1 2 3
…
99 100