Percona's MySQL & InnoDB performance and scalability blog
…’ve worked with both Lucene and MySQL full-text search and both are fairly decent. MySQL really doesn’t scale as much as Lucene but it’s really easy to implement and support. Much better to just use MySQL if you’re already a MySQL shop then to have to deal with Lucene. Kevin
…lucene,sphinx,tbgsearch,sienna, mnogosearch and perform benchmarks. Download Note: Following presentations were done while I was MySQL employee and so copyrighted by MySQL and published here with MySQL Permission….by adjusting schema and MySQL Server options, using DBT2 Benchmark as example….
Kevin, I can’t agree with you on final conclusion. First you have to identify your … MySQL FullText search should be used of course as it is simplest to use. You also can check sphinx which goes between Lucene and MySQL FullText Search in features and ease of use but which…
… to use it as MySQL Storage Engine. We believe Sphinx is faster especially if you’re working with very large data sets and use special stuff like post filtering by attributes grouping etc. Lucene has more features…
… smaller search applications we can help you getting most of MySQL build in full text search. If there are some features… for your application for other reasons we can help you with using Lucene or other external search system. Finally having Andrew onboard we…
Peter, Out of curiosity, how do the search results of Sphinx compare with the likes of say, Lucene. We must agree that there are pros and cons to using a embedded search engine in MySQL. What’s your take on this?
Copyright © Percona Inc. • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.