Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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";

share|improve this question
For the benefit of those who might want to look into this but have never even heard of sphinx (the software) you could help out by listing the table creation query for us to look at. – John Gardeniers Apr 22 '10 at 21:35

I'm finding this rather confusing and a bit of a look over the Shpinx web site doesn't make things much clearer but, as I understand it, Sphinx adds functionality to MySQL datbases, supporting MyISAM and InnoDB. The creation query tells MySQL to create a table using the sphinx engine, which is not something MySQL normally understands. I therefore suspect that the query is either incorrect or incomplete. Alternatively, some component of Shpinx that should allow MySQL to recognise the new sphinx engine isn't working as it should.

share|improve this answer

Has your MySQL binary been built using a correctly SphinxSE-patched source?

Anything in your MySQL error logs?

Have you been able to create any SphinxSE tables?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.