WordPress.org

Ready to get started?Download WordPress

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.

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.9.1
Last Updated: 2014-4-23
Downloads: 23,526

Ratings

4 stars
4 out of 5 stars

Support

0 of 2 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

1 person says it works.
0 people say it's broken.

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 100,1,1
0,1,0
100,1,1 100,1,1
0,1,0
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1