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

Searching in polygons in sphinx using Thinking Sphinx

I have setup thinking sphinx for real-time indexing and It works very well and search with geodist as well.But now I want to search the records within polygon. Sphinx documentation explains it very well at Geo-distance searching now I want to use…
Qaisar Nadeem
  • 2,404
  • 13
  • 23
0
votes
1 answer

sphinx search query first 20 order by title WEIGHT and next 20 by title ASC no duplicate output

How to select via sql command on sphinx first first 20 rows order by title WEIGHT and next 20 order by title ASC ( total 40 results ) on the same sql command but to don't give duplicate title output. I try this sql command but all title results is…
Matei Zoc
  • 3,739
  • 3
  • 16
  • 18
0
votes
1 answer

Sphinx 404 to Search

Will it be bad SEO(or anything else) practice to enable Magento Sphinx extension's "404 to Search" option for an e-commerce website? This option basically redirects from 404 to search results page.
Kabelo2ka
  • 419
  • 4
  • 14
0
votes
1 answer

SphinxSE Returning Strange Results

I have the following SphinxSE query that is returning some strange results: select…
Don Ellis
  • 71
  • 1
  • 8
0
votes
1 answer

Are there alternative/deeper ways to analyze a Sphinx Query besides `Show Meta`?

I have a complex Sphinx Config which utilizes regepx and wordforms as well. Often I get unexpected results and have started using Show Meta to see what my various manipulations are actually searching for. I have records 1,2 and 3 that should each…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

SphinxSearch indextool dumpdict what is the output format?

Executing indextool: indextool --dumpdict myindex gives output like this: anymore,1,1,329756 baltimore,3,5,153685 Obviously the first column is the keyword, what are the other columns?
joshweir
  • 5,427
  • 3
  • 39
  • 59
0
votes
1 answer

Best way to approximate "Includes" in Sphinx?

I have a very long and complex sphinx config file with multiple indexes. The main one (idx_Main) is not only huge it indexes a 2 million+ record table. Sometimes I encounter unexpected search (SphinxQL) results and testing becomes a challenge due to…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

How to see what Sphinx is actually finding?

I am getting unexpected results from a sphinxql query from a very large database and a very complex configuration file. I'm stumped trying to figure out what i'd be getting these results. Is there anyway to return the result and simultaneously find…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

Are there plans to add 'OR' to attribute searches in Sphinx?

A little background is in order for this question since it is on surface too generic: Recently I ran into an issue where I had to move the attribute values I was pushing into my sphinxql query as full-text because the attribute needed to be part of…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
2 answers

How to PHP Search when miss one character?

I'm finding a solution for search. There are few product with name: USB Kingston 8GB USB Kingmax 8GB USB Transcend 8GB USB Sandisk 4GB I'm using mysql database, I've tried FullText Search. SELECT * FROM PRODUCTS WHERE MATCH('productName') AGAINST…
John Morison
  • 41
  • 1
  • 5
0
votes
2 answers

Rotating vs Restarting Sphinx

I have a config file that takes a long time to rotate using the indexer to do so e.g. indexer --config /home/indexer/MyConfig.conf.php --rotate idx_Big I can live with that however sometimes when I want to test an updated config it might either…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
0 answers

Sphinx rotation not removing old records?

I removed records from a table using a Mysql Editor. This table was previously indexed by Sphinx (using indexer --rotate). When I re-rotate again using indexer --rotate the old record can still be queried. To test whether the index is actually being…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
0 answers

Slash or Space in sphinxql in a faucet field does not work

I have a query like this: select id from myindex where match('main search keywords') and myfilter in ('somevalue') order by weight() desc limit 0,50 option max_matches=5000 facet myfilter limit 5000 And the sphinx conf has this attribute…
Imran Ahmed
  • 790
  • 1
  • 9
  • 22
0
votes
1 answer

Recombine Sphinx Shards?

I have a large complex Sphinx configuration running on a large database. Because it was taking a long time to rotate, we set it up to multi-thread using mutliple cores/cpus. This cut down the time neede to rotate significantly naturally. However the…
user3649739
  • 1,829
  • 2
  • 18
  • 28
0
votes
1 answer

sngrl sphinx search can't understand how it works

I am using Laravel 5.3 and i was trying to use sngrl sphinx, following this git : https://github.com/sngrl/sphinxsearch. I followed all the installation and configuration steps, but in the end when i try to use, i got always return null ( the answer…
António Gonçalves
  • 1
  • 1
1 2 3
…
99 100