Nothing is wrong with rolling back, do we need it though (talking from the project POV)?

I was always told that if the table was going to receive more SELECT queries than INSERTS, UPDATES, DELETES .... then MyISAM was the engine to choose, I could be wrong I'm no DB Admin.

Also I don't think innoDB supports full-text indexing.

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)