Jump to content


Photo

innoDB fulltext search?


  • Please log in to reply
3 replies to this topic

#1 chico1st

chico1st
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 22 August 2006 - 12:30 AM

I have all innoDB tables but i need to do a fulltext search, I have search and read a lot but all of them need a FULLTEXT INDEX which i would create by going like this:

CREATE FULLTEXT INDEX full_index ON `news`(
  `name` ,
  `abstract` ,
  `fulltext`
  );

but i get this error: 'The used table type doesn't support FULLTEXT indexes '

is there an innoDB equivalent or have I destroyed all my chances of searching?
THANKS FOR ALL THE HELP!


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 22 August 2006 - 03:47 AM

Nope, no equivalent yet -- but they keep talking about it.  There are some non-standard engines that do support it, but I've never used them in a production environment.

Of course, there are always way around it -- like keeping these fields, or a copy of them, in a MyISAM table.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 chico1st

chico1st
  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 22 August 2006 - 04:21 AM

if i change from innoDB to myIsam what will change? will I have to modify my code?

ive looked into replication and i dont think i want to deal with that

the speed of my inserts/updates really doesnt matter to me because i have very low traffic but i keep
hearing the word reliable thrown around, which is important.. i dont want my db's dieing on me.

however i feel like reliability means something different in the database
world.. just because that seems to be the trend :P

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 22 August 2006 - 01:40 PM

InnoDB just gives you ACID compliance, transactions, and FK constraints.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users