First time here? Check out the FAQ!
Ask Your Question
1

Can I use MySQL InnoDB?
 
   
  
 
 
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.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    updated 13 years ago 
 
 
 
 
 codedigger's avatar

      41
    
 
 
 
 codedigger 
 
 
    asked 13 years ago 
 
 
 
 
        
 
 
 
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's avatar Evgeny (13 years ago)   
 
 
  
 
  see more comments  
 
 
 
 
 
 2 Answers
  
  
   
 
 
 
 
0
 
 
  
 
 
 
 
 
 
@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.
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 nil's avatar

      1
    
 
 
 
 nil 
 
 
    answered 13 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
  see more comments  
 
 
 
   
 
 
 
 
0
 
 
  
 
 
 
 
 
 
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)
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    updated 13 years ago,
        
    answered 13 years ago 
 
 
 
 
     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's avatar codedigger (13 years ago)   
 
 
  
 
 
  
 
 

        Ok, I will provide a fallback to simple search for InnoDB, but for Haystack - need to look into it first, will try though.
      
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
 
  
 
 

        Sphinx search is now available.
      
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
  see more comments