May 23, 2012

Comment: Announcement of Percona XtraDB Cluster 5.5.23

Support for MyISAM, now changes to MyISAM tables are replicated to other nodes means is supported fulltext index and search?

Post: EuroOSCON 2006 - High Performance FullText Search

… just Europe thing. I gave a talk on High Performance FullText Search for Database Content which is now available for download from…’ve done so it will be helpful for full text search benchmarks with your own data. It was great to see…

Post: Full text search for all MySQL Storage Engines

… full text search is currently limited only to MyISAM search engine as well as has few other limits. Today Sphinx Search plugin for…, including boolean search and distributed searching. A while ago I already wrote about Sphinx Search Egine, comparing it to built in FullText search and Mnogosearch…

Comment: Full text search for all MySQL Storage Engines

… the mysql fulltext has it limitations specially when used in boolean mode on large results (for example a boolean search that searches on… own fulltext engine ?). However I found some issues with the standalone testversions which ended up with that I created my own fulltext search… if I could do it any better for my case (fulltext search engine for a forum). What I have done is to…

Comment: EuroOSCON 2006 - High Performance FullText Search

… 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 your personal DVD collection MySQL FullText search should be used of course as it…

Comment: My Innodb Feature wishes

Yes… FullText Search would be nice. I however would see MySQL to implement full text search on the top level and make interface… feature :) Also if you’re looking to do full text search with Innodb you may give a try to http://www… much faster than build in FullText search. The integration is not as seemless as with build in FullText search but still pretty simple compared…

Page: Presentations

… short timeframe. Download High Performance FullText Search EuroOSCON 2006, Brussels, Belgium, September 2006 This presentation speaks about FullText search techniques for content stored in… dump, when we compare it to other opensource full text search search engines such as lucene,sphinx,tbgsearch,sienna, mnogosearch and perform…

Comment: Beware of MyISAM Key Cache mutex contention

… the same key_cache and the table is used for fulltext search, so no InnoDB possible for now. My question is, is… opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM table? Peter, I owe you a beer, big…

Comment: ORDER BY ... LIMIT Performance Optimization

… on FullText Search performance to see other things which will be painfully slow: http://www.mysqlperformanceblog.com/files/presentations/EuroOSCON2006-High-Performance-FullText-Search

Comment: ORDER BY ... LIMIT Performance Optimization

…. Basically I want to optimise a query that uses a fulltext search and orders by a stactic field. I.e. SELECT * FROM… a precomputed score field. I have indexes built on the fulltext and score seperately. I cant combine them as they are different types. However, as mysql only uses the fulltext index it is forced to filesort for the orderby. And…