June 20, 2013

Post: Full text search for all MySQL Storage Engines

June 26, 2006 By 37 Comments

… 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…

Filed Under: Insight for DBAs Tagged With: ,

Page: Presentations

May 3, 2006 By

…. 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…

Filed Under:

Post: Sphinx Developer joins our team

January 8, 2007 By 7 Comments

…’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…

Filed Under: Events and Announcements Tagged With:

Post: What did we want Interns to do

October 5, 2007 By 1 Comment

… 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.

Filed Under: Events and Announcements Tagged With:

Comment: EuroOSCON 2006 - High Performance FullText Search

September 22, 2006 By 4 Comments

… 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

Filed Under: Events and Announcements Tagged With: ,

Comment: EuroOSCON 2006 - High Performance FullText Search

September 23, 2006 By 4 Comments

… 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…

Filed Under: Events and Announcements Tagged With: ,

Comment: Sphinx: Going Beyond full text search

July 24, 2007 By 18 Comments

… 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.

Filed Under: Insight for Developers Tagged With: ,

Comment: Cache Performance Comparison

August 10, 2006 By 74 Comments

…’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…

Filed Under: Insight for Developers Tagged With:

Comment: MySQL Performance Blog now uses Sphinx for Site Search

February 19, 2008 By 52 Comments

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.

Filed Under: Insight for Developers Tagged With: , ,

Comment: EuroOSCON 2006 - High Performance FullText Search

February 14, 2008 By 4 Comments

[...] 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 [...]

Filed Under: Events and Announcements Tagged With: ,
« Older Posts