June 20, 2013

Post: Full text search for all MySQL Storage Engines

… build in full text search is currently limited only to MyISAM search engine as well as has few other limits. Today Sphinx Search plugin for… use full text search solution for all storage engines. This version also adds a lot of other new features, including boolean search and distributed searching… about Sphinx Search Egine, comparing it to built in FullText search and Mnogosearch. I guess I should soon repeat tests, adding Lucene to…

Page: Presentations

…. Download Effective Full Text Search for Databases Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007 Short presentation introducing Sphinx Full Text Search solution and comparing… in full text search functionality using real medium size text collection – Wikipedia Articles dump, when we compare it to other opensource full text search search engines such as lucene

Post: Sphinx Developer joins our team

…’re happy to announce Andrew Aksyonoff, developer of popular OpenSource full text search software Sphinx joins our team. Andrew will now have more… complex full text search applications – but If you’re looking at smaller search applications we can help you getting most of MySQL build in full text search… for other reasons we can help you with using Lucene or other external search system. Finally having Andrew onboard we’ll be…

Post: What did we want Interns to do

… which present typical web LAMP application workloads Full Text Search Benchmark – we would like to get comparison for MySQL build in full text search, Sphinx, Lucene, PostgreSQL Searches.

Comment: EuroOSCON 2006 - High Performance FullText Search

… 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… already a MySQL shop then to have to deal with Lucene. Kevin

Comment: EuroOSCON 2006 - High Performance FullText Search

… 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 is…: It might sounds as I’m too negative to MySQL Full Text Search but just have seen too many people being stuck trying…

Comment: Sphinx: Going Beyond full text search

… compare” – do you mean search relevance performance or something else ? Note Sphinx is also really an external full text search engine, there is simply… use special stuff like post filtering by attributes grouping etc. Lucene has more features and Relevance is always arguable thing.

Comment: Cache Performance Comparison

…’re now working on FullText Search Engine comparison for MySQL and test MySQL Build in Full Text Search, Siena, Sphinx, Lucene indexing Wikipedia database and…

Comment: MySQL Performance Blog now uses Sphinx for Site Search

Paolo, Please check presentation page. It has full text search benchmarks for Sphinx/Lucene/MySQL FT. Though all of them are somethat improved and we need to redo them the general idea stays the same.

Comment: EuroOSCON 2006 - High Performance FullText Search

[...] MySQL full text search. I will show you only one slide from this presentation which you can find on MySQL Performance Blog to demonstrate the speed difference between MySQL, Lucene and Sphinx on a 5GB test database (of [...]