Can I use MySQL InnoDB?

asked 2011-05-11 13:49:42 -0500

codedigger
41 ●3 ●2 ●4

updated 2011-05-12 14:59:25 -0500

Looks like only question and answer tables need fulltext index, which is not supported by InnoDB. What if I'm going to use a search engine for search of questions and answers anyway, can I not apply Migration 4 and use InnoDB? I have a lot of other tables in InnoDB and really don't want to fall back to MyISAM.

edit retag flag offensive close merge delete

Comments

Hopefully fixed now. I did not test with InnoDB though, but added some code that would make migration 4 pass for you and fallback to simple title match for the search.

Evgeny ( 2011-05-12 15:01:39 -0500 )edit

add a comment

2 Answers

Sort by » oldest newest most voted

answered 2012-01-12 04:59:13 -0500

nil
1 ●3 ●2 ●5

@Evengy, it would be great, if you have any documentation/article to say how we can configure haystack with askbot, it will be big+ for user like who prefer solr over sphinx.

Thanks, N.

edit flag offensive delete link

add a comment

answered 2011-05-11 14:04:42 -0500

Evgeny

13177 ●57 ●107 ●219 http://askbot.org/

updated 2011-05-12 14:59:02 -0500

As of version 0.6.86, it is possible, but still InnoDB does not support text search properly.

To completely fix this issue, we'll need to support some external search library, such as solr, sphinx, etc.

At the moment, with askbot the best options are either transition your other app to PostgresQL or with a quick fix on our part - accept loss of text search support - until we work with a specialized search library. (e.g. Django Haystack)

edit flag offensive delete link

Comments

If I'm willing to lose full text search, would the app still work for other functions under InnoDB? I'm already using Haystack and Solr, so I can provide search on my own page.

codedigger ( 2011-05-11 14:39:38 -0500 )edit

Ok, I will provide a fallback to simple search for InnoDB, but for Haystack - need to look into it first, will try though.

Evgeny ( 2011-05-11 14:49:30 -0500 )edit

Sphinx search is now available.

Evgeny ( 2011-07-17 23:12:51 -0500 )edit

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Can I use MySQL InnoDB?

Comments

2 Answers

Comments

Your Answer

Question Tools

Stats

Related questions

Can I use MySQL InnoDB? edit

Comments

2 Answers

Comments

Your Answer

Question Tools

Stats

Related questions

Can I use MySQL InnoDB?