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…
… 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…
… of mysql fulltext for the forum at http://www.tbg.nu In my case the problem with mysql fulltext were that my searches performed: * Using boolean search… All the three reasons above made mysql fulltext to virtually puke when a client performed a search which contained several commonly existing word. I…
… internally the mysql server needs to create some sort of temporary table (otherwise someone should explain to me why mysqls fulltext takes more… searches etc will be implemented in near future according to email conversations I have had with the developer and hopefully the performance…
7. peter: All results have been performed in boolean search mode. That is because in my case the client is … such bad result when using mysql fulltext because there will be too much data to process for mysql where the vectorstorage solution solves…, but when it comes to “10 most common words” search the mysql fulltext in boolean mode takes more than 800 seconds on this…
… topic as performance optimization in such short timeframe. Download High Performance FullText Search EuroOSCON 2006, Brussels, Belgium, September 2006 This presentation speaks about FullText search techniques for content stored in database focusing on delivering high performance for large databases. We look at performance properties of MySQL build…
Yes… FullText Search would be nice. I however would see MySQL to implement full text search on the top level and make interface all… as it is not exactly performance related feature Also if you’re looking to do full text search with Innodb you may… much faster than build in FullText search. The integration is not as seemless as with build in FullText search but still pretty simple compared…
… that improving performance probably increased the concurrency!) I put under monitoring all the parameters I could think of, and mysql processes showed… for fulltext search, so no InnoDB possible for now. My question is, is it possible that it is only related to a MySQL… opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM table? Peter, I owe you a beer, big…
… can find all word_id matching to the mask and perform the search. I would suggest to write request on sphinx Forum… or other full text search system with MySQL as plugin (not hack with storage engine) – for this to happen fulltext search interface would need to be rewritten to support multiple full text search engines behind it. Currently it…
Copyright © Percona Inc. • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.