Plugin Directory

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.

Download Version 3.3.1

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"

Requires: 2.0.2 or higher
Compatible up to: 3.2.1
Last Updated: 2011-10-25 Downloads: 7,934

Average Rating

5 stars
4 stars
3 stars
2 stars
1 star
(16 ratings)

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

Log in to vote.

0,1,0
50,4,2
0,3,0 0,1,0
100,1,1 100,1,1
100,2,2 100,3,3
100,3,3
0,1,0