Jun 26, 2014. Getting Started with Sphinx?

Here are a few videos those of you who are just getting started with Sphinx may find useful. The first video demonstrates a very simple implementation with Ubuntu, PHP, and MySQL. The second video is also about installing on Ubuntu. And, the last video discusses fulltext query syntax. Check ‘em out.

Quick Start with Ubuntu

This video follows the steps taken in this blog post (with a few minor deviations). So, if you like copying and pasting, take a look at it.

Many MySQLers have found Sphinx to be very useful in beefing up their full text search functionality. When compared with MySQL, Sphinx provides many more fulltext indexing and search options (and better performance).

The basic idea is this: add and install the PPA, put some data into a MySQL table, configure Sphinx to index that data, write some PHP (using mysqli commands) so that we can see the results of a Sphinx search in the browser. It’s a very basic demonstration for those of you who have never searched with Sphinx. Take a look (and make sure you view at the highest quality):


Another Example with Ubuntu

The steps taken in this video are outlined in this blog post.


Fulltext Search Operators

This video outlines Sphinx’s fulltext query syntax. And, we wrote about operator syntax and precedence caveats in this blog post. Watch to learn more about text search syntax with Sphinx.


Thanks for your interest. Want more tutorials? Go look here. And, if you have questions, please feel free to ask.

Happy Sphinxing!

Tags: , ,


« »

5 Responses to “Getting Started with Sphinx?”

  1. The slides in “Fulltext Search Operators” is not clear at all. The video tutorials initiative is good, keep it up.

  2. steve says:

    Thanks, Wasim. I’ll see about fixing them up.

  3. steve says:

    Updated the FTS operators video.

  4. Amit says:

    Hi,

    i have setup sphinx as per steps given and it is showing me verson number also, but i am not able to execute any statement of sphinx, i ha ve setup it on windows 7, and my mysql is running, i am able to run mysql statements but not able to run any of sphinx statement, i am using phpmyadmin to run mysql statements.

    i have tried below synytex but showing me error
    SELECT * FROM search WHERE MATCH(‘find me fast’);

    “search” is the table name

    Can anyone guide me?

    Thanks,
    Amit

  5. steve says:

    Hi Amit,
    What error are you seeing? That select statement looks good. I haven’t used the phpmyadmin interface to query Sphinx, so I’m not even sure if it’s possible. But, I’ll play around with it to see. For now, I’d suggest (if you are not doing this already) to query Sphinx via MySQL CLI.

Leave a Reply