May 23, 2012

Post: What to do with MySQL Full Text Search while migrating to Innodb ?

September 10, 2009 By 12 Comments

… to have stale data in search results it can work pretty well. Use Sphinx or other external full text search engine This is what we use a lot especially if performance of full text search is an issue to… it often takes just couple of hours to get the full text search running Sphinx instead of build in full text search.

Filed Under: Insight for Developers Tagged With: ,

Post: MySQL Full Text Search in Action

February 7, 2008 By 9 Comments

… shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will give… to become visible in search results. I’m wondering if that is replication lag or issues with full text search index updates as I… not the case with MySQL Full Text Search which both will skip to frequent keywords in natural language search and because it is using…

Filed Under: Insight for Developers Tagged With:

Post: Sphinx: Going Beyond full text search

July 23, 2007 By 18 Comments

… with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against over 1 billion… for SQL databases rather than full text search applications. Group By was added to Sphinx so we could search number of matches per day… Sphinx. This also uses fair amount of tricks using fake full text search to retrieve all posts from given web site or forum…

Filed Under: Insight for Developers Tagged With: ,

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…

Filed Under: Insight for DBAs Tagged With: ,

Post: FaceBook Search, Search for social networks

August 12, 2007 By 4 Comments

… profile search is rather simple full text search features are required. As ordering is not done by relevance what is required is simple boolean full text search. Also FaceBook search does…

Filed Under: Events and Announcements Tagged With: ,

Post: BoardReader - Forum Search Engine

November 29, 2006 By 12 Comments

… on crawler in this project only on database Backend and full text search engine implementation. In this part it is standard LAMPS application… and S Stands for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At this point we… found matching this terms right from search results. It can show quite interesting data, for example searching Britney Divorce will show huge…

Filed Under: Events and Announcements Tagged With:

Post: EuroOSCON 2006 - High Performance FullText Search

September 22, 2006 By 4 Comments

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

Filed Under: Events and Announcements 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… build 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…

Filed Under:

Post: Talking MySQL to Sphinx

April 19, 2009 By 4 Comments

… not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of other queries, not using Full Text Search. [root@r27 sp]# mysql…

Filed Under: Insight for Developers Tagged With:

Comment: Full text search for all MySQL Storage Engines

July 2, 2006 By 37 Comments

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

Filed Under: Insight for DBAs Tagged With: ,