Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

G-Man

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
1  
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

2 Answers 2

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

 
discard

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.