3,430
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + + + + + + + + + + − − Going to run the following in the DB: − CREATE TABLE AttachmentsIndex ( − id BIGINT NOT NULL, − weight INTEGER NOT NULL, − query VARCHAR(3072) NOT NULL, − INDEX(query) − ) ENGINE=SPHINX CONNECTION="sphinx://127.0.0.1:3312/rt" CHARACTER SET utf8 − − Line 58:
Line 59: − +
no edit summary
Log into mariadb as root and run <code>INSTALL SONAME 'ha_sphinx';</code> then <code>show engines;</code> to confirm it worked
Log into mariadb as root and run <code>INSTALL SONAME 'ha_sphinx';</code> then <code>show engines;</code> to confirm it worked
== Create Table ==
CREATE TABLE AttachmentsIndex
(
id INTEGER UNSIGNED NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
group_id INTEGER,
INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://localhost:9312/test";
== More output ==
<pre>
<pre>
You can now configure RT to use the newly-created full-text index by
You can now configure RT to use the newly-created full-text index by
searchd {
searchd {
port = 3312
port = 9312
log = /opt/rt4/var/sphinx/searchd.log
log = /opt/rt4/var/sphinx/searchd.log
query_log = /opt/rt4/var/sphinx/query.log
query_log = /opt/rt4/var/sphinx/query.log