WordPress Sphinx Search Plugin

WordPress Sphinx Search Plugin allows to use Sphinx Search Server power to enable ultra-fast and feature-rich search on WordPress-based websites. It is especially useful if your WordPress site becomes very large.

Search results are more relevant and you can search in posts, pages and comments using flexible search syntax, quickly sort the results by freshness, relevance or in both modes. This plugin comes with sidebar widgets to display the most recent searches, top and related search terms.

This plugin replaces WordPress’s built-in search functionality.

Key Features

• Sort search results by Relevance, Freshness or in both modes
• Related searches widget is a great SEO tool for finding related search terms
• Top searches widget is another SEO tool which displays top search terms when no related search terms found
• Latest searches widget is a SEO tool which is used to display latest search terms of those people are doing right now
• Widget settings have plenty of options to control widget behavior and quality of widget content
• Search through posts, pages and comments content
• Search Management Tools is a set of tools for managing search terms
• Search Statistics Tool is an analytic tool which can help you analyze search trends of your blog

Support

This plugin is developed by Ivinco. If you need commercial support, or if you’d like WordPress Sphinx Search Plugin
customized for your needs, we can help. Visit plugin website for the latest news.
See release notes, report bugs and feature wishes on Launchpad: https://bugs.launchpad.net/wp-sphinx-plugin

E-mail:
[email protected]

Websites:

WordPress Sphinx Search plugin website

WordPress Sphinx Search tutorial

Arbitrary section

Semi live update – “main+delta” scheme

To enable semi-live index updates also known as “main+delta” scheme,
the plugin will create the following table in your MySQL database:

# in MySQL
CREATE TABLE wp_sph_counter
(
    counter_id INTEGER PRIMARY KEY NOT NULL,
    max_doc_id INTEGER NOT NULL
);

If your WordPress installation’s table prefix is not “wp_”, substitute
the correct value.

Top and last search terms

In order to be able to store search statistics the plugin will run
the following SQL query during the activation process:

# in MySQL
CREATE TABLE wp_sph_stats (
    id int(11) unsigned NOT NULL auto_increment,
    keywords varchar(255) NOT NULL default '',
    date_added datetime NOT NULL default '0000-00-00 00:00:00',
    keywords_full varchar(255) NOT NULL default '',
        status tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY  (id),
    KEY keywords (keywords)
);

If your WordPress installation’s table prefix is not “wp_”, substitute it with
the correct value.

Start Sphinx Search at boot

How to automatically start Sphinx Search daemon at boot:

• In Debian based systems i.e. Ubuntu:
  % update-rc.d “/path/to/bin/searchd –config /path/to/etc/sphinx.conf” defaults
• In Redhat based systems i.e. Fedora:
  % chkconfig –add “/path/to/bin/searchd –config /path/to/etc/sphinx.conf”