WordPress.org

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"