Percona's MySQL & InnoDB performance and scalability blog
… you have to identify your performance goals and than check solutions. For many data sizes or search requirements MySQL FullText search performance is unfortunately showstopper. There are some examples and benchmarks in presentation 
For tiny data size, ie search for…
…of a poor Sphinx search performance I find our customers face is misuse of search filters. In this …returned in 155ms. Doing the same thing in MySQL, assuming user_id is indexed and in cache… a selective search and then filtering, using attribute is orders of magnitude better than using a fulltext key…
… gave a talk on High Performance FullText Search for Database Content which is now available for download from MySQL Performance Presentations page We have plans… helpful for full text search benchmarks with your own data. It was great to see a lot of MySQL guys on the… conference which surprisingly attracted very few people – there were more MySQL current and ex employees than attendees. Might be it was…
MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are documented in the…_len, ft_query_expansion_limit, ft_stopword_file FullText search related variables. As FullText currently works with MyISAM tables these are MyISAM related…
…search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search…traditional MyISAM FTS. We’ll get to performance in the third installment. For now, the…mysql> set global innodb_ft_aux_table=’test/dir_test_innodb’; mysql> set global innodb_optimize_fulltext_only=1; mysql…
…” align=”alignright” width=”214″] InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.