Questions tagged [sphinx]

Questions about the Sphinx fulltext search engine.

Sphinx is a full-text search engine, publicly distributed under GPL version 2. Commercial licensing (eg. for embedded use) is available upon request.

Technically, Sphinx is a standalone software package provides fast and relevant full-text search functionality to client applications. It was specially designed to integrate well with SQL databases storing the data, and to be easily accessed by scripting languages. However, Sphinx does not depend on nor require any specific database to function.

4 questions
1
vote
1 answer

How to add sphinx engine to mysql 5.7?

On my Ubuntu 18.04 machine using mysql 5.7 I have installed sphinxsearch 2.2 and now I'd like to add SphinxSE as an engine so that I can connect to it without language-specific medium. The docs on sphinix is rather old (for MySQL 5.1.x) and…
Karlom
  • 165
  • 4
0
votes
0 answers

MySQL: Using Symbolic Links for Databases on linux

Someone gave me a database. It's (1) a folder containing files with the following extensions: MYD, MYI, TRG, TRN, frm, opt; (2) a file with the sql-extension called db_add_nodata.sql , and (3) a file called sphinx.conf I have generated my database…
Mikke Mus
  • 101
  • 1
0
votes
1 answer

List sorted Posts on Group and children Groups efficiently

Say I have a system that has Groups and Posts on those Groups. A Group can have multiple "child Groups" Group 1 > Group 2 > Group 3 Group 1 > Group 2 > Group 4 Group 1 > Group 5 > Group 6 ... So I have these two tables: Groups (*GroupId*, Name,…
Nuno
  • 829
  • 1
  • 12
  • 24
0
votes
1 answer

How to select more than 20 rows in SPHINX engine?

I use SphinxSE instead of FULLTEXT. Sphinx settings are for end-users of a search engine. According to the official documentation, LIMIT clause. Both LIMIT N and LIMIT M,N forms are supported. Unlike in regular SQL (but like in Sphinx API), an…
Googlebot
  • 4,551
  • 26
  • 70
  • 96