使用myisam全文表来索引回innodb表，例如：
使用innodb构建系统：
create table users (...) engine=innodb;create table forums (...) engine=innodb;create table threads(forum_id smallint unsigned not null,thread_id int unsigned not null default 0,user_id int unsigned not null,subject varchar(255) not null, -- gonna want to search this... !!created_date datetime not null,next_reply_id int unsigned not null default 0,view_count int unsigned not null default 0,primary key (forum_id, thread_id) -- composite clustered PK index)engine=innodb;
现在是全文搜索表，我们将使用它来索引回innodb表。您可以使用触发器或每晚进行批更新等来维护此表中的行。
create table threads_ft(forum_id smallint unsigned not null,thread_id int unsigned not null default 0,subject varchar(255) not null,fulltext (subject), -- fulltext index on subjectprimary key (forum_id, thread_id) -- composite non-clustered index )engine=myisam;
最后，您从php /应用程序调用的搜索存储过程：
drop procedure if exists ft_search_threads;delimiter #create procedure ft_search_threads(in p_search varchar(255))beginselect t.*, f.title as forum_title, u.username, match(tft.subject) against (p_search in boolean mode) as rankfrom threads_ft tftinner join threads t on tft.forum_id = t.forum_id and tft.thread_id = t.thread_idinner join forums f on t.forum_id = f.forum_idinner join users u on t.user_id = u.user_idwhere match(tft.subject) against (p_search in boolean mode) order by rank desclimit 100;end;call ft_search_threads('+innodb +clustered +index');希望这可以帮助 ：）
