I've got the latest version of sphinx installed. I have created the index with no problems and searchd starts up with no problems.
However, whenever I try to create a test table (straight from the docs I might add) mysql crashes.
I'm at wits end here.
Any ideas are appreciated.
Here's the query:
CREATE TABLE t1 ( 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";